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 JUNE 21, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.