How to sort data in rtf template

 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

 

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

Step-by-Step Guide to Customize Oracle Seeded Job Offer Letter Template

Step-by-Step Guide to Customize Oracle Seeded Job Offer Letter Template

Introduction 

Customizing a Job Offer Letter Template in Oracle Recruiting is an essential task for HR and Talent Management teams to ensure candidate communications are personalized, branded, and compliant. Oracle provides seeded job offer templates, but they often require customization to meet organizational needs.

In this blog, we’ll walk you through the complete process to customize Oracle seeded Job Offer Letter templates, from downloading the template to uploading and activating it in the Recruiting Content Library.

Click here for step by step video to create job offer letter template customization

HDL Template for Salary Data In Fusion HCM

How to Load Worker Salary in Oracle Fusion HCM Using HDL (Salary.dat)

Learn how to create or update worker salary in Oracle Fusion HCM using HDL Salary.dat. Step-by-step guide with sample template, required fields, salary basis, action codes, approval flag, and common error fixes.

Oracle Fusion HCM allows you to load or update worker salary using HCM Data Loader (HDL).
This is useful when you need to migrate salary data during:

• New implementation (initial data load)

• Bulk salary updates

• Salary corrections

• Salary changes during hiring

In this blog, you will learn:

✅ Salary HDL file name and structure
✅ Required attributes
✅ Salary basis and approval flag
✅ Sample Salary.dat template
✅ Common errors and troubleshooting

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

---

📌 HDL File Used

To load salary data, use:

✅ Salary.dat

---

✅ Prerequisites (Very Important)

Before loading salary using HDL, make sure:

1) Worker & Assignment already exist

Salary is always tied to an assignment.

So these must exist first:

• Worker record

• AssignmentNumber

---

2) Salary Basis must exist

SalaryBasisName should already be configured.

Example:

• US1 Annual Salary

• Monthly Salary

• Hourly Rate

Navigation:
My Client Groups → Salary → Salary Basis

---

3) Worker must have valid payroll / employment info

Salary often fails if assignment is missing:

• legislation code

• grade

• payroll details (in some setups)

---

✅ Salary.dat Template (Sample)

Use the below sample:

METADATA|Salary|AssignmentNumber|DateFrom|DateTo|SalaryAmount|SalaryBasisName|ActionCode|SalaryApproved
MERGE|Salary|ORACLE_ASG12|1991/01/01||10000|US1 Annual Salary|HIRE|Y

---

✅ Field Explanation (Salary HDL)

1) AssignmentNumber

This is the unique assignment number of the worker.

Example:

ORACLE_ASG12

---

2) DateFrom / DateTo

• DateFrom = salary effective start date

• DateTo = keep blank unless you want to end-date salary

Example:

1991/01/01

---

3) SalaryAmount

Salary amount to load.

Example:

10000

---

4) SalaryBasisName

This must match exactly with configured Salary Basis.

Example:

US1 Annual Salary

---

5) ActionCode

Defines why salary is being loaded.

Common values:

• HIRE

• SALARY_CHANGE

• PROMOTION

• TRANSFER

Example:

HIRE

---

6) SalaryApproved

Salary approval flag.

Values:

• Y = approved

• N = not approved

Example:

Y

---

✅ Step-by-Step: Load Salary Using HDL

Step 1: Create Salary.dat file

Create a .dat file and add metadata + merge line.

---

Step 2: Create .zip file

Create a zip file:

Example:

Salary.zip

Inside zip:

Salary.dat

---

Step 3: Upload in HDL

Navigate to:

My Client Groups → Data Exchange → HCM Data Loader

Steps:

1. Import and Load Data

2. Upload Salary.zip

3. Submit

---

Step 4: Monitor HDL Status

Check:

• Import Status

• Load Status

• Completed Successfully / Error

---

Step 5: Validate Salary in UI

Navigate to:

My Client Groups → Person Management → Search Worker → Salary

Confirm:

• Salary Amount

