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:

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

HRHD – Query to find Worker Resource Details
select hp.party_number
from HZ_PARTIES hp
where jrrr.ROLE_RESOURCE_ID = hp.party_id
and jrrr.role_id = jrrb.role_id
and jrrp.party_id = hp.party_id
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.EMAIL_ADDRESS "ResourceEmail"
,hp.PARTY_NUMBER "ResourcePartyNumber"
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')