OBIA: COMPLETION_DT In W_TASK_D Is Not Getting Updated During Incremental Loads

(Doc ID 2134617.1)

Last updated on OCTOBER 04, 2017

Applies to:

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


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:




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