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…
Use below query to get service request details from Fusion BIP: SELECT ssr.sr_id,ssr.title,ssr.problem_desc,to_char(ssr.open_date,’RRRR/MM/DD’) sr_opening_date,ssr.primary_contact_party_id,ssr.sr_number,ssr.status_cd,(SELECT flv.meaningFROM fnd_lookup_values flvWHERE flv.lookup_code = ssr.status_cdAND flv.lookup_type = ‘ORA_SVC_SR_STATUS_CD’AND flv.LANGUAGE = ‘US’) sr_status_meaning,ssr.severity_cd,(SELECT meaningFROM fnd_lookup_values flvWHERE flv.lookup_code = ssr.severity_cdAND flv.lookup_type = ‘ORA_SVC_SR_SEVERITY_CD’AND flv.LANGUAGE = ‘US’) sr_severity_meaning,sc.category_name category,sq.queue_name queue,to_char(ssr.last_resource_assign_date,’RRRR/MM/DD’) sr_last_resource_assigned_onFROM svc_service_requests ssr,svc_queues sq,svc_categories scWHERE ssr.queue_id = sq.queue_idAND ssr.category_id = sc.category_id–AND ssr.status_cd in…
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…
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
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:
Use below query to get business unit details:
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”,…
Use below query to get absence attachment id of an absence from UCM:
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…
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…
Use below query to get weekly schedule details of a worker:
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…
Below query can be used to extract disability details of a worker:
Use the below query to extract assigned payroll details from Fusion HCM:
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…
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 ->…
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…
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…
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…
