Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities
Requisition Interface - Printable Version

+- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com)
+-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html)
+--- Forum: Oracle E-Business Suite (EBS) (http://www.oraerp.com/forum-1.html)
+---- Forum: Purchasing, Inventory & Order Management (http://www.oraerp.com/forum-3.html)
+---- Thread: Requisition Interface (/thread-70950.html)



Requisition Interface - Usman - 02-26-2013

Hi All,
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.


RE: Requisition Interface - Kumar123 - 03-11-2013

Hi, I think through standard interface program this is not possible.
Cheers,