Last updated on MARCH 08, 2017
Applies to:Oracle Spares Management - Version 188.8.131.52 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
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