PO Interface using po_headers_interface and Import Standard Purchase Orders
Question: Can we use the field request_id in the table po_headers_interface to populate the request_id of our custom process?This is not working in R12.
In 11i, our custom concurrent program (PLSQL type) does the following:
populate the table po_headers_interface, po_lines_interface, po_distributions_interface.
During this, our custom process populates the field request_id in po_headers_interface with the request_id of the custom concurrent program.
Then it launches the "Import Standard Purchase Orders" concurrent program.
The above process works well in 11i.
However in R12, the field request_id gets overwritten by the request_id of the "Import Standard Purchase Orders".
In 11i, our custom concurrent program (PLSQL type) does the following:
populate the table po_headers_interface, po_lines_interface, po_distributions_interface.
During this, our custom process populates the field request_id in po_headers_interface with the request_id of the custom concurrent program.
Then it launches the "Import Standard Purchase Orders" concurrent program.
The above process works well in 11i.
However in R12, the field request_id gets overwritten by the request_id of the "Import Standard Purchase Orders".
0