How much time it will take to update the data in Archive table?

Charul Agrawal

We can get the requirement Invoice information from FND_BPM_TASK_HISTORY_B table which is an Archive table and recommended by Oracle as workflow tables would get purged frequently

Data is refreshed from workflow table into the archive table after certain duration/periodically and is not available real time.

Work flow table :

FA_FUSION_SOAINFRA.WFTASK

FA_FUSION_SOAINFRA.WFTASKHISTORY

FA_FUSION_SOAINFRA.WFTASK_VIEW

FA_FUSION_SOAINFRA.WFTASKHISTORY_VIEW

FA_FUSION_SOAINFRA.WFTASKTL_VIEW

FA_FUSION_SOAINFRA.WFCOMMENTS_VIEW

FA_FUSION_SOAINFRA.WFATTACHMENT_VIEW

FA_FUSION_SOAINFRA.WFASSIGNEE_VIEW

Archive table :

FND_BPM_TASK_B

FND_BPM_TASK_TL

FND_BPM_TASK_HISTORY_B

FND_BPM_TASK_HISTORY_TL

FND_BPM_TASK_ASSIGNEE

FND_BPM_TASK_COMMENT

FND_BPM_TASK_ATTACHMENT

Confirmation is required that after how long it will take for data to be updated.