Oracle Fusion HCM Tutorial Blog

Wednesday, 1 October 2025

HDL Template for Benefit Participant Enrollment

For this use ParticipantEnrollment.dat file.

Please find the below sample template :

Tuesday, 2 July 2024

How to sort data in rtf template

Sort the data in Data model is the recommended approach.

But if you want to sort the data in rtf template then you have to use below xml tag code.

<?sort:fieldname?><?fieldname?>

this will sort the data in ascending order be default as it is not mentioned.

if user want to sort the data in descending order then use below code

<?sort:fieldname;'descending'?><?fieldname?>

Prenotification Status of Personal Payment Method in Oracle HCM

Prenote Status is not stored directly in table, you can find the corresponding details in pay_bank_account_prenotes table.

Prenote status you have to use below logic.

CASE
WHEN pay_bank_account_prenotes.PRENOTE_DATE=TO_DATE('31/12/4712','DD/MM/YYYY') THEN 'ORA_R'
WHEN pay_bank_account_prenotes.PRENOTE_DATE=TO_DATE('01/01/0001','DD/MM/YYYY') THEN 'ORA_SK'
WHEN NVL((pay_bank_account_prenotes.PRENOTE_DATE),TO_DATE('31/12/4712','DD/MM/YYYY'))=TO_DATE('31/12/4712','DD/MM/YYYY') THEN 'ORA_N_S'
WHEN TRUNC(pay_bank_account_prenotes.PRENOTE_DATE+NVL(OrganizationPaymentMethodDEO.VALIDATION_DAYS,0)) <= TRUNC(SYSDATE) THEN 'ORA_C'
ELSE 'ORA_S'
END AS PRENOTE_STATUS

Monday, 1 July 2024

Customize the Seeded Job Offer Letter Template

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'

Once we get the offer letter then go to the below path to get XML.

Path - Shared Folders > Human Capital Management > Recruiting > Job Offer

Open the JobOfferLetterDM

Pass the Job offer ID as mentioned below and click on view.

Once data is fetched by Data model then export the xml.

Then load the same xml in .rtf template as mentioned below.

Do the necessary changes as per the requirement then save the rtf template.

Add the rtf template to .zip file.

Now upload the zip file to Recruiting Content Library.

Go to Setup and Maintenance.

Select Recruiting and Candidate Experience Management then click on Recruiting Content Library.

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.

Sunday, 30 June 2024

HDL Template for Salary Data In Fusion HCM

HDL Template for Salary Data

For this use Salary.dat file.

You can see step by step video to load Salary data using this Click Here

Please find the below Sample Data to load Oracle Fusion HCM Salary Data using HDL.

MERGE|Salary|XXTEST_ASSIGN2|2019/06/04|2020/06/03|11000|US1 Annual Salary|CHANGE_SALARY|Y

Sunday, 14 January 2024

Avoid/Ignore if we have empty tag in XML.

Ignore the Empty Tag in XML or avoid blank rows in For loop BIP Report.

If we have blank row of data in For Loop in BIP Reports like in below example:

<?xml version="1.0" encoding="utf-8" standalone="no" ?>

<Fruit>

<Type>Apple</Type>

</Fruit>

<Fruit>

<Type>Orange</Type>

</Fruit>

</Basket>

If you look second occurrence the tag <Fruit> is empty.

Now if we create BIP Report that will loop through each Fruit.

BI Report will look like this because second occurrence is empty.

We have to tweak RTF template design to solve this issue and then write the for loop accordingly.

use the for loop shown in above example to solve the issue.

BIP Report looks like

Wednesday, 1 November 2023

Frequently asked questions with answer

Frequently asked questions with answer

Q) <?split-by-page-break:?> not working in rtf for page break?

-> If split by page break is not working or working only for first page/record in loop then try below code instead of <?split-by-page-break:?>

Use <xsl:attribute name="break-before">page</xsl:attribute>

Q) How to derive the prenotification status of personal payment method?

-> Use below code to derive the prenotification status

