Search for:
HRHD – Unable to view worker in Resource Directory

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 the reason that post worker load, the workers are not loaded into hz_parties table. ESS Job Person Synchronization should be run post worker load and should be scheduled daily so that the worker data is in sync with hz_parties.

Please refer to the user guide attached in below MOS note:

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=126676774858547&id=2068535.1&_adf.ctrl-state=11cq05fk7b_52

Once the ESS Job is successful, you should be able to see the workers in Add Resources window.

HRHD – Create Worker as Resource

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 on Add icon (+) under Search results to add a worker as resource.

You can either search by Person Name or Registry ID. Registry IDs you can find in hz_parties table.

Check below query to find the link between hz_parties and per_All_people_f table:

HRHD – Employee Resource Query – Welcome to Fusion HCM Consulting

Choose the row and click on Add as Resource button.

You can assign a role while Adding the worker as resource, or you can do it at a later point also:

Click on Save and Close to save the record.

Do a search again on ‘View Resource’ and you should be able to find the newly added resource.

Use the below query to check the data from backend tables:

HRHD – Query to find Worker Resource Details – Welcome to Fusion HCM Consulting

HRHD – Query to find Worker Resource Details
select hp.party_number
,hp.party_name
,hp.party_type
,hp.ORIG_SYSTEM_REFERENCE
,jrrp.PERSON_NAME
,jrrp.PERSON_FIRST_NAME
,hp.PERSON_FIRST_NAME hp_PERSON_FIRST_NAME
,jrrp.PERSON_LAST_NAME
,hp.PERSON_LAST_NAME hp_PERSON_LAST_NAME
,jrrp.PERSON_TITLE
,hp.PERSON_TITLE hp_PERSON_TITLE
,jrrp.EMAIL_ADDRESS
,hp.EMAIL_ADDRESS hp_EMAIL_ADDRESS
,jrrp.PRIMARY_PHONE_NUMBER
,hp.PRIMARY_PHONE_NUMBER hp_PRIMARY_PHONE_NUMBER
,jrrp.PARTY_ID
,jrrp.START_DATE_ACTIVE
,jrrp.END_DATE_ACTIVE
,jrrr.ROLE_RESOURCE_TYPE
,jrrb.ROLE_ID
,jrrb.ROLE_CODE
,jrrb.ROLE_TYPE_CODE
from HZ_PARTIES hp
,JTF_RS_ROLE_RELATIONS jrrr
,JTF_RS_RESOURCE_PROFILES jrrp
,JTF_RS_ROLES_B jrrb
where jrrr.ROLE_RESOURCE_ID = hp.party_id
and jrrr.role_id = jrrb.role_id
and jrrp.party_id = hp.party_id
HRHD – Query to get Service Request Details

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.meaning
FROM fnd_lookup_values flv
WHERE flv.lookup_code = ssr.status_cd
AND flv.lookup_type = ‘ORA_SVC_SR_STATUS_CD’
AND flv.LANGUAGE = ‘US’) sr_status_meaning,
ssr.severity_cd,
(SELECT meaning
FROM fnd_lookup_values flv
WHERE flv.lookup_code = ssr.severity_cd
AND 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_on
FROM svc_service_requests ssr,
svc_queues sq,
svc_categories sc
WHERE ssr.queue_id = sq.queue_id
AND ssr.category_id = sc.category_id
–AND ssr.status_cd in (‘ORA_SVC_NEW’,’ORA_SVC_INPROGRESS’)

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 -> Configuration -> Application Composer -> Metadata Manager

Click on generate button:

Choose the objects and Metadata types to be included in report:

Click on generate button and wait while the configuration report is getting generated.

Once the report is generated, click on Export to generate the report in excel or HTML format.

HRHD – Employee Resource Query

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:

select hp.PERSON_FIRST_NAME "FirstName"
,hp.PERSON_LAST_NAME "LastName"
,hp.EMAIL_ADDRESS "ResourceEmail"
,hp.PARTY_NUMBER "ResourcePartyNumber"
,papf.person_number
from HZ_PARTIES hp,
per_all_people_f papf
where papf.person_id = hp.ORIG_SYSTEM_REFERENCE
and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date
--and papf.person_number IN ('964091')