My Oracle Support Banner

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

Last updated on FEBRUARY 01, 2021

Applies to:

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



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


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.