Unable to Create Receipt APP-PO-14142: rcv_receipts_th.insert_header-000: ORA-0000 RCVRCERC
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
When attempting to save any receipt on RCVRCERC form the following error occurs.
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
Cause: A SQL error has occurred in rcv_receipts_th.insert_transaction. The SQL error is:
ORA-0000: normal successful completion.
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
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