Using PO_DOCUMENT_UPDATE_GRP.UPDATE_DOCUMENT Procedure Error "Error: 1 - The Ship-to location (XXXX) on the Document Header is invalid."
Last updated on FEBRUARY 05, 2018
Applies to:Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
Reference <Note: 1406047.1 How to use Change PO API group package PO_DOCUMENT_UPDATE_GRP to make multiple changes to PO at once>
The error 'Line #&LINE_NUM shipment #&SHIPMENT_NUM The Ship-to location (&SHIP_TO_LOC) is invalid' for the old location when we are calling the API to update the ship to location update from old to new. why it is validating the inactive date of old ship to?
The program is giving error when trying to update the ship to location on the header of the PO. When the user should be able to update the ship to location on the PO if the existing ship to location is end dated or inactive due to valid reason.
This functionality is allowed as long as the new ship to location is related to the same inventory organization.
This is perfectly working when the users do it from the front end using the forms.
Here is the snippet of code that is calling the API
STEPS TO RECREATE THE ISSUE
- Create and approve a multi line purchase order
- Set the code to change the location from the original to a new location with an inactive date of sysdate/current date
- Run the code to update the PO
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms