-
-
Reports (BIP) – Query to get Adjustments in Absences
select papf.person_number,ppnf.full_name,absence_plan.name ,apaed1.value,apaed1.type,to_char(apaed1.procd_date,’DD-MON-YYYY’) processed_date,apaed1.created_byfrom anc_per_acrl_entry_dtls apaed1,ANC_PER_PLAN_ENROLLMENT apaed,per_all_people_f papf,per_person_names_f ppnf,(SELECT aapf.absence_plan_id, aapft.NAMEFROM anc_absence_plans_f_tl aapft,anc_absence_plans_f aapfWHERE aapft.absence_plan_id = aapf.absence_plan_idAND aapf.plan_status = ‘A’ — added to pick only Active Absence PlansAND trunc(SYSDATE) BETWEEN aapf.effective_start_date AND aapf.effective_end_dateAND trunc(SYSDATE) BETWEEN aapft.effective_start_date AND aapft.effective_end_dateAND aapft.language = ‘US’) absence_planwhere apaed.plan_id = absence_plan.absence_plan_idand apaed.plan_id = apaed1.pl_idAND ppnf.name_type = ‘GLOBAL’AND ppnf.person_id = apaed.person_idAND ppnf.person_id…
-
Reports (BIP) – Query to get Legislative Data group associated with Legal Entity
select ple.name legal_employer, pldgt.name legislative_data_groupfrom per_legislative_data_groups pldg,per_legislative_data_groups_tl pldgt,Hr_Organization_Information_F Psu_Inf,per_legal_employers plewhere 1=1and pldg.legislative_data_group_id = pldgt.legislative_data_group_idand pldgt.language = ‘US’and psu_inf.Org_Information_Context = ‘PER_PSU_PAYROLL_INFO’and psu_inf.Org_Information1 = pldgt.legislative_data_group_idand Psu_Inf.Organization_Id = ple.Organization_Idand TRUNC(sysdate) BETWEEN ple.effective_start_date AND ple.effective_end_date
-
Reports (BIP) – Organization classifications in Fusion
Fusion supports multiple organization types like Legal Employer, Business Units, Division, Departments etc. Below are the main classification codes used for organizations in Fusion: Division – HCM_DIVISION Department – DEPARTMENT Legal Employer – HCM_LEMP Business Unit – FUN_BUSINESS_UNIT All the available classifications can be found in below table: Example :- Query to get divisions list:
-
Reports – Query to get business Unit details
Use below query to get business unit details:
-
REST API – Sample Payloads (Part – 1)
Sample payload for adding DFF attribute value for absence entries: Sample Rest API Payload for adding dff value url will be same : https://abc_test.oraclecloud.com/hcmRestApi/resources/11.13.18.02/absences/ { “personNumber”: “999”, “employer”: “ABC Test Employer“, “absenceType”: “Sick Leave”, “startDateDuration”: “1”, “startDate”: “2019-03-28”, “startTime”: “08:00”, “endDate”: “2019-03-28”, “endTime”: “17:00”, “absenceStatusCd”: “SUBMITTED”,…
-
Reports (BIP) – Query to get UCM Content ID of an absence attachment
Use below query to get absence attachment id of an absence from UCM:
-
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…
-
Reports (BIP) – Function to get weekly schedule details
Use below query to get weekly schedule details of a worker:
-
HDL – Updating an attribute on Assignment
Technical consultants encounter many scenario’s where they have to update one or two attributes on the assignment data post initial data load. This can happen during any phase of the new implementation or post go-live. For example, there is a need to update the assignment category for a set of workers. In such scenario’s, the…
-
Reports (BIP) – Query to extract Worker disability details
Below query can be used to extract disability details of a worker:
-
Reports (BIP) – Query to get assigned payroll details
Use the below query to extract assigned payroll details from Fusion HCM:
-
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 ->…
-
HDL – Sample HDL to load GL information at Department level
Below is the sample HDL to load the GL Costing information at department level using Organization.dat file. It is always advisable to get the latest METADATA attributes. Check the below link to see the process of Refreshing the HDL objects: HDL – Refresh Business Objects Once the latest .dat file is available, check the DFF…
-
HDL – Refresh Business Objects
Refresh Business objects is a process which is used to create the HDL template for a business object with the latest supported attributes. When to run ‘Refresh Business Objects’ process: It is advised to run this process: After every upgrade After any new DFF/EFF attributes are configured for any HDL supported business objects. How to…
-
Reports (BIP) – Implementing Digital Signature in PDF BIP reports
Oracle Fusion reports and analytics provides the capability of implementing digital signatures with in BIP. However there are some limitations: Only one digital signature can be used across all reports. For a report with multiple templates, the same signature will be applicable for all the templates. Digital signature can be tested only using the BIP…
-
Security – Role to view all scheduled processes
As per the standard Fusion security, a user can view only the scheduled processes which has been scheduled from his/her user login. However, there is a common requirement where the admin should be able to view all the scheduled processes (processes scheduled by all the users). This can be achieved by creating a custom role….
-
HDL – Email Data Obfuscation in Test environment
Post P2T refresh, it is mandatory to mask the actual email Ids of the users in cloned test environment. This is required to avoid any unwanted emails getting triggered to the end users. The approach is already discussed in below post: https://fusionhcmconsulting.com/2020/12/hdl-query-to-delete-phones-data/ Use the below SQL to extract the data in HDL format: Query with…