02-26-2013, 12:47 AM
I have a requisition in which I am inserting into PO_REQUISITIONS_INTERFACE_ALL. The requisition has 5 lines, no distributions.
I then run the Requisition Import Concurrent Program (REQIMPORT) and all the successful lines are inserted into the base tables successfully. Any failed lines with invalid values are omitted. So if 1 line failed, the requisition will have 4 lines in the base table (PO_REQUISITION_LINES_ALL ).
However, my requirement is that if one line fails, the requisition should not be created.
We have considered calling the Delete Requisition API to delete the incomplete requisition, then reprocess the requisition with correct values.
Has anyone come across this problem before? Any potential or better solutions?
Appreciate your help.