Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 188.8.131.52.1 and later
Information in this document applies to any platform.
In OBIA 184.108.40.206.1 using EBS 11i
SDE_ORA_GLLinkageInformation_Extract.W_GL_LINKAGE_INFORMATION_GS_SQ_GL_JE_LINES does not use the INITIAL_EXTRACT_DATE.
Here is the expression :-
RUN_FULL_INCREMENTAL('#IS_INCREMENTAL', 1=1, RUN_REPLICATED_TRANSACTIONAL("#IS_SDS_DEPLOYED", (GL_JE_BATCHES.LAST_UPDATE_DATE > TO_DATE_VAR('#LAST_EXTRACT_DATE')), (GL_JE_BATCHES.CDC$_SRC_LAST_UPDATE_DATE > TO_DATE_VAR('#LAST_EXTRACT_DATE'))))
The GL SDE has the following "GL_BALANCES.LAST_UPDATE_DATE > TO_DATE_VAR('#INITIAL_EXTRACT_DATE')" instead of 1=1.
Is this the default behaviour to load all data in a full load even if INITIAL_EXTRACT_DATE has a value assigned, or this is a bug ?
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