My Oracle Support Banner

R12:CE: Unreconcile Open Interface Transaction Error (CEXCABMR): FRM-40735: WHEN-CHECKBOX-CHANGED Trigger Raised Unhandled Exception ORA-01403 (Doc ID 2889156.1)

Last updated on AUGUST 30, 2023

Applies to:

Oracle Cash Management - Version 12.2 and later
Information in this document applies to any platform.


When trying to unreconcile a statement line reconciled to an Open Interface transaction the following error occurs:

AVAILABLE_PRIVATE.set_dependents procedure raised unhandled exception
AVAILABLE.multi_select procedure raised unhandled exception (WHEN-CHECKBOX-CHANGED)
FRM-40735: WHEN-CHECKBOX-CHANGED trigger raised unhandled exception ORA-01403.

The issue can be reproduced at will with the following steps:

1. Navigate to Cash Management responsibility: Reconcile Bank Statements window.
2. Select a bank statement, then choose Review.
3. Choose Lines.
4. Select the statement line whose transactions you want to unreconcile, then choose Reconciled.
5. Select the transactions you want to unreconcile, by checking the box to the left of each transaction.
6. Choose Unreconcile and the error occurs.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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