Unable to Create Any Receipt ORA-00001: Unique Constraint (PO.RCV_TRANSACTIONS_U1) Violated (Doc ID 1546733.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, Receiving Functions
 
An upgrade has been performed from R11.5.10.2 to R12.1.3.

While creating a receipt based on the purchase order the following error occurs

RVTTH-010: Subroutine rvtthins() returned error
Cause: Subroutine rvtthins() returned an internal error.
Action: Note this error number and the actions you are trying to perform. Contact your system administrator for assi
RVTTH-192.rvtthins: Subroutine ORA-00001: unique constraint (PO.RCV_TRANSACTIONS_U1) violated returned error
Cause: Subroutine ORA-00001: unique constraint (PO.RCV_TRANSACTIONS_U1) violated returned an internal error.

 
Inventory debug log file shows

transaction_id: 86802 parent_transaction_id: -1 interface_transaction_id: 101650 group_id: 17492 request_id: 1182020
[18-APR-13 09:35:20] po.plsql.RCV_TRANSACTION_PROCESSOR.RCV_TRANSACTION_PROC.821: Error occured while inserting into rcv_transactions...ORA-00001: unique constraint (PO.RCV_TRANSACTIONS_U1) violated
[18-APR-13 09:35:20] po.plsql.RCV_TRANSACTION_PROCESSOR.RCV_TRANSACTION_PROC.end_implicit: ^--------Implicit Procedure Exit-----^
[18-APR-13 09:35:20] po.plsql.RCV_TRANSACTION_PROCESSOR.RVTTH.C.end_implicit: ^--------Implicit Procedure Exit-----^
[18-APR-13 09:35:20] po.plsql.RCV_TRANSACTION_PROCESSOR.RVTPA.C.end_implicit: ^--------Implicit Procedure Exit-----^
[18-APR-13 09:35:20] po.src.rvtp.rvtpt.RVTPT.C.3926: RVTPT:040 Error in lot/serial or rvtptdoactions or lpn_validation. Rollback to savepoint
[18-APR-13 09:35:20] po.src.rvtp.rvtpt.RVTPT.C.3926: ORA-01405: fetched column value is NULL

 
 
Steps
The issue can be reproduced at will with the following steps:
1. Receiving > Receipts RCVRCERC form
2. Query a PO .
3. Enter receiving information and save.

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