OBIA 11.1.1.10.2- SDE_PSFT_GLSEGMENTDIMENSION_ACTIVITY_ID running in full mode instead of incremental load (Doc ID 2285289.1)

Last updated on JULY 24, 2017

Applies to:

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

Symptoms

On : 11.1.1.10.2 version, DataWarehouse
Mapping Name: SDE_PSFT_GLSEGMENTDIMENSION_ACTIVITY_ID
Source : PSFT9.2
OBIA 11.1.1.10.2


OBIA 11.1.1.10.2- SDE_PSFT_GLSEGMENTDIMENSION_ACTIVITY_ID not using any date to extract data

We are using OBIA 11.1.1.10.2 and one of the GL Segment mappings is running in full mode when it is suppose to run in incremental mode.  That mapping is extracting all the records from a table SYSADM.PS_PROJ_ACTIVITY which in our case is 6470462 and this is overloading the SIL task which needs to update all these records in the staging. Could you let us know why the date logic for extracting is missing in this mapping.

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