OBIA 11g SDE W_GL_LINKAGE_INFORMATION_GS_SQ_GL_JE_LINES Does Not Use The INITIAL_EXTRACT_DATE (Doc ID 1945459.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

In OBIA 11.1.1.7.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 ?



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