You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

We need a tables or Query to get Opt-in Features for Financial in oracle fusion

in Reporting and Analytics for ERP

Summary:

Hi Team,

Could you please provide us the Query or Tables to get Opt-in Features for Financial in oracle fusion.

We could find the below table, but these are not sufficient to get whats there in UI provided in screenshot

ASM_FILTERS_VL

ASM_FILTER_OPTIONS_VL

ASM_SVS_FILTER_OPTIONS

ASM_FILTER_OPTIONS_FILTERS

With the above tables we have a query but we could not be able to Hierarchy as shown in UI.

Query :

SELECT B.APPLICATION_NAME ,A.FILTER_NAME, C.FILTER_OPTION_NAME,

CASE
WHEN
D.FILTER_OPTION_ID IS NOT NULL
THEN
'Yes'
ELSE 'No'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!