-
-
BIP – How to check Termination version on your environment?
You can use per_empl_configurations table to verify the versions of Seniority dates/ Termination dates. Below is an example to check the version for Termination dates: If the version code value is NULL that means you are still on version V2. Same table can be used to query Seniority Dates version.
-
Purge Worker/Person Records from Test Environment
Oracle provides a process Purge Person Data in Test Environments to remove Person/Contact/Worker records from a test environment of Oracle HCM. Please note that HDL for core worker object doesn’t support DELETE, so there is no other option to purge the Person/Contact/Worker information from Oracle HCM once a record is created. In this case, Purge…
-
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:
-
Configuration – Value Set to show numbers from 1 to 60
There is a common requirement to use value sets in various DFF attributes across Fusion HCM application. Oracle HCM supports different kind of value sets – Independent, Table validated etc. There is a use case where a user wants to see a list of values containing numbers from 1 to n. There are two approaches…
-
Configuration – Enable Location Based Access
By default Location Based Access is disabled. Navigate to Tools -> Administration and you will not find Location Based Access Tab: To enable the location based access tab, set the profile option ‘ASE_ADMINISTER_LOCATION_BASED_ACCESS_CONTROL’ to Yes: Once this is set, Location Based Access tab will start appearing in the Tools -> Administration: Click Enable Location Based…
-
Configuration – How to make a role public? (LBAC)
While implementing Location Based Access control for your application, make sure you set the IT Security Manager role as public. This will help you to access the application and the tasks in an event where a wrong list of IP’s has been supplied and no user is able to access the application. Follow the below…
-
Configuration – Make a document type defaulted in search
When an employee opens document of records, by default it will show all the document types. There are many scenarios where the business wants to set a default filter to see only a particular type of document type. The other document types should be visible only if the default filter is removed. Follow the below…
-
-
-
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…
-
Configuration – Value set to get Employee Category list
Employee category (EMPLOYEE_CATG) is a delivered user type lookup in Oracle HCM which can be extended. However, in few cases, there is a requirement to populate employee category at DFF attribute(s), in this case, we need to create a table defined value set. FROM Clause fnd_lookup_values Value Attributes Table Alias *Value Column Name substr(meaning,1,80)…
-
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…
-
Configuration | HDL | Reports
BIP – Query to get Configure HCM Data Loader parameters
Configure HCM Data Loader is a task that is used to define the HCM Data Loader parameters. The parameters are broadly divided into following categories:- Availability, Diagnostic, File Definition, Performance and Scheduling Default. These are the default settings which are applied to any HCM Data Load. You can override some of these parameters at the…
-
Lookups – Mass Upload Lookup Types
Lookups are commonly used across modules in SaaS. Sometimes, the number of lookups is so much that it takes lot of time and effort to create them manually in the application. Oracle SaaS supports bulk upload of both lookup types and lookup codes. In this post, we will see how to make use of file…
-
Reports (BIP) – Query to find module type and key
While defining Common Lookups or value sets, you need to provide module value. Each module has an associated module type, module key and product code associated with it. For example: These details are stored in backed in a table – FND_APPL_TAXONOMY. Use the below query to find module type, module key etc for a module:
-
Lookups – Mass Upload Lookup Values
Lookups are used commonly to meet different requirements. Many a times, lookup values easily go past hundred values, in such case adding the values one by one into the lookup is very tedious and error prone job. There is no HDL support to bulk upload the lookup values. However, a file based solution is available…
-
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…