BIP – Extract Checklist configuration details
Below query can be used to extract checklist configuration details:
-
-
-
Diagnostics – Run Diagnostics is missing
With latest HCM release in 2022, “Run Diagnostics” option was removed from user profile. A new role is now required in order to give access to this function. Role Name – Application Diagnostics Advanced User Role Code – ORA_FND_DIAG_ADVANCED_USER_JOB
-
HDL – Inactivate secondary Org classification
Oracle HCM allows an Organization to be classified as multiple Orgs. However, sometime there is a need to inactivate one org classification while keeping the primary classification as Active. Below is a sample HDL file which can be used for this purpose:
-
HDL – Assignment Working Hour Pattern
Oracle has provided a new feature where working hours for each day can be stored against assignment working hours. The data is stored in PER_WORKING_HOUR_PATTERNS_F table. Use below query to extract the data: Query to extract data in HDL format:
-
BIP – Queries related to Bank, Bank Branches and External Bank accounts
Query for bank details: Query for bank branch details: Query to extract Internal bank accounts: select * from ce_bank_accounts Query to extract External bank accounts:
-
BIP – Query to extract Disability Org Details
Use below query to extract disability org details from Fusion HCM:
-
BIP – Query to extract absence reasons from Oracle HCM
Sometime for data migration, it is required to get a dump of all the absence reasons configured in Fusion HCM in order to validate the data being loaded. Below query can be used to extract the setup data for absence reasons:
-
BIP – Extract environment url dynamically
For many BIP reports, it is required to publish the environment url. One can easily hardcode it in SQL query, however, when P2T or T2T happens, the same url gets copied to target instance which is incorrect. The better way of doing it is to use below piece of code in custom SQL to extract…
-
HDL – DELETE Person External Identifier
Person External Identifier information can be deleted easily using HDL. Under Worker use ExternalIdentifier to delete this data. Run the below query to extract required data in HDL format: Sample HDL File:
-
-
BIP – Query to extract Rating Model Levels in HDL Format
This is second post in a series to extract Rating Model data from Fusion environment in HDL format. The first post has a query to extract only the rating model data and second post describes the BIP query to extract rating model levels data. Query to extract Rating Model data: Query to extract Rating Model…
-
BIP – Query to extract Rating Model data in HDL Format
You can use below query to extract Rating Model data from fusion environment for updates. Save the data as RatingModel.dat before uploading to Fusion. You can make use of this query to extract data for reference or use it as a method to extract data from one instance and upload it to a different instance….
-
HDL – Sample HDL to load rehire Workers
Below is the sample file (tested on an older version) to load rehire worker records but the structure should remain same. Few attributes may be deprecated now, so you may get an error. Please remove those and it should work fine.
-
Configuration – Value set to get Grade Steps based on Worker Grade
Assignment DFF supports a number of parameters which can be used to get dynamic values based on Worker assignment. List of supported parameters for a DFF can be found using below link: In this example, we will create a value set to display list of Grade steps based on Worker’s assigned grade. Create a Table…
-
Value Set – Table Value set to get list of employees
While extending the DFF attributes for additional functionality, one of the common requirements is to get the list of workers in the system. For this purpose a table based value set can be defined and attached to the DFF attribute. FROM Clause per_all_people_f papf, per_person_names_f ppnf Value Attributes Table Alias *Value Column Name papf.person_number…
-
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…
-
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…
-
HRHD – Generate list of published changes
In HR Helpdesk module, generally a lot of customizations are done i.e. adding a new field on standard screen, new triggers etc. Once the solution is finalized, a report can be generated which will list down all the customizations. This is an Out of the box functionality provided by Fusion applications. Navigate to Home ->…