CASE
WHEN Prenote.PRENOTE_DATE=TO_DATE('31/12/4712','DD/MM/YYYY') THEN 'ORA_R'
WHEN Prenote.PRENOTE_DATE=TO_DATE('01/01/0001','DD/MM/YYYY') THEN 'ORA_SK'
WHEN NVL((Prenote.PRENOTE_DATE),TO_DATE('31/12/4712','DD/MM/YYYY'))=TO_DATE('31/12/4712','DD/MM/YYYY') THEN 'ORA_N_S'
WHEN TRUNC(Prenote.PRENOTE_DATE+NVL(OrganizationPaymentMethodDEO.VALIDATION_DAYS,0)) <= TRUNC(SYSDATE) THEN 'ORA_C'
ELSE 'ORA_S'
END AS PRENOTE_STATUS

Q) How to make sysdate as default parameter in BIP Report?

-> Create the date parameter with default value as "{$SYSDATE()$}"

Q) Bursting Parameters in Oracle Fusion ?

SELECT papf.person_number KEY,

:P1 TEMPLATE,

'en-US' LOCALE,

'pdf' OUTPUT_FORMAT,

'EMAIL' DEL_CHANNEL,

'psuzal@gmail.com' PARAMETER1,

'psuzal@gmail.com' PARAMETER2,

'psuzal@gmail.com' PARAMETER3,

'SUBJECT: EMPLOYEE BURSTING TEST' PARAMETER4,

'BODY:ATTACHED EMP LIST' PARAMETER5,

'true' PARAMETER6,

'psuzal@gmail.com' PARAMETER7,

'psuzal@gmail.com' PARAMETER8

FROM per_all_people_f papf

Significance of parameters -

PARAMETER1: Email address

PARAMETER2: cc

PARAMETER3: From

PARAMETER4: Subject

PARAMETER5: Message body

PARAMETER6: Attachment value ('true' or 'false'). If your output format is PDF, you must set this parameter to "true" to attach the PDF to the e-mail.

PARAMETER7: Reply-To

PARAMETER8: Bcc

(PARAMETER 9-10 are not used)

Q) How to customize seeded report in oracle fusion?

-> If you want to customize seeded report then follow below steps:

1. Instead of "Analytics" in your instance link use "xmlpserv"

2. Navigate the report path which you want to customize.

3. Select the report and click on More

4. Click Customize

5. Report will open in edit mode then click on Save.

6. It will create same folder structure in Custom folder then you can customize the seeded report.

Q) How to update the any offer letter template used by seeded functionality?

-> Follow the below steps to edit any offer letter used by seeded functionality.

1. Go to Setup and Maitainence

2. Select Recruiting and Candidate Experience (left hand side setup: select that dropdown)

3. Select Functional Area as "Recruiting and candidate experience management" and click on "recruiting content library" task.

4. Search for content item.

5. Download the template and modify the template.

6. Zip the updated template

7. Upload the same template for respective Content Item with option "Create New Version".

8. Save and activate.

In this way you can update/modify any offer letter template which uses seeded functionality.

Q) Can we change the preview offer letter HTML format to any other format in oracle fusion HCM?

-> As of now Oracle not given any other format to preview the offer letter other that HTML format.

You can only preview in HTML format. You can download offer letter so that it will get download in pdf format.

Sunday, 19 March 2023

Oracle Certification Foundation Associate - 1Z0-1106-1 - Dumps

If any one need 1Z0-1106-1 Dumps in very only Rs.100

please click on below link and fill the details.

I will provide dumps for 1Z0-1106-1. Amount is not refundable. Please fill the below form.

Link - Click to get dumps

Friday, 20 January 2023

Get Oracle Fusion Demo Instance (Vision)

If any one need Oracle Fusion Demo instance (Vision) in very cheap price

Note - Right now unable to provide the instance due to user creation capacity is full. Will try to increase with subscription and come back.

please click on below link and fill the details.

I will provide Oracle Fusion Demo Instance (Vision) access. Please fill the below form.

Link - Not Available at this moment. Sorry For inconvenience