RCVRCERC: Querying for Receipts in Find Receipts Form causes error: APP-PO-14142: rcv_receipts_eh.event-000 ORA-1403 / ORA-0000

(Doc ID 267010.1)

Last updated on MAY 22, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 14-May-2015***

FORM:RCVRCERC.FMB - Enter Receipts

Symptoms

The following error is displayed on Receipts form when searching for specific Purchase Order:

APP-PO-14142: rcv_receipts_eh.event-000 ORA-1403

Release 12 the error may be:

APP-PO-14142:rcv_receipts_eh:event-000: ORA-0000: normal, successful completion.
Cause: A SQL error has occurred in rcv_receipts_eh.event. The SQL error is ORA-0000: normal, successful completion.
Action: Take note of both this error number and the actions you were trying to perform. Contact your system administrator for further assistance.

 

Steps to reproduce:

  1. Navigate to Receiving > Receipts
  2. On Find Expected Receipts form, Enter PO number, PO line then Click Find
  3. The following error is displayed:
    APP-PO-14142: rcv_receipts_eh.event-000 ORA-1403: no data found

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