Advance Exchange Get Error "Serial Number update is disallowed. Serial Number is pending in Installation Details for the Source Transaction' (Doc ID 2257242.1)

Last updated on APRIL 20, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Support Codes

When attempting to interface an change serial number WIP assembly completion transaction to Installed Base
the following error occurs.

ERROR
-----------------------
Serial Number update is disallowed. Serial Number is pending in Installation Details for the Source Transaction ( Source Table : OE_ORDER_LINES_ALL, Source ID : &ID ) Serial Number update is disallowed. Serial Number is pending in Installation Details for the Source Transaction ( Source Table : OE_ORDER_LINES_ALL, Source ID : &ID ) You have encountered an unexpected error in csi_wip_trxs_pkg, with error ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.CSI_PROCESS_TXN_GRP", line 451 ORA-06510: PL/SQL: unhandled user-defined exception.

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