Unable to Create Any Receipt ORA-00001: Unique Constraint (PO.RCV_TRANSACTIONS_U1) Violated
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.
On : 12.1.3 version, Receiving Functions
An upgrade has been performed from R18.104.22.168 to R12.1.3.
While creating a receipt based on the purchase order the following error occurs
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
[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
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.
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