My Oracle Support Banner

WIP Assembly Completion Transactions Error: You have encountered an unexpected error in csi_wip_trxs_pkg, with error ORA-06502: PL/SQL: numeric or value error: character to number conversion error (Doc ID 1168493.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Installed Base - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
csimsg.ldt
csipiwpb.pls
csipiwps.pls


Symptoms

WIP Assembly Completion transactions fail to update Install Base with error:

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

In case Patch 9478207 is applied for this error, a new error can occur:


csi_wip_trxs_pkg.apportion_serialized, with error ORA-06502: PL/SQL: numeric or value error: character to number conversion error.


Solution is the same for both errors.

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