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

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.

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.

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

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

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