OBIA 796x: W_PROJ_COST_LINE_F Not Loaded Correctly During Incremental Loads
Last updated on FEBRUARY 02, 2018
Applies to:Business Intelligence Applications Observer - Version 7.9.6  and later
Information in this document applies to any platform.
You have implemented OBIA 18.104.22.168 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.
a.select count(*) from PA_COST_DISTRIBUTION_LINES_ALL;
b.select count(*) from (select EVENT_NUM from PA_CUST_EVENT_RDL_ALL UNION ALL
select EXPENDITURE_ITEM_ID from PA_CUST_REV_DIST_LINES_ALL);
DW SQL for verification:
a.select count(*) from W_PROJ_COST_LINE_F;
b.select 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms