For using workers in HRHD, they should be added as resources. However, there are certain cases post worker data load where the workers are not available in the resource directory to be added as resources. Check the below post on adding workers as resources: HRHD – Create Worker as Resource This is mainly due to…
Post Worker HDL load, the workers should be created as Resources in resource directory so that they can assigned various HR Help Desk roles like Service Admin, Agents etc. Navigation to Resource Directory: N -> Others -> Resource Directory Click on view resources to view the already created resources or create a new resource: Click…
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…
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 ->…
In HR Helpdesk (HRHD), workers are assigned as resources. Below SQL query can be used to get the details of workers who are assigned as resources:
