Walk through Oracle 10g Database Features and Enhancements

Something about 10g: Oracle Application Server 10g provides full support for the Java 2 Platform Enterprise Edition (J2EE), XML, and emerging Web services standards. With Oracle Application Server 10g, you can simplify the access to the information for your customers. With the release of 10g many new features are been provided to the developer that … Continue reading

Basics on Materialized View(MV) in Oracle

What is a Materialized View(MV) in Oracle? A materialized view is a database object that contains the results of a query. When you create a materialized view, Oracle Database creates one internal table and at least one index. Why to use MV? It advised to use materialized views if query involves summaries, large or multiple … Continue reading

MULTI – ORG Concept in Oracle Applications.

What is Multi-Org? It’s a feature used to store the data of multiple organization in a single instance by partitioning the data of human resource, financials, sales, purchases, assets and materials Examples of Multi Org are Tata Group, Reliance Group, Mahindra Group etc. Let us consider Tata Group to illustrate more on Multi Org In … Continue reading

Query for Bank Account information for Release R12

Query that retrieves bank account details at the Supplier Level for Release R12 SELECT ieba.ext_bank_account_id      , ieba.country_code      , ieba.branch_id      , ieba.bank_id      , ieba.bank_account_num      , ieba.masked_bank_account_num      , ieba.ba_mask_setting      , ieba.ba_unmask_length      , ieba.currency_code      , ieba.iban      , ieba.iban_hash1      , ieba.iban_hash2      , ieba.masked_iban      , ieba.check_digits      … Continue reading