OBIA 7964 LAST_EXTRACT_DATE Is Getting Set to Default Date during ETL load (Doc ID 2043701.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

OBIA 7.9.6.4, DAC Build AN 11.1.1.6.4.20121119.2022.

DAC execution parameter $$LAST_EXTRACT_DATE is getting set to the default date. For example:  1-1-2006 during load execution which is wrong as $$LAST_EXTRACT_DATE parameter should be set to last load run date. 

In order to change PRUNE DATE to hours from days you have made changes to the DAC source system parameter $$LAST_EXTRACT_DATE using <Note 889803.1> How to control the value for DAC source system parameter $$LAST_EXTRACT_DATE?

On making changes suggested in above document you are seeing the following entries in your Informatica workflow session logs:

INFO : (1219 | DIRECTOR) : (IS | PowerCenter_Int_Service) : DEV_XXXX : VAR_27028 : Use override value [01/01/2006] for for mapping parameter:[mplt_BC_ORA_APInvoiceDistributionFact.$$LAST_EXTRACT_DATE].]

Note: The above mentioned default value for $$LAST_EXTRACT_DATE i.e. [01/01/2006] might differ in different user environment.The above case is just an value that was set for user which reported the issue.

The format defined for DAC source system parameter $$LAST_EXTRACT_DATE as per document (889803.1) was not identified by DAC hence it was overwriting LAST_EXTRACT_DATE value to the default value [01/01/2006] defined in parameterfileOLTP.txt

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