Spares Management: APP-239061 Error When Trying to Perform Ship Confirm For Move Order
(Doc ID 1958984.1)
Last updated on FEBRUARY 25, 2019
Applies to:Oracle Spares Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
On : 12.2.2 version, Spares Logistics
When attempting to ship confirm a move order, the following error occurs:
APP-239061: Unexpected errors found while validating the profile_option_value in the procedure CSP_MO_LINES_MANUAL.
Cause: There may be data corruption in the table fnd_profile_option_values or the table was not setup correctly. An example when this error occurs is more than one records are returned when the routine is expecting only one unique record.
Action: Please contact your system administrator.
APP-239061: Execution of procedure Confirm_Ship failed because the following unexpected errors occurred:
Action: Please contact your technical representative.
(SQLEERM= User-Defined Exception)
The issue can be reproduced at will with the following steps:
1. Create Move Order
2. Create Reservations
3. Print Pick Lists
4. Confirm Picklists
5. Create Packlists, Box, add items
6. 'Ship Confirm' Move Order
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