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 25, 2019

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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