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|

HDL Template to Absence Entry of Worker

✅ Oracle HCM HDL: Load Worker Absence Entry (PersonAbsenceEntry.dat) – Template + Examples

Absence management is one of the most common business requirements in Oracle Fusion HCM. If you need to load absence entries for employees in bulk (Sick leave, Earned leave, Casual leave, etc.), Oracle provides the HDL object:

👉 PersonAbsenceEntry (and its child object PersonAbsenceEntryDetail)

This post provides a complete HDL template with real working examples, along with prerequisites, common issues, and FAQ.

---

⭐ What is PersonAbsenceEntry in Oracle HDL?

PersonAbsenceEntry is an HDL business object used to create or update worker absence entries in Oracle Fusion HCM.

It supports:

• Absence Type (Sick, Annual Leave, etc.)

• Absence dates and time

• Absence status + approval status

• Assignment-level detail (via PersonAbsenceEntryDetail)

---

✅ Prerequisites (Important)

Before loading absence entry using HDL, verify:

1) Worker must exist

The PersonNumber must be valid.

2) Absence Plan must be enrolled first

If the worker is not enrolled in the absence plan, the absence entry load may fail.

✅ Example errors:

• Plan not enrolled

• Absence type not eligible

• No accrual available

3) Absence Type must exist

Absence Type should be configured in:
Absence Administration → Absence Types

4) Employer / Legal Entity should match worker

Use correct employer name.

---

📂 HDL File Name

📌 File Name:
PersonAbsenceEntry.dat

---

🧾 HDL Sample Template: PersonAbsenceEntry

This is the main absence entry record.

METADATA|PersonAbsenceEntry|Employer|PersonNumber|AbsenceType|AbsenceReason|AbsenceStatus|ApprovalStatus|StartDatetime|EndDatetime|StartDate|StartTime|EndDate|EndTime|SourceSystemOwner|SourceSystemId
MERGE|PersonAbsenceEntry|US3 Legal Entity|XXTEST2|Sick||SUBMITTED|APPROVED||2021/07/12 08:00:00|2021/07/12|08:00|2021/07/12|16:30|XXTEST|XXTEST2_SICK1

---

🔍 Explanation of Key Fields

• AbsenceType: Example: Sick, Annual Leave, etc.

• AbsenceStatus: Usually SUBMITTED

• ApprovalStatus: APPROVED / PENDING

• StartDatetime / EndDatetime: Used for date+time entry

• StartDate / EndDate: Used for date only entries

• SourceSystemOwner / SourceSystemId: Must be unique per absence record

---

🧾 HDL Sample Template: PersonAbsenceEntryDetail 

This object is used when you want to load daily/time details and connect absence to assignment.

METADATA|PersonAbsenceEntryDetail|AbsenceDate|Employer|PersonNumber|AbsenceType|AssignmentNumber|AbsenceStartDate|AbsenceStartTime|RowSeq|StartTime|EndTime|SourceSystemOwner|SourceSystemId
MERGE|PersonAbsenceEntryDetail|2021/07/12|US3 Legal Entity|XXTEST2|Sick|XXTEST_ASSIGN2-1|2021/07/12|08:00|1|06:00|16:30|XXTEST|XXTEST2_SICK1

---

⭐ Why PersonAbsenceEntryDetail is required?

You should use PersonAbsenceEntryDetail when:

✅ Absence is hourly
✅ Absence spans multiple dates
✅ You need assignment-level mapping
✅ You want exact daily breakdown

---

🧠 Recommended HDL Zip Structure

Your zip should look like this:

AbsenceEntryLoad.zip
 └── PersonAbsenceEntry.dat

Upload from:

Data Exchange → HCM Data Loader → Import and Load

---

⚠️ Common Errors and Fixes

❌ Error: Worker is not enrolled in absence plan

✅ Fix: Enroll the worker first in the plan.

---

❌ Error: Invalid Absence Type

✅ Fix: Verify Absence Type spelling and configuration.

---

❌ Error: SourceSystemId already exists

✅ Fix: Use unique SourceSystemId for each absence entry.

---

❌ Error: AssignmentNumber invalid

✅ Fix: Confirm assignment number from Person Management.

---

🔗 Internal Links 

• HDL Load Worker Data (Person/Assignment)

• HDL Assignment Supervisor Template

• HDL Bank → Branch → External Bank Account → Personal Payment Method

• HDL Assigned Payroll Template

• HDL Element Entry Template

• HDL For Seniority Dates

---

💬 Feedback & Comments

If this absence entry HDL template helped you, drop your feedback in the comment section 🙌

If you face any issue, share:

• HDL error message

• Absence Type name

• Whether plan enrollment exists

• Your sample Worker.dat snippet (remove sensitive data)

---

❓ FAQ

Q1. Can we load absence entries using HDL in Oracle HCM?

Yes. You can load worker absences using the HDL objects PersonAbsenceEntry and PersonAbsenceEntryDetail.

---

Q2. Is absence plan enrollment required before loading absence entry?

Yes. In most cases, the worker must be enrolled in the absence plan first.

---

Q3. Which file is used to load absence entry in HDL?

The commonly used HDL file is PersonAbsenceEntry.dat.

---

