Question

Purchase Order Migration issue

  • 5 January 2023
  • 1 reply
  • 116 views

Userlevel 3
Badge +9

Hi all.

There is a need to migrate open Purchase Orders from one site (contract) to another.

I have setup a Source Migration job .. 

 

But when I come to run the job (for one PO), I am getting this error message

ORA-20110: PurchaseOrderLinePart.NOSUPPURCHPARTEXIST: Supplier for purchase part does not exist for the demand site.

I’ve checked the attribute string and the Order Number (which I believe will be the new Order Number) does not exist. 

It seems step 10 (header) has not commit before steps 20 has run - hence the error message  

Any idea why this would be the case?


1 reply

Userlevel 2
Badge +10

Hi

The error appears to be referring to the ‘Supplier for Purchase Part’, not the PO itself.

The ‘Supplier for Purchase Part’ is site specific.  Is the supplier on the PO set up as a supplier for each part on the PO for the new site?

Hope this helps!

 

Reply