Query on deletion of PO / PO line of PO in Incomplete status
SummaryQuery on deletion of PO / PO line of PO in Incomplete status
We have a source system which is pushing requisitions into a custom PaaS application. In this applications we are selecting requisitions and creating PO which is pushed into Oracle in Incomplete status.
We have the requirement that if a PO line is deleted in Oracle or the entire PO is deleted in Oracle, then the requisition lines should be available back in the PaaS application for reprocessing. As in Oracle if a PO / PO line is deleted, no record is maintained for it in the po tables, wanted to check do we have any business event which can be triggered at deletion and using the business event information for deleted line can be sent back to the PaaS application ?