OBIA 7964 LAST_EXTRACT_DATE Is Getting Set to Default Date during ETL load
Last updated on JULY 17, 2017
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11 and later
Information in this document applies to any platform.
OBIA 18.104.22.168, DAC Build AN 22.214.171.124.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].]
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
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