My Oracle Support Banner

Modifying Flexfield Qualifier for Any Flexfield Segment Results In FRM-40735 Unhandled Exception ORA-01403 (Doc ID 2272543.1)

Last updated on FEBRUARY 13, 2020

Applies to:

Oracle Application Object Library - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3/12.2.4 version, Descriptive Flexfields (EXCEPT setup or Flexbuilder issues)

Unhandled exception while modifying Flexfield qualifier.

While unchecking the checkbox for one of the Flexfiled Qualifier, and clicking ‘save’ button, results in the Error:

FRM-40735: WHEN-BUTTON-PRESSED trigger raised Unhandled exception ORA-01403”

The issue can be reproduced at will with the following steps:
1. System Administrator --> Application --> Flexfield --> KFF --> Segments
2. Query for any KFF Structure. Unfreeze the Structure and click on Segments
3. Click Flexfield Qualifier once on Segments Screen and try to uncheck one of the Checked Qualifier for segment in focus.

Due to this issue, users cannot uncheck Flexfield Qualifier for any segment.


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.