In this article we will look into how to schedule the HCM Extracts at ad-hoc schedules or complex schedules which cannot be handled using a simple way. In our previous article we saw how to Schedule/Cancel Schedule for HCM Extracts. Click here if you have missed to look at it.The previous article covers scheduling Extract at Once/Daily/Weekly/Monthly frequency only. However if we…
In this article we will look at how to schedule and cancel an existing schedule of HCM Extract. If you haven't gone through the basics of HCM Extract, please have a look by clicking here Scheduling an HCM Extract: Navigate to Payroll > Checklist orMy Client Groups > Data Exchange > Submit ExtractsSearch for the extract and click Next Submit Extracts…
In this article we will look into how to create etext template. When we have a requirement to generate a fixed length or delimited output files using BI Publisher or HCM Extract we will use the e-text template to achieve this requirement. I have come across a lot of people who are new to etext template and asked me to…
In this article we will look into cancelling an existing Work Relationship of an employee using HDL process. We can prepare the HDL file with the required user keys to delete the work relationship. Sample HDL to delete Work Relationship(Worker.dat): SET PURGE_FUTURE_CHANGES N METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|PersonNumber|DateStart|WorkerType|CancelWorkRelationshipFlag DELETE|WorkRelationship|HRC_SQLLOADER|1122334455|123456789_1|Legal Entity Two||2010/01/01|E|Y When we have a requirement to cancel multiple work relationships due to bad…
We will try to extract Valueset and Lookup values using SQL Query. Independent Valueset details: SELECT ffvs.flex_value_set_name ,ffvs.description set_description ,ffv.flex_value ,ffvt.flex_value_meaning ,ffvt.description value_description FROM fnd_flex_value_sets ffvs ,fnd_flex_values ffv ,fnd_flex_values_tl ffvt WHERE ffvs.flex_value_set_id = ffv.flex_value_set_id AND ffv.flex_value_id = ffvt.flex_value_id AND ffvt.LANGUAGE = USERENV('LANG') AND TRUNC(SYSDATE) BETWEEN NVL(ffv.start_date_active, trunc(SYSDATE)) AND NVL(ffv.end_date_active, trunc(SYSDATE + 1)) AND ffvs.flex_value_set_name = 'ABCD_BRANCH_VS' Table based Valueset details:…
We have requirement to upload/download the files from UCM/to UCM regularly when you are dealing with inbound files/outbound files. Oracle CoE (Center of Excellence) team has provided a small java utility to do this at ease. You can download the Oracle HCM COE – UCM Utility package from here. Once you download the zip file, you can extract the files and…
We can run the BI Reports ad-hoc, or schedule them to email/FTP at weekly/daily basis. However we will explore the option of scheduling the BIP Report using SOAP webservices. SOAP WSDL: https://{hostname}/xmlpserver/services/v2/ScheduleService?wsdl Sample: https://abcd-test.fa.us6.oraclecloud.com/xmlpserver/services/v2/ScheduleService?wsdl Once we have the WSDL, we can use the SOAPUI to consume this WSDL and execute the scheduleReport request with the below payload. <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v2="http://xmlns.oracle.com/oxp/service/v2"><soapenv:Header/><soapenv:Body><v2:scheduleReport><v2:scheduleRequest><v2:bookBindingOutputOption>false</v2:bookBindingOutputOption><v2:mergeOutputOption>false</v2:mergeOutputOption><v2:notifyHttpWhenFailed>false</v2:notifyHttpWhenFailed><v2:notifyHttpWhenSkipped>false</v2:notifyHttpWhenSkipped><v2:notifyHttpWhenSuccess>false</v2:notifyHttpWhenSuccess><v2:notifyHttpWhenWarning>false</v2:notifyHttpWhenWarning><v2:notifyWhenFailed>false</v2:notifyWhenFailed><v2:notifyWhenSkipped>false</v2:notifyWhenSkipped><v2:notifyWhenSuccess>false</v2:notifyWhenSuccess><v2:notifyWhenWarning>false</v2:notifyWhenWarning><v2:repeatCount>1</v2:repeatCount><v2:repeatInterval>0</v2:repeatInterval><v2:reportRequest><v2:attributeFormat>csv</v2:attributeFormat><v2:attributeLocale>en_US</v2:attributeLocale><v2:attributeTemplate>xt</v2:attributeTemplate><v2:byPassCache>true</v2:byPassCache><v2:flattenXML>false</v2:flattenXML><v2:parameterNameValues><v2:listOfParamNameValues><v2:item><v2:name>CONTENTID</v2:name><v2:values><v2:item>INPUTCONTENTID</v2:item></v2:values></v2:item></v2:listOfParamNameValues></v2:parameterNameValues><v2:reportAbsolutePath>/Custom/SM/TEST/REPORT.xdo</v2:reportAbsolutePath><v2:sizeOfDataChunkDownload>0</v2:sizeOfDataChunkDownload></v2:reportRequest><v2:saveDataOption>false</v2:saveDataOption><v2:saveOutputOption>true</v2:saveOutputOption><v2:scheduleBurstringOption>true</v2:scheduleBurstringOption><v2:schedulePublicOption>false</v2:schedulePublicOption><v2:startDate/><v2:useUTF8Option>false</v2:useUTF8Option><v2:userJobDesc>SampleJob</v2:userJobDesc><v2:userJobName>SampleJob</v2:userJobName></v2:scheduleRequest><v2:userID>*******</v2:userID><v2:password>*******</v2:password></v2:scheduleReport></soapenv:Body></soapenv:Envelope> You can…
There are many scenarios where-in the technical developers would need production access to look into any issues for hcm extract runs/BI reports/some setup issues. Security Administrator would have concerns on providing full access to the developers as there are chances that the developer could do some changes with or without knowledge as mostly the developers will have TECHADMIN or superuser…
Oracle has recently introduced the Location Based Access Control as known as LBAC in Oracle HCM Cloud from 19D. By default this feature will be disabled. In this article we will look at enabling the LBAC option and the benefits of it. What is LBAC?LBAC means Location Based Access Control and it is used to control the access of the…
Many of you might already know about the Cloud Customer Connect and it's usage. This post is for those of you who don't know about it and how you can take advantage of it to gain knowledge and solve your issues. Why Cloud Customer Connect?Cloud Customer Connect is a forum by Oracle which is specific to Cloud products (HCM/ERP/SCM/OIC/PAAS/CX/IAAS/Students). Oracle…
