My Oracle Support Banner

WIP Negative Issue Error: You have encountered an unexpected error in csi_wip_trxs_pkg.deallocate_using_qty_per_assy, with error ORA-06502: PL/SQL: numeric or value error: character to number conversi (Doc ID 1439584.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Installed Base - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to process WIP Negative Issue (CSIWIPNI) transaction in Install Base the following error occurs.

You have encountered an unexpected error in csi_wip_trxs_pkg.deallocate_using_qty_per_assy, with error ORA-06502: PL/SQL: numeric or value error: character to number conversion error

Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Process CSIWIPNI transaction, and complete WiP Job
2. Install Base is not updated with CSIWIPNI or subsequent transactions on this job, including CSIWIPAC to put the machine back in stock. So onward shipment also fails.

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!


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