Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Fusion PayRoll
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

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:

 

  1. Create a simple custom extract

  2. Create a EText Template and associate it with the custom report attached to Extract (Delivery Options)

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

 

ETextExtract

 

New_Joiner_EText.rtf


Ashish Harbhajanka

Comments   

0 #1 Spinoppolo 2021-08-10 17:19
Hoвoe oнлaйн Kaзuно - Бoнyc кaждoмy!
Рeгистрирyйся - зaбери свoй Бoнyс и игрaй.
нeoграничeный дeпoзит, и мoмeнтльный вывoд!
https://cahopsong.tk/help/?15561621856649
Quote
0 #2 auto approve lists 2022-04-24 04:40
I am curious to find out what blog platform you're utilizing?
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 ?
Quote
0 #3 news 2022-04-24 13:20
Have you ever thought about creating an ebook or guest authoring on other sites?
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.
Quote
0 #4 news 2022-05-11 00:53
It's really a great and useful piece of information. I am happy that you just shared this useful
info with us. Please keep us informed like this. Thank you for sharing.
Quote
0 #5 private blog network 2022-05-13 20:24
Hello! I know this is kind of off topic but I was wondering
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!
Quote
0 #6 auto approve lists 2022-05-13 21:39
This website really has all of the information and facts I
needed concerning this subject and didn't know who to ask.
Quote
0 #7 news blog 2022-05-15 09:08
Have you ever considered about adding a little bit more than just your articles?

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!
Quote
0 #8 slot 633 2022-05-24 13:35
I love your blog.. very nice colors & theme. Did you create this website yourself or did you hire someone to do it for
you? Plz reply as I'm looking to create my own blog and would like
to know where u got this from. many thanks
Quote
0 #9 save refuges 2022-06-07 07:59
Hi, i believe that i noticed you visited my web site thus i
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!!
Quote
0 #10 help refuges 2022-06-07 08:13
I'm not certain the place you're getting your info, but
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.
Quote

Add comment


Security code
Refresh

About the Author

Ashish Harbhajanka

 

Oracle Fusion HCM Techno Functional Consultant with overall 10 years of Experience in software industry with 5 years in EBS HRMS and rest 5 in Fusion HCM.

My areas of intesrest in Fusion HCM include :

a) Inbound Outbound Integration using FBL/HDL or BIP/HCM Extracts.

b) Fast Formula

c) BIP Reports

d) OTBI Reports

e) RESTFUL API / Web Service Call

f) Functional Setup

g) End to End Testing

h) Regression Testing

i) Preparing COnfiguration Workbooks

j) Creating Speed Solutions

k) Preparing User Guides

l) UPK

........

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Mar 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910
11121314151617
18192021222324
25262728293031

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner