Unable To Update Movement Statistics Record Using API INV_MGD_MVT_STATS_PUB.UPDATE_MOVEMENT_STATISTICS
Last updated on JANUARY 02, 2018
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
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