When Try to Complete the Ledger Definition Get "You Have Encountered An Unexpected Error. Please Contact The System Administrator For Assistance" and NullPointerException Due to Flexfield Error FLEX_DEFAULT_VALUE_NOT_AVAILABLE (Doc ID 1916645.1)

Last updated on MARCH 24, 2017

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Setup forms and programs

When try to complete ledger definition in Accounting Setup Manager (ASM), the following error occurs:

ERROR
-----------------------
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

Exception Details.
oracle.apps.fnd.framework.OAException: java.lang.NullPointerException at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)



The FND log messages trace file shows the following error:-
"The data that defines the flexfield on this field may be inconsistent. Inform your system administrator that the profile specified in FG_DEFAULT_COMPANY could not be found. This profile is either referenced by a WHERE_CLAUSE token passed into the flexfield definition in the form, a WHERE clause in a table-validated value set, or a default value for one of the segments of this flexfield.
return value = FLEX_DEFAULT_VALUE_NOT_AVAILABLE
return value = false"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into the system as GL Super User
2. Navigate to Accounting Manager Setup > Accounting Setups
3. Enter Ledger Definition, Standard Information and Accounting Calendar
4. When try to update Retained Earnings Account, the error occurs

Changes

 

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