• Salary Basis

• Effective date

---

⭐ Example: Load Salary for Multiple Workers

METADATA|Salary|AssignmentNumber|DateFrom|DateTo|SalaryAmount|SalaryBasisName|ActionCode|SalaryApproved

MERGE|Salary|ORACLE_ASG12|1991/01/01||10000|US1 Annual Salary|HIRE|Y
MERGE|Salary|ORACLE_ASG13|1991/01/01||12000|US1 Annual Salary|HIRE|Y
MERGE|Salary|ORACLE_ASG14|1991/01/01||15000|US1 Annual Salary|HIRE|Y

---

🔥 Common HDL Errors & Fixes

❌ 1) Salary basis not found

Error:
SalaryBasisName is invalid

✅ Fix:

• Verify Salary Basis exists

• Match exact name (case-sensitive)

---

❌ 2) Assignment number not found

Error:
AssignmentNumber doesn’t exist

✅ Fix:

• Confirm assignment is created successfully

• Load worker/assignment first

---

❌ 3) Salary overlaps existing salary

Error:
Overlapping salary records

✅ Fix:

• End-date previous salary using DateTo

• Or use correct DateFrom

---

❌ 4) Salary not approved

Error:
Salary not visible in UI

✅ Fix:

• Set SalaryApproved = Y

• Ensure approvals not required in workflow

---

🔗 Internal Links 

• Load Worker Data using HDL (Worker.dat)

• Load Personal Payment Method using HDL

• HDL Common Errors and Solutions

• HCM Extract Changes Only Mode

• Oracle Fusion HCM Technical Interview Questions

• Oracle eText Template BIP Report 

• Oracle Benefit Participant Load using HDL

---

⭐ FAQs 

Q1. Which file is used to load salary using HDL?

Salary is loaded using Salary.dat in Oracle Fusion HCM.

Q2. What is required before loading salary using HDL?

Worker and Assignment must exist, and Salary Basis must be configured.

Q3. Can we update salary using MERGE?

Yes, MERGE can create or update salary records depending on the effective date.

Q4. What is SalaryApproved in Salary.dat?

SalaryApproved is a flag that indicates whether the salary record is approved (Y) or not approved (N).

Q5. What is the most common reason salary HDL fails?

The most common reasons are invalid SalaryBasisName and incorrect AssignmentNumber.

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" ?>

  <Basket>

    <Fruit>

        <Type>Apple</Type>

        <Number>2</Number>

    </Fruit>

    <Fruit />

    <Fruit>

        <Type>Orange</Type>

        <Number>5</Number>

    </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 

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.

HDL Template to load BLOB/CLOB files for Talent Profile

HDL Template to load BLOB/CLOB files for Talent Profile 

File Name - TalentPofile.dat

You can see step by step video to load Talent Profile data using this Link

Please find the below sample template :

Add ItemClob1File  Column in profile item metadata and clob files are placed in "ClobFiles" Folder.

METADATA|TalentProfile|SourceSystemOwner|SourceSystemId|Description|Summary|ProfileTypeCode|ProfileCode|ProfileStatusCode|ProfileUsageCode|PersonId

MERGE|TalentProfile|XXTEST|XXTEST_TALENT2|||PERSON|PERSON_TALENT|A|P|100000609812368

METADATA|ProfileItem|SourceSystemOwner|SourceSystemId|ProfileId(SourceSystemId)|ContentType|ContentItem|SectionName|CountryCountryCode|DateFrom|DateTo|RatingModelCode1|RatingModelCode2|RatingModelCode3|RatingLevelCode1|RatingLevelCode2|RatingLevelCode3|ItemClob1File  

MERGE|ProfileItem|XXTEST|XXTEST_TALENTPROF2|XXTEST_TALENT2|LANGUAGE|Hindi|PERSON_LANGUAGE||2021/07/26||LANGUAGE|LANGUAGE|LANGUAGE|HIGH|HIGH|HIGH|