OBIA: COMPLETION_DT In W_TASK_D Is Not Getting Updated During Incremental Loads
Last updated on OCTOBER 04, 2017
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.1 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