In all likelihood, you'll want to customize the ETL functionality in Oracle Business Intelligence Applications.
Topics
What is Customization in Oracle Business Intelligence Applications?
Category 1 Customizations: Adding Columns to Existing Fact or Dimension Tables
Category 2 Customizations: Adding Additional Tables
Category 3 Customizations: Adding New Data as a Whole Row into a Standard Dimension Table
Customizing Stored Lookups and Adding Indexes
Scripting on this page enhances content navigation, but does not change the content in any way.