This content has been marked as final. Show 4 replies
Make sure that the ship_to_location_id on po_headers_all and po_line_locations_all is valid.
It seems that the data has changed and somehow those locations are not valid anymore.
Did someone update the po_tables or hr_locations table using sql?
Thanks for your response. Unfortunately since I do not get involved with the tables I would not know if someone messed around with them but I can check.
I did receive an offline recommendation which is as below and would like to authenticate if this can be used.
FRM-40105:Unable to resolve reference to Item PO_HEADERS.SHIP_TO_LOCATION_ID
1. Navigate to Purchasing Responsibility
2. Purchase Order > Release
3. Enter release information
4. Click on save button.
This issue occurs only after applying Patch 5447380
Bug fix for Bug.5404363 references the field 'po_headers.ship_to_location_id'. The library which uses this reference
is called from both the Purchase Order Form as well as the Release Form. The reference to this field was not required on the Release form and hence displays the error message before saving the form.
Apply Patch 5759435 or later. Update file POXPODIS.pld to version 115.152.11510.20 or higher.
No harm in applying the patch to a test instance and see if it resolves the problem.
Was just curious if you or any other gurus have tried this patch before.