Invoice Workbench Error For Specific Invoice: FRM-40735:POST-QUERY Trigger Raised Unhandled Exception ORA-01403

(Doc ID 2344447.1)

Last updated on JANUARY 01, 2018

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

On : Invoice Issues & MassAdd

Find the invoice error: FRM-40735:POST-QUERY trigger raised unhandled exception ORA-01403


ERROR
-----------------------
APXINWKB, 19, Prog Unit, Exit, 1109618880, /APXINWKB-3/INV_SUM_FOLDER/FORMAT_MULTI_AMOUNT

APXINWKB, 19, Prog Unit, Entry, 1109640880, /APXINWKB-3/INV_SUM_FOLDER/FORMAT_MULTI_AMOUNT

APXINWKB, 20, Prog Unit, Entry, 1109670880, /APXINWKB-3/INV_SUM_FOLDER_ITEM_OVERFLOW/FORMAT_MULTI_AMOUNT

Unhandled Exception ORA-01403

State Delta:

Error Message: FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in EBS 
2. Switch to Payable Responsibility
3. Go To Invoices -> Entry -> Invoices
4. Enter The <Number>, Then Click Find


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot inquiry the specific invoice.

Changes

 NA

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