We need to import Purchase orders from legacy on weekly or daily basis, There could be Contract purchase orders also. But Interface program is not picking up those records which are of Contract PO type, and when checked with Oracle, they said its not handled and the work is in progress to handle CPAs.
Could any one please let me know what could be the best way of import CPAs. Our client dont want to use data loader for this nor ok for a direct insert into base tables.
Please let me know if any public or private apis we have or any other process.
Thanks in advance.
(Actually I posted this in EBS General discussion, but have not received any response, so duplicating it here)
We faced this issue at our client. All CPA's, we have loaded using data loader as there was no oracle provided API. Our client could not agree to use a custom component (custom built API) to migrate CPA's, so we went ahead with data loader way.
But we have interface for POs. Its like legacy will be sending files daily and without any interference those are to be processed automatically.
Please let me know if any one achived this type of reqirment.