Introduction
I hope most of you have already gone through one of my earlier post where we have seen how to Load Data Into Oracle HCM Cloud Using Inbound Interface Option. If you have not seen the post yet please feel free to refer the same from this link .
In this post we would try to achieve a similar data load mechanism but in this case we will try to use the BI Publisher Report instead.
Many a times we have to perform Discretionary Disbursement from the various Absence Plans configured in the application. Most of the time this is a manual process but if there is a set of rule to be followed and the number of employees for whom this action needs to be performed is huge it makes sense to automate the process. In this post we would try to achieve the same using a BI Publisher Report.
We would try to load Person Accrual Detail data using a BIP Report in this example.
Pre-Requisites
Some of the pre-requisites for this include:
- Configuring a Source System Owner
I have configured a new Source System Owner ( Navigation: Setup and Maintenance -> Manage Common Lookups -> HRC_SOURCE_SYSTEM_OWNER -> Add New Lookup Value (HRC_LEGACY)
- Identifying a Absence Plan which has “Discretionary Disbursement” enabled
We need to either find or configure a Absence Plan which has discretionary disbursement feature enabled. For this example, we will use “Vacation”
- Creating a Report to get HDL File format for PersonAccrualDetail.dat Business Object
We would also need to create a Report which should have a custom Data Model attached which should fetch all the relevant data fields required in PersonAccrualDetail.dat data file. We would also need to attach a E-Text Template to the Report to ensure we get data from the application in HDL File Format. In addition to this we would also need to have a Bursting SQL added to the data model which will ensure that we are able to change the file name from “DefaultDocument” to “PersonAccrualDetail” . If you are using a different HDL Object then the name should correspond to the HDL Object.
- Creating Custom Data Model to get Required Data Fields
We would need to create a Data Model which should have below SQL query as data-source.
We would need to fetch below data-columns:
ii) Creating Bursting Query to Change File Name
We would need a Bursting SQL query to change the file name. The SPLIT BY and DELIVER BY field should hold /DATA_DS/G_3/KEY
iii) Attaching E-Text Template to BI Publisher Report
We would also need to associate a EText Template to the BI Publisher Data Model created above. Details of the E-Text Template are provided below for ready reference
The eText Template would look as below
Worked Example
As all the pre-requisite are in place we can now start with the next steps. We would need to create a HCM Extract of Inbound Interface Type with following details:
There is one Record named “DummyExtractRecord” which comprises of 1 data element. Details in table below:
Once configured the Extract Attributes should appear as below:
Next we need to configure “Extract Delivery Options”
Once configured the Extract Delivery Options will appear as below:
Once all the above changes are done we should Add a New Parameter “Load Automatically” and set “Visible” property to Yes.
Once done we can Validate the Extract and once it is successfully validated we can Save and Close.
In the next step, we would need to Add a Flow Task named “Initiate HCM Data Loader” to “Inbound Interface Using BIP” Flow pattern. We can either navigate to Payroll->Checklist-> Search for Inbound Interface Using BIP or use Refine Extracts->Search for Inbound Interface Using BIP
Once the search results are retrieved, we need to click on “Edit” (pencil icon) and choose the following task
Once we add the payroll flow task we should click on “Go To Task” and add the following details:
And with this HCM Extract Setup is complete.
Running the Extract
In this step we will try running the Extract.
Once submitted we can monitor the status of the payroll flow instance
From the above screenshot we can see that all the process has been successful and hence a Data Load should have got triggered. We can navigate to Data Exchange->HCM Data Loader -> Import and Load Data page to verify this. (While doing a search make sure you set the Created By filter to Blank else the Data Set would not appear) . We would search for Content ID as DL_PERSONAC_1806418
From the screenshots we can see that the data got loaded successfully.
In the next step we will verify the same in application. We can perform this verification in two ways.
- By Running a SQL Query
And we could see the results in BI Data Model
- From Application UI
We would navigate to Person Management-> Search for Person Number 50-> Absence Records and go to Plan Participation Section, Choose “Vacation” plan and we should be able to see disbursement details
Similarly, we can check for person# 51,52,53,54 and 55 too.
Summary
So this is how we can use BI Publisher SQL based Data Source and load data into Oracle HCM Cloud Application by making use of Dummy HCM Extract of Inbound Interface. One may try to extend this logic and make the solution more flexible by making use of bind parameters and also applying this solution to other use-cases.
With this I have come to the end of this article, hope this was a good read.
Thanks for your time and have a great day ahead.
You can download the below list of files using link here
Comments
The file created from the Extract is named as: Candidate.dat.t xt. Will this work? Is it coz of the Text format we are providing in the bursting SQL? Not sure how to get .dat output from the Report through Extract.
If anyone knows this guys please tell me.
by chance, and I'm shocked why this coincidence didn't happened earlier!
I bookmarked it.
Where are your contact details though?
websіte. Kеep up the good writing.
Look at mү website: calendário de maio: http://shieh.com/__media__/js/netsoltrademark.php?d=indianetmarket.com%2Findex.php%3Fpage%3Duser%26action%3Dpub_profile%26id%3D96655
The clarity on your publish is simply great and i can suppose you
are a professional on this subject. Fine with your permission let
me to take hold of your feed to keep up to date with imminent post.
Thank you 1,000,000 and please keep up the enjoyable work.
Feel free to visit my blog post monthly
calendar pdf: http://Tim-mcgrath.com/__media__/js/netsoltrademark.php?d=bemobilebesafe.com%2F__media__%2Fjs%2Fnetsoltrademark.php%3Fd%3Dwww.pinterest.com%252F7calendar%252F
issues aѕ ᴡell..
Αlso visit my homepaցe private
planner blog: https://t.me/s/printable_calendar
site before but after reading through some of the post I realized it's new to me.
Nonetheless, I'm definitely delighted I found it and I'll be book-marking and checking back frequently!
precious know-how concerning unpredicted feelings.
but, I'd like to send you an e-mail. I've got some ideas for your blog you might be interested in hearing.
Either way, great blog and I look forward to seeing it improve over time.
I have joined your rss feed аnd look forward to seekіng
more ߋf your great post. Also, I have shared your website in my social networks!
My wweb blⲟg - caⅼendário de abril: http://www.cxxxb.com/space-uid-210937.html?do=profile
hackers? My last blog (wordpress) was hacked and I ended up losing a few months of hard
work due to no back up. Do you have any methods to prevent hackers?
it for you? Plz respond as I'm looking to design my
own blog and would like to find out where u
got this from. thanks a lot
future. I want to encourage continue your great work,
have a nice day!
You're very intelligent. You know therefore significantly in relation to
this matter, made me in my view imagine it from so many various angles.
Its like women and men are not fascinated unless it's something
to accomplish with Lady gaga! Your own stuffs outstanding.
All the time deal with it up!
you actually know what you are talking approximateⅼy!
Bookmɑrked. Please also talk over ѡіth my website =).
We may have a hyperlink trade agreement among us
Also visit my wеb blog caⅼеndário
de agosto: http://gdpartners.com/__media__/js/netsoltrademark.php?d=dorama.one%2Fuser%2FMXYKeeley0%2F
they will help, so here it occurs.
My web page ... p3747070: https://www.tapatalk.com/groups/renotalkfr/viewtopic.php?p=3747070
You should proceed your writing. I'm sure, you have a huge readers' base already!
Take a look at my page - ежедневный дневник: https://vc.ru/life/477671-dorogoy-dnevnik-kak-ezhednevnye-zapisi-proishodyashchego-i-refleksiya-vliyayut-na-zdorove-nastroenie-i-pamyat
getting more from this web page, and your views are good in favor of new visitors.
Stop by my web-site: 打印日历九月: https://myptc.xyz/
RSS feed for comments to this post