Disabling Projects Invoice Line Fact in the Repository for Oracle Fusion Applications
By default, the Billing metrics are mapped to both Invoice Line Fact -W_PROJ_INVOICE_LINE_F and Invoice Line Distribution Fact -W_PROJ_INVOICE_DIST_F. For customers whose only data source is the Fusion database, the Invoice Line fact is an obsolete table and has to be disabled.
Prerequisites:
Oracle recommends that before you start this process you make a back up of the BI metadata repository (that is, the RPD file).
To Disable Projects Invoice Line Fact, first disable metrics that are defined only in the line fact, then disable the invoice line fact. These metrics are around the Retention area and are not supported in the Oracle Fusion Applications currently.
- To delete unnecessary metrics, see Deleting Unnecessary Metrics.
- To disable Invoice Line Fact, see Disabling the Invoice Line Fact.