My Oracle Support Banner

OBIA 796x: W_PROJ_COST_LINE_F Not Loaded Correctly During Incremental Loads (Doc ID 1373253.1)

Last updated on FEBRUARY 02, 2018

Applies to:

Business Intelligence Applications Observer - Version 7.9.6 [1340] and later
Information in this document applies to any platform.


You have implemented OBIA for EBS R12.1.1 and are facing data issues in project module's time sheet data. Incremental ETL does not bring all the timesheet data from EBS.

The current incremental logic based on REQUEST_ID could result in some data getting filtered from the ETL extract which loads the Project Cost and Project Revenue line facts. You are requested to check the counts in the source as well as in the data warehouse (DW) to first verify if it is an issue and to apply the following fix if an issue is found.

Source SQL for verification: count(*) from PA_COST_DISTRIBUTION_LINES_ALL; count(*) from (select EVENT_NUM from PA_CUST_EVENT_RDL_ALL UNION ALL

DW SQL for verification: count(*) from W_PROJ_COST_LINE_F; count(*) from W_PROJ_REVENUE_LINE_F;

In your EBS you have scheduled a concurrent request to be run on future dates for loading or updating the data in PA_COST_DISTRIBUTION_LINES_ALL table.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.