My Oracle Support Banner

Unable to Create Receipt APP-PO-14142: rcv_receipts_th.insert_header-000: ORA-0000 RCVRCERC (Doc ID 1072428.1)

Last updated on OCTOBER 23, 2023

Applies to:

Oracle Inventory Management - Version 11.5.1 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Form:RCVRCERC.FMB - Enter Receipts


Symptoms

When attempting to save any receipt on RCVRCERC form the following error occurs.

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

Another error message maybe

APP-PO-14142: rcv_receipts_th.insert_transaction-001: ORA-0000: normal, successful completion
Cause: A SQL error has occurred in rcv_receipts_th.insert_transaction. The SQL error is:
ORA-0000: normal successful completion.

 

Steps
The issue can be reproduced at will with the following steps:
1. Navigate to Receiving > Receipts
2. Query the Purchase order
3. Click on line and save
4. At this moment the above mentioned error occurs

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.