Q4. What is the purpose of PersonAbsenceEntryDetail?

It provides daily/hourly absence details and connects the absence entry to assignment.

---

Q5. Can we load hourly absences using HDL?

Yes. Hourly absences are supported by providing StartTime and EndTime in PersonAbsenceEntryDetail.

---

Q6. What should be the AbsenceStatus and ApprovalStatus?

Typically:

• AbsenceStatus = SUBMITTED

• ApprovalStatus = APPROVED (or PENDING depending on workflow)

HDL Template to Accrual Plan Enrollment of Worker

HDL Template to Accrual Plan Enrollment of Worker

Please find the below sample template :

File Name - PersonAccrualPlanEnrollment.dat

METADATA|PersonAccrualPlanEnrollment|PersonNumber|WorkTermAsgNum|PlanName|EnrtStDt|SourceSystemId|SourceSystemOwner

MERGE|PersonAccrualPlanEnrollment|XXTEST22|XXTEST_WRKTERM22|Sick|2021/01/01|XXTEST_SICK1|XXTEST

HDL Template to Disability of Worker

 HDL Template to Person Disability

Please find the below sample template :

File Name- PersonDisability.dat

METADATA|PersonDisability|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|LegislationCode|PersonId|PersonNumber|SelfDisclosedType|Category|QuotaFTE|Status

MERGE|PersonDisability|XXTEST|XXTEST_DIS21|2021/07/07|4712/12/31|US|100000609337422|XXTEST21|ORA_PER_YES_US|NA|1|A

 

HDL Template to Change Hire Date of Worker

✅ HDL Template to Change Hire Date of Worker in Oracle Fusion HCM (Worker.dat)

Changing an employee’s Hire Date (Start Date) is a common requirement in Oracle Fusion HCM, especially when correcting wrong employee joining dates loaded from legacy systems or during data migration.

In this blog, you will learn how to change Hire Date of a worker using HDL (HCM Data Loader) with Worker.dat file.

---

🔥 What is Hire Date in Oracle Fusion HCM?

In Oracle Fusion HCM, the hire date is stored at the Work Relationship level.
That’s why to change Hire Date using HDL, you must update the WorkRelationship component inside Worker.dat.

---

📌 HDL File Used

✅ Worker.dat

---

⚠️ Important Note Before Updating Hire Date

Before you change hire date, ensure:

• Worker already exists in Fusion HCM

• You know correct identifiers like PersonId or PersonNumber

• Hire date change may impact:

  • Payroll

  • Absence

  • Seniority

  • Benefits eligibility

  • Assignment start dates

So always validate in lower environment first.

---

✅ HDL Template to Change Hire Date of Worker (Worker.dat)

Use below template exactly:

SET PURGE_FUTURE_CHANGES N

METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|
PersonId(SourceSystemId)|LegalEmployerName|NewStartDate
MERGE|WorkRelationship|XXTEST|XXTEST_HIREDATE1|100009|India Legal Entity|
2002/02/10

---

🧾 Explanation of Fields (Worker.dat)

Column	Meaning
SourceSystemOwner	Your source system name (ex: XXTEST)
SourceSystemId	Unique record identifier for this HDL row
PersonId(SourceSystemId)	PersonId of the worker (can be PersonNumber too in other templates)
LegalEmployerName	Must match worker’s legal employer
NewStartDate	The corrected hire date you want to set

---

⭐ Why We Use SET PURGE_FUTURE_CHANGES N

This line controls whether future-dated changes should be purged.

✅ Recommended:

SET PURGE_FUTURE_CHANGES N

Because:

• It keeps future-dated transactions safe

• Prevents accidental loss of future assignment updates

---

🧭 Step-by-Step: How to Load HDL to Change Hire Date

Step 1: Prepare Worker.dat file

• Copy the template

• Replace with your employee values

Step 2: Create ZIP

Zip the file as:

Worker.zip
  └── Worker.dat

Step 3: Upload in HCM Data Loader

Navigation:

My Client Groups → Data Exchange → HCM Data Loader

1. Click Import and Load

2. Upload the ZIP file

3. Submit the process

Step 4: Validate Results

After load:

• Check Import and Load Status

• Review logs if errors occur

---

✅ How to Verify Hire Date is Updated

Go to:

Person Management → Search Worker → Employment → Work Relationship

Check:

• Start Date / Hire Date updated correctly

---

❗ Common Errors and Fixes

1) Legal Employer Name Invalid

Error: LegalEmployerName not found
✅ Fix: Use exact legal employer name from Fusion setup.

---

2) PersonId Incorrect

Error: PersonId(SourceSystemId) not found
✅ Fix:

• Use correct PersonId

• Or use PersonNumber based mapping (if your environment supports)

---

3) Future Changes Conflict

Error: Cannot update because of future-dated changes
✅ Fix:

• Review future-dated transactions

• Keep SET PURGE_FUTURE_CHANGES N

---

🔗 Internal Links 

• HDL Template to Load Worker Data (Worker.dat)

• HDL Template to Update Assignment Supervisor

• HDL Template to Update Salary using Salary.dat

• HDL Template for Personal Payment Method

• HDL Template for Element Entry

• HCM Extract Changes Only Mode