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

Last updated on JULY 14, 2017

Applies to:

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

Symptoms

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.

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