How to Bulk Load Valueset Values
How to Bulk Load Valueset Values
Do you know how to bulk load Value Set Values for Independent or Dependent Value Sets? Read on to know more details.
Continue Reading
How to Bulk Load Valueset Values
All posts on Valuesets
Bypass the FROM Clause limit in Table based Valueset
Bypassing the from clause limit in Table Based Valueset
Do you know that you can bypass the FROM Clause character limit of 240 in table based valueset using a workaround? Read on to know more details.
Continue Reading
Bypass the FROM Clause limit in Table based Valueset
Using Aggregate functions in Table based Valueset
Using Aggregate functions in Table based Valueset
Do you know that there is a workaround to achieve the aggregate functions in Table based Valueset? Read on to know more details
Continue Reading
Using Aggregate functions in Table based Valueset
Using Table based Valueset when DBI is unavailable
Using Table based Valueset when DBI is unavailable
When we develop integrations using HCM Extracts, we normally come across many scenarios where in we are unable to get all the attributes required using the Database Items (DBIs) for the integration using a single/multiple User Entities (UEs). If you are new to HCM Extracts, I would suggest you to read through the below articles on HCM Extracts Basics of…
Continue Reading
Using Table based Valueset when DBI is unavailable
SQL Query to get the Valueset and Lookup Values
SQL Query to get the Valueset and Lookup Values
We will try to extract Valueset and Lookup values using SQL Query. Independent Valueset details: SELECT ffvs.flex_value_set_name ,ffvs.description set_description ,ffv.flex_value ,ffvt.flex_value_meaning ,ffvt.description value_description FROM fnd_flex_value_sets ffvs ,fnd_flex_values ffv ,fnd_flex_values_tl ffvt WHERE ffvs.flex_value_set_id = ffv.flex_value_set_id AND ffv.flex_value_id = ffvt.flex_value_id AND ffvt.LANGUAGE = USERENV('LANG') AND TRUNC(SYSDATE) BETWEEN NVL(ffv.start_date_active, trunc(SYSDATE)) AND NVL(ffv.end_date_active, trunc(SYSDATE + 1)) AND ffvs.flex_value_set_name = 'ABCD_BRANCH_VS' Table based Valueset details:…
Continue Reading
SQL Query to get the Valueset and Lookup Values
Basics of Valuesets in Fusion HCM
Basics of Valuesets in Fusion HCM
Do you know about valuesets, types of valuesets and their usage in fusion? Have a look at this article to know about valuesets.
Continue Reading
Basics of Valuesets in Fusion HCM
