Steps to Customize Oracle Seeded Job Offer Letter Template
Click here for step by step video to create job offer letter template customization
Below are the steps to customize the seeded job offer letter.
First download the seeded job offer template from below path.
Path - Shared Folders > Human Capital Management > Recruiting > Job Offer
Select Job Offer Letter Report and click on Edit
Click on Edit to download the seeded template.
Save the Downloaded .rtf template.
To modify the template we need .xml to do the changes as per needed.
We need offer id which need to provide the job offer letter Data model to get XML so first we need to find offer id using below SQL.
SELECT
offer.OFFER_ID
FROM
IRC_OFFERS offer,
IRC_CANDIDATES candidate,
IRC_REQUISITIONS_B req,
IRC_SUBMISSIONS sub
WHERE
req.REQUISITION_ID = sub.REQUISITION_ID
AND candidate.PERSON_ID = sub.PERSON_ID
AND sub.SUBMISSION_ID = offer.SUBMISSION_ID
AND REQUISITION_NUMBER = 'Enter the Requisition Number'
AND CANDIDATE_NUMBER = 'Enter the Candidate Number'
Click Create to create the content Item.
Enter the details.
Name:- User defined Name
Code :- User defined
Category :- Job Offer Letter Template
Visibility: - Internal,External
Select Start on Activation Check box and upload the zip file.
Then click on Save and activate button.
Now Create/Edit the job offer with new job offer template.
Path - My Client Group > Hiring
Select the Requisition and click on active application.
Click on Action to create job offer or If Offer is already created then click edit job offer.
It will open new dialogue. Select appropriate Check Box and click on continue.
Enter the details as per the section on Job Creation Page.
In offer section Select the newly created job offer letter and click on submit.
Click on Preview to verify the customize offer letter.