General Ledger - EBS (MOSC)

MOSC Banner

General Ledger Accounting Flexfield Set Results In FRM-41830 List Of Values Contains No Entries

edited Feb 4, 2019 2:29AM in General Ledger - EBS (MOSC) 4 commentsAnswered ✓

Hello,

In new Vision Instance, Accounting key flexfields are not appearing when i am trying to add values in each key flex field. Do i need to apply any patch?

Please refer screen shot.

Versions:

Oracle 12.2.6

Form Version : 12.0.14.12020000.19

Observations:

issue causing due to below WHERE condition. I fetched this query from LAST_QUERY option.

/*

SELECT PARENT_VALUE_SET_NAME,

  PARENT_VALUE_SET_DESCRIPTION,

  DEP_VALUE_SET_NAME,

  DEP_VALUE_SET_DESCRIPTION,

  FLEX_VALUE,

  VALUE_DESCRIPTION,

  DEP_VALUE_SET_ID,

  PARENT_FLEX_VALUE_SET_ID,

  FLEX_VALUE_SET_ID,

  SECURITY_ENABLED_FLAG,

  VALIDATION_TYPE,

  SUMMARY_ALLOWED_FLAG

FROM FND_FLEX_VSET_V

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center