R12: Unable To Drill Down Receipt Journals Batches and Querying Receipts Directly Gives ORA-1403: no data found (Doc ID 1331180.1)

Last updated on FEBRUARY 09, 2016

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.
ARXRWMAI - Receipts Workbench
GLXJEENT.fmx


Symptoms

Unable to Drill Down Receipt Journals Batches from GL

The receipts when attempted to query directly in Receipts Workbench , the Receipts appears but gives "ORA-1403: no data found" error. When you click on OK, the  Receipt disappears.

The Exact error details are as below:-

ORA-1403: no data found
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-1403

Changes

Recently upgraded to R12

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