Personalizations – Fusion HCM Knowledgebase

How to Bulk Load Valueset Values

Post category:Personalizations
Post comments:0 Comments
Post last modified:July 6, 2020
Reading time:3 mins read

Do you know how to bulk load Value Set Values for Independent or Dependent Value Sets? Read on to know more details.

How to Bulk Load Lookup Types and Lookup Codes

Post category:Personalizations
Post comments:0 Comments
Post last modified:July 6, 2020
Reading time:3 mins read

Do you know how to bulk load/migrate Lookup Types and Lookup Codes? Read on to know more details

SQL Query to fetch Descriptive Flexfield information from an instance

Post category:Personalizations
Post comments:0 Comments
Post last modified:June 23, 2020
Reading time:3 mins read

Do you know how to fetch the configured Descriptive Flexfields from an instance? Do you know in which table and attribute the data resides?

Resolve EDIT button is grayed out on Assignment screen

Post category:Personalizations
Post comments:0 Comments
Post last modified:June 12, 2020
Reading time:5 mins read

Have you faced EDIT button grayed out issue on Employment Page? Do you know the direct/indirect transactions which would have caused this issue? Read on to know more details.

Accessing Payroll Process Configuration task

Post category:Personalizations
Post comments:1 Comment
Post last modified:June 12, 2020
Reading time:3 mins read

Do you know how to access the Payroll Process Configuration task to setup logging, multi-threading, etc? Have you faced issue with this task not showing up even when you have the required access? Read on to know more details

Introduction to User Defined Table (UDT) in Fusion HCM

Post category:Personalizations
Post comments:2 Comments
Post last modified:June 16, 2020
Reading time:8 mins read

Do you know User-Defined Table (UDT) in Fusion? What's the usage of them and how do you load data into them and how do you migrate them? Read on to know more details

Using Aggregate functions in Table based Valueset

Post category:Personalizations
Post comments:0 Comments
Post last modified:June 16, 2020
Reading time:4 mins read

Do you know that there is a workaround to achieve the aggregate functions in Table based Valueset? Read on to know more details

How to bulk load Profile Option values?

Post category:Personalizations
Post comments:3 Comments
Post last modified:June 16, 2020
Reading time:5 mins read

Do you know how to bulk load the profile option values into Fusion? You can load profile option values for multiple profile options at one go. Read on to know more details.

SQL Query to get the Valueset and Lookup Values

Post category:Personalizations
Post comments:0 Comments
Post last modified:June 16, 2020
Reading time:2 mins read

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:…