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

Last updated on MARCH 08, 2017

Applies to:

Oracle Spares Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.2 version, Spares Logistics

When attempting to ship confirm a move order, the following error occurs:

ERROR
-----------------------
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:
Cause: &SQLERRM
Action: Please contact your technical representative.

(SQLEERM= User-Defined Exception)


STEPS
-----------------------
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

Cause

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