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

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 - Click to get instance

Thursday 19 January 2023

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

HDL Template to Absence Entry of Worker

Please find the below sample template :

File Name - PersonAbsenceEntry.dat


Note :- Please verify Absence plan must be enrolled first to load absence entry. 


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


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


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

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