All Posts on Personalizations

Accessing Payroll Process Configuration task

Accessing Payroll Process Configuration task
Accessing Payroll Process Configuration task

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

Continue Reading Accessing Payroll Process Configuration task

How to bulk load Profile Option values?

How to bulk load Profile Option values?
How to bulk load Profile Option values?

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.

Continue Reading How to bulk load Profile Option values?

SQL Query to get the Valueset and Lookup Values

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