Oracle Transactional Business Intelligence

Products Banner

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



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


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?