Unable To Update Movement Statistics Record Using API INV_MGD_MVT_STATS_PUB.UPDATE_MOVEMENT_STATISTICS
(Doc ID 2307853.1)
Last updated on FEBRUARY 15, 2019
Applies to:Oracle Supply Chain Globalization - Version 12.1.3 and later
Information in this document applies to any platform.
The API INV_MGD_MVT_STATS_PUB is being used to update the origin_country_code for dispatch type verified Movement Statistics records.
There are two symptoms:
- The API returns the status "S" (Success) however the change is not actually made.
- The change is made (as seen in the table data) but the record is till not being updated and/or the following error occurs when trying to review the record in the Movement Statistics form.
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document