Configuration – Extract DFF Setup
Use below query to extract the DFF setups defined in Fusion:
-
-
Configuration – Using User Interface Text
User Interface Text is a tool provided with Oracle Fusion Applications which can be used to replace any words/sentences across the application. For example, you want to rename Worker to Employee, then you can make use of this tool. To make use of this tool, you have to first create a sandbox and then add…
-
Reports (BIP) – Query to extract Manage Person Name Styles
Manage Person Name Styles is a task that can be used to configure additional Name attributes for a country if required. Also, a name component can be made required as per requirement. In multi country implementations, it is required to know the setup for technical developers as it is hard to check the setup for…
-
Value Set – Table Value set to get list of courses
*FROM Clause wlf_learning_items_f wlif, wlf_learning_items_f_tl wlift Value Attributes Table Alias *Value Column Name SUBSTR(wlift.name,1,150) Value Column Type VARCHAR2 Value Column Length 150 Description Column Name Description Column Type Description Column Length ID Column Name TO_CHAR(wlif.LEARNING_ITEM_ID) ID Column Type VARCHAR2 ID Column Length 40 Enabled Flag Column Name Start Date Column…
-
Value Set – Table Value set to get list of departments
Use below setup to create a table based value set which will show the list of all departments: *FROM Clause HR_ORG_UNIT_CLASSIFICATIONS_F HOCF, HR_ORGANIZATION_UNITS_F_TL HOUT Value Attributes Table Alias *Value Column Name SUBSTR(HOUT.NAME,1,150) Value Column Type VARCHAR2 Value Column Length 150 Description Column Name Description Column Type Description Column Length ID Column…
-
Configuration – How to get list of supported parameters for a DFF?
There is a common requirement to default the value of DFF attributes on a UI page. For example, we want to default a defined attribute of ‘PER_PERSONS_DFF’ DFF based on person_id. For this we will need to pass the parameter as :{parameter.parameter_name} in table validated value set. To know the list of all parameters supported…
-
SSO – SSO Configuration and Integration with Fusion HCM
There is a common requirement to implement Single Sign On (SSO) with fusion HCM. First, let’s try to understand some basic concepts of SSO: IDP – Identity provider : The identity provider verifies the user credentials and sends the authorization and authentication response back to the service provider. For example, Microsoft AD. SP – Service…
-
Configuration – How to disable Position Incumbent Validation?
Sometimes while loading the worker assignments or assigning an employee to a new position, you get “The Selected Position Has No Open headcount. Select A Different Position To Continue” error, one resolution to this is to disable the Position Incumbent Validation at enterprise level. Follow the below steps to disable the position validation: 2. Search…