Usecase: "Can you provide an iCal expression for scheduling a task to run at 4 PM on June 30th and December 31st each year in the Oracle Integration Cloud (OIC) scheduler?"
Solution:
FREQ=YEARLY;BYMONTH=6,12;BYMONTHDAY=30,31;BYHOUR=16;BYMINUTE=0
Usecase: "Can you provide an iCal expression for scheduling a task to run at 4 PM on June 30th and December 31st each year in the Oracle Integration Cloud (OIC) scheduler?"
Solution:
FREQ=YEARLY;BYMONTH=6,12;BYMONTHDAY=30,31;BYHOUR=16;BYMINUTE=0
Requirement: We need to create a file name where we need to populate Month's name as MMM like Sep, Oct etc.
Solution:
fn:concat('HCM_FTE_',ns96:format-dateTime(fn:current-dateTime(),'[MNn,*-3]-[Y001]'),'.csv')
Note: for Caps month like SEP. OCT , use as [MN,*-3]
Working...
Usecase: external worker data hdl import to HCM.
Requirements & Considerarions:
Usecase: Here,we will see how to check or export the report after importing an HCM Business Object using HDL, and review the results for errors or validation issues. We will send UCM content id as input and get the error details.
Implementation steps:
Data model SQL:
SELECT DISTINCT l.MESSAGE_SOURCE_LINE_ID,
l.msg_text,
fl.TEXT
FROM fusion.hrc_dl_message_lines l,
fusion.hrc_dl_data_set_bus_objs bo,
fusion.hrc_dl_data_sets ds,
fusion.hrc_dl_file_rows fr,
fusion.hrc_dl_file_lines fl,
fusion.hrc_dl_physical_lines pl
WHERE ((l.message_source_table_name = 'HRC_DL_LOGICAL_LINES'
AND l.message_source_line_id = pl.logical_line_id)
OR (l.message_source_table_name = 'HRC_DL_PHYSICAL_LINES'
AND l.message_source_line_id = pl.physical_line_id))
AND l.data_set_bus_obj_id = bo.data_set_bus_obj_id
AND ds.data_set_id = bo.data_set_id
AND ds.ucm_content_id IN (:P_ucmContentID)
AND fl.line_id = fr.line_id
AND fl.data_set_bus_obj_id = bo.data_set_bus_obj_id
AND fr.logical_line_id = pl.logical_line_id
AND l.is_latest_flag = 'Y'
Filter Expr for ERP Integration Outbound event:
<xpathExpr
xmlns:ns0="http://xmlns.oracle.com/apps/financials/commonModules/shared">
$eventPayload/ns0:JOBS[ns0:JOBNAME='INT332_ADP_BIP_CUSTOM_ESS']
</xpathExpr>
Detailed steps with screenshots:
Step1: Create data model and BIP Report.
Step2: Create ESS job which calls the step1 BIP report.
Test ESS job from HCM:
Step3: once the hdl import completed, run exportBulkData operation of ErpIntegrationservice using Oracle cloud HCM adapter
Step4: create a callback integration and get report and transformed the reprot and save to OIC embedded sftp location for support help.
Event subscribe:
Usecase: Here, we will see the steps how we can check the hdl import or load status from hcm side.
Steps:
Step1: my client group >> data exchange >> recent file loads >>search and you will see the recent load files. Capture the content id.
1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper: File⇾Import⇾Service Bus Resources⇾ Se...