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