Error When Creating Change Order After Upgrade to Rel 12

(Doc ID 2302728.1)

Last updated on SEPTEMBER 29, 2017

Applies to:

Oracle Fusion Purchasing Cloud Service - Version 11.12.1.0.0 and later
Oracle Fusion Purchasing - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

 

After the Release 12 August Quarterly Update, the Purchase Order UI does not allow a user to create a change order when there are multiple receiving transactions against a single PO line.

Error
 

X Error
ORA-2001: PO_RCV_INTEGRATION.PO_RCV_INTEGRATION.is_po_received.20 ORA-6512: at "FUSION.PO_MESSAGE_S",
line 376 ORA-6512: at "PO_RCV_INTEGRATION_GRP", line 1129 ORA-01422: exact fetch returns more than
requested number of rows


Steps To Reproduce
1. Login into Fusion Applications
2. Navigate to Purchasing
3. Query the Purchase Order
4. Try to make changes

 

Changes

 Upgrade to Release 12 

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