Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BICC : Last Extract Date for PVOs reset only if the Extract Schedule completed successfully

51
Views
0
Comments

Summary

Update the logic to ensure Last Extract Date for PVOs resets only if the whole Extract Schedule completed successfully

Content

Currently, we have instances where when we are running an Extract schedule , some PVOs might fail resulting in No Manifest file being generated or files/data being available for processing even on the ones that succeeded. 

The next time the process runs, even though all the PVOs are from the same offering, the Last Extract Date is different resulting in window being different for PVOs. This is causing us issues in the replication audit as well as defining a robust process.

Can we change the logic in BICCC to update the Last Extract Date of a PVO only after the Extract Schedule is completed successfully?