All Posts on Personalizations

How to Change Label Text using User Interface Text Feature?

Do you know how to modify/replace text on the UI screens in HCM Cloud? User Interface Text tool comes to our rescue, using which we can modify the text on all screens? Can we check the history of changes? Can these changes be migrated to other pods? Read on to know more details.

Continue ReadingHow to Change Label Text using User Interface Text Feature?

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 ReadingSQL Query to get the Valueset and Lookup Values

Basics of Flexfields in Fusion HCM

In this article we will look into the basics of Flexfields, types of it and their usage. What is a Flexfield? Types of Flexfields Differences between types of FlexfieldsHow to find the flexfields available on a Business Object?List of Flexfields available for HCM  What is a Flexfield? Flexfields are placeholder fields associated with a specific business object. They’re designed for customers to…

Continue ReadingBasics of Flexfields in Fusion HCM