R12: AP: Invoice Workbench Error For Specific Invoice: FRM-40735:POST-QUERY Trigger Raised Unhandled Exception ORA-01403 (Doc ID 2344447.1)

Last updated on JUNE 11, 2024

Applies to:

Symptoms

On : Invoice Issues & MassAdd

Find the invoice error: FRM-40735:POST-QUERY trigger raised unhandled exception ORA-01403
Due to this issue, users cannot inquiry the specific invoice.


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

Changes

 NA

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.