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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

SQL query to fetch the list of values for each value set

edited Nov 15, 2024 10:28PM in Reporting and Analytics for HCM 2 comments

Summary:

Business requirement is to fetch the list of active values for each value set code in excel.

Need to develop SQL query to fetch Each segment Value set code values in different sheets.

Manage Chart of Accounts Value set values > Search for Module: General Ledger > Identify the Value Set Code where Validation Type is Independent.

Select each value set code > Click on Manage Values > Fetch all active values in Excel by using BI report.

With help of the below query we could fetch the expected result. However our user requirement is to populate these value in a Excel sheet in different tabs. Example tab1 (Account, Description, Enabled_Flag), tab2(Department, Description,Enabled Flag) and sheet name is needs to update same as Value set code.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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