This content has been marked as final. Show 7 replies
I donot think it would be possible..in Oracle Purchasing for changing Ship-to ORG in an approved PO.
I believe once you changed Ship-to Org in an approved PO, the revised document has to be re-approved
the only option we had when trying to update the shipment is cancelling. This is the last thing we want because the po was advanced paid.
If we had to do it from the backend (database)
Is there any standard oracle script to update the ship to org field?
I need to know what tables exactly i have to update to avoid any future problems.
Kindly note that this issue is urgent...
Cancel the shipment and add a new line in the shipment window.
Kindly provide me with the detailed steps..
Also note that the Po is already approved once...
Since the PO is already paid, check with user if Receipt is mandatory. If its ok to skip receiving we can change the match level for the shipment to 2 way match and create invoice for the PO without receiving.
But if receipt is mandatory then we need to close the shipment and recreate the same shipment with correct Ship to org
Of course, updating the po from the backend is not recommended. It would be preferred that you reverse invoice distributions, cancel po shipments (and requisition lines as well if needed) , create new shipment lines with the right organization, receive and rematch the invoice.
But, if this is not possible then you should update the following tables: po_lines_locations_all, po_requisition_lines_all (if needed) , mtl_supply.
If you are trying to resolve the problem by data base update, then you need to update the following base tables.
po_line_locations_all (ship_to_organization_id column)
po_distribuitions_all (destination_organization_id Column)
And you need to update the corresponding columns in the archieve tables (po_line_location_acrhives_all &po_distribuition_archives_all ) also so as to avoid data inconstistency in future.