Unable to Create Receipt APP-PO-14142: rcv_receipts_th.insert_header-000: ORA-0000 RCVRCERC

(Doc ID 1072428.1)

Last updated on JUNE 01, 2016

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

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