Introduction
For most of the consultants who have been working with legacy ERP Applications like EBS, Peoplesoft one common requirement have been to send Flat Files (either in CSV, Pipe Delimited or EFT files) to third party systems for further processing. While generating such files using an on-premise system was not a big deal (availiblity of SQL , PL/SQL) it could be a challenge to generate the same in an Oracle HCM Cloud. I know many a times some generate raw data (XML format) from HCM Extract and use some of the middleware tools (Boomi,Mulesoft..etc) to get flat files from there. While I dont say that it does not has his own set of advantages and disadvantages but the same can be achieved in Oracle HCM Cloud Application too by making use of EText Template.
We would see how we do this in this example.
For the same we would perform the following steps:
-
Create a simple custom extract
-
Create a EText Template and associate it with the custom report attached to Extract (Delivery Options)
-
Verify Results
So withour further delay let;s get started
Create a simple custom extract
We would create a simple HCM Extract which would comprise of First Name, Last Name, Employee Number, Email-id, Organization Name and other fields. We will call this extract as ETextExtract.
The Extract components are as follows
And we also need to check that the Extract status is valid ( from Extract Execution Tree )
Creating EText Template
We would need to create an EText Template too for the same. The EText Template ( we name it as New_Joiner_EText.rtf) will have a header part and one one data part.
The Header part will appear as below:
And the Data part as shown in screenshot below:
Verifying Results
Now that we have all the components in place we will run the extract and verify the results.
And once we click on View Results (highlighted in yellow in above screenshot) we will see all available output files
And the output file will be as below:
The Extract Definition File and EText Template can be downloaded from below link:
Comments
Рeгистрирyйся - зaбери свoй Бoнyс и игрaй.
нeoграничeный дeпoзит, и мoмeнтльный вывoд!
https://cahopsong.tk/help/?15561621856649
I'm experiencing some minor security issues with my latest blog and I'd like to find something
more risk-free. Do you have any recommendations ?
I have a blog centered on the same ideas you discuss and would really like to have you share
some stories/informa tion. I know my subscribers would
enjoy your work. If you are even remotely interested, feel free
to shoot me an e-mail.
info with us. Please keep us informed like this. Thank you for sharing.
if you knew where I could find a captcha plugin for my comment form?
I'm using the same blog platform as yours and I'm having
trouble finding one? Thanks a lot!
needed concerning this subject and didn't know who to ask.
I mean, what you say is important and all. Nevertheless just imagine if you added
some great graphics or video clips to give your posts more, "pop"!
Your content is excellent but with pics and clips, this site could definitely
be one of the most beneficial in its field. Awesome
blog!
you? Plz reply as I'm looking to create my own blog and would like
to know where u got this from. many thanks
came to return the choose?.I'm attempting to find things to enhance my web site!I assume its ok to use a few of your
ideas!!
good topic. I needs to spend some time studying more or figuring out more.
Thanks for excellent info I was looking for this info for
my mission.
RSS feed for comments to this post