General Ledger Accounting Flexfield Set Results In FRM-41830 List Of Values Contains No Entries
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