This content has been marked as final. Show 4 replies
The requisitions interface does create records in po_req_distributions. To use the interface, you insert records into PO_REQUISITIONS_INTERFACE_ALL and1 person found this helpful
Can you check if that works for you?
Edit: Oops - I meant PO_REQ_DIST_INTERFACE_ALL; not PO_RESCHEDULE_INTERFACE.
Edited by: Sandeep Gandhi, Independent Consultant on Apr 4, 2011 11:43 AM
Does the requisition interface import the data into only the table po_req_distributions_all as the requisition was already in other table. I need to insert only the distributions.
But you have users who manually create requisitions without distributions? Those requisitions must be in incomplete status.
I am not sure if the interface can create for existing requisitions.
If it does not, ere is one approach
Write a customization that creates records in the PO_REQUISITIONS_INTERFACE_ALL by looking at the incomplete reqs.
The custom code then creates records in PO_REQ_DIST_INTERFACE_ALL for the distributions.
Then the code cancels/deletes the original requisitions.
Then you run requisition import to create new requisitions with appropriate distributions.
If you keep requisition numbering manual, the new req. number can be the same as the old one that was deleted.
Thanks Sandeep. I will try this approach.