Tuesday 2 July 2024

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



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.


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

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











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

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