My Oracle Support Banner

WIP Issue (CSIWIPCI) transactions Error With Error: ORA-01422: exact fetch returns more than requested number of rows (Doc ID 1192967.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Installed Base - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

WIP Issue (CSIWIPCI) transactions are failing with the following error:

You have encountered an unexpected error in csi_wip_trxs_pkg.get_parent_serial_number, with error ORA-01422: exact fetch returns more than requested number of rows.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create Sales Order and process for assembly
2. Create WIP job and issue product to the job
3. Complete the job and check the Transactions Error Processing form and find error.

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.