OBIA 7964 DAC Full Load For Project Analytics Failed With $$LAST_EXTRACT_DATE Substituted With Incorrect Date (Doc ID 2075095.1)

Last updated on JANUARY 30, 2017

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 and later
Information in this document applies to any platform.

Symptoms

In the DAC console, you have several EPs configured to transfer data from Oracle EBS to OBIA database, e.g. Financial Analytics, HR Analytics, Procurement Analytics and Project Analytics. However after running a full load for all the EPs, there is no data found for Project Analytics. The other EPs works fine and data is transferred to OBIA database as expected.

In the DAC console ->Design -> Source System Parameters tab, the $$INITIAL_EXTRACT_DATE has been set to value "20080101 00:00:00", and the $$LAST_EXTRACT_DATE is set as "@DAC_SOURCE_PRUNED_REFRESH_TIMESTAMP". After checking the ETL session log for the workflow SDE_ORA_Project, it is found that the $$LAST_EXTRACT_DATE has been substituted with value "09/02/2015 00:00:00” (MM/DD/YYYY HH24:MI:SS). Since all the data in your testing environment is between Jan-2014 and Jun-2015, the SQL in the workflow didn't returned any data.

Is the $$INITIAL_EXTRACT_DATE equal to the $$LAST_EXTRACT_DATE for a full load of the EP? Why does the Project Analytics behave differently? And how can you check the date that will be substituted in the SQL for the loading?

Cause

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