Corrections Against Some Receipts Fail With Error APP-PO-14142: rcv_transactions_1.event-000 (Doc ID 1486221.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Inventory Management - Version 12.0.4 to 12.1.3 [Release 12 to 12.1]
Oracle Purchasing - Version 12.0.4 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
RCVTXECO, APP-PO-14142

Symptoms

Attempting to perform a correction against PO Release Recept fails with the following error:

APP-PO-14142: rcv_transactions_1.event-000: ORA-0000: normal,successful completion
Cause: A SQL error has occurred in rcv_transactions_1 event. The SQL error is ORA-0000: normal, successful completion.


Steps:
======
Receiving > Corrections
Query PO Release
Enter correction quantity
Save -> Error occurs


RCV11i does not show the item in question listed.

Trace shows that the following statement fails to return rows:

 

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