OBIA: COMPLETION_DT In W_TASK_D Is Not Getting Updated During Incremental Loads (Doc ID 2134617.1)

Last updated on AUGUST 11, 2017

Applies to:

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

Symptoms

In a customized scenario, observed that COMPLETION_DT in W_TASK_D is not getting updated. There is a TASK_NUMBER which have COMPLETION_DT in EBS but it hasn't gotten an update in W_TASK_D.

The staging table W_TASK_DS is getting populated using W_ORA_TASK_PS as source.
When checking the incremental logic in the mapping of W_ORA_TASK_PS, it doesn't include PA_TASKS in it. If there was an update in PA_TASKS, the incremental logic would not pickup that row.

Sample Incremental logic:


RUN_FULL_INCREMENTAL(
'#IS_INCREMENTAL',
1=1,
RUN_REPLICATED_TRANSACTIONAL(
'#IS_SDS_DEPLOYED',
PA_PROJ_ELEMENTS.LAST_UPDATE_DATE>TO_DATE_VAR('#LAST_EXTRACT_DATE'),
PA_PROJ_ELEMENTS.CDC$_SRC_LAST_UPDATE_DATE>TO_DATE_VAR('#LAST_EXTRACT_DATE')))

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