My Oracle Support Banner

WIP Completion Transactions are failing with an 'ORA-01422: exact fetch returns more than requested number of rows.' Error (Doc ID 1371348.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Installed Base - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 14-Mar-2015***



When attempting to process a CSIWIPAC transaction, the following error occurs.

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

Steps to Reproduce
The issue can be reproduced at will with the following steps:

1. Create and complete a WIP Job
2. Observe the noted error


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.