Customization: Extending Mappings and Tables

• Existing mappings and tables are extensible.

• Sample placeholders demonstrate how to pass and store additional data.

• Oracle BI Applications provides a methodology to extend preconfigured mappings to include additional columns and load the data into existing tables.

– Do not modify existing logic or columns.

– Copy objects to custom folders before modifying.

In order to see additionalcolumns in the OracleBusiness Analytics Warehouse,the columns must first be passed through the ETL process. The existing mappings and tables are extensible. Oracle Business Intelligence Applications provides a methodology to extend preconfigured mappings to include these additionalcolumns and load the data into existing tables.

Oracle Business Intelligence Applications recognizes two types of customization: extension and modification. The supported extension logic allows you to add to existing objects. For example, you can extract additionalcolumns from a source, pass them through existing mappings, and populate new columns added to an existing table.

Generally, Oracle Business Intelligence Applications does not allow you to modify existing logic or columns. You should copy existing logic to custom folders, and then modify it. You should not change existing calculations to use differentcolumns, and you should not remap existing columns to be loaded from different sources.