My Oracle Support Banner

Spares Management: APP-239061 Error When Trying to Perform Ship Confirm For Move Order (Doc ID 1958984.1)

Last updated on FEBRUARY 06, 2022

Applies to:

Oracle Spares Management - Version 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.