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