Introduction
One of the most common and yet most desired report in any ERP Application would be system generated reports reason being for every individual hired into an organization there should always be a printed document having a standard format which would contain the most relevant details to be used by the hired individual. Typical Examples could be “Offer Letter” (pre-joining), “Appointment Letter” (on-joining), “Welcome Letter” (post-joining) …… to name a few.
In this example, we would try to understand the following:
-
What is a Welcome letter?
-
What information does it comprises of?
-
Why is it Required?
-
How to prepare a Welcome Letter?
So without further delay, let us try to understand the same.
-
What is a Welcome letter?
Welcome Letter as the word suggests is a letter of gratitude from the Organization to the newcomer stating his/her role, details about the person to contact in case of any need and most importantly a mode/ medium via which the Organization reaches out to the individual and tries to build a healthy relationship thereby initiating a conversation/discussion.
-
What does a Welcome letter comprises-of?
Different organizations may have a very different template for the same but all of them (organizations) would definitely have the following areas covered in the same:
-
Congratulating the individual on joining the organization
-
Job Role of the individual
-
An overview of how does an employee plays a role in the organization’s growth
-
Details about contact person / team the individual should reach out to for any kind of help required for a smooth transition enabling the individual to become an integral part of the organization.
-
Why is it required?
As already stated in point B above it serves two-fold purpose. First it gives the organization an opportunity to connect with the individual whereas the individual gets information about the team / individual whom he/she needs to reach out for any help / assistance required.
-
How-to prepare a Welcome Letter?
We would have to perform the following activities in order to prepare a Welcome letter:
Step 1: Create a BIP Data Model
Step2: Create a RTF Template
Step3: Generate the Report
We would elaborate on each of the above step (with a brief summary and a screen-shot)
Step1: Create a BIP Data Model
For this example, we would need 2 queries
# |
Query |
1 |
SELECT initcap(ppn.title) title, :Emp, upper(ppn.first_name||'.'||ppn.last_name) PASSWORD, ppn.first_name||' '||ppn.last_name Person_Display_Name, ppn.first_name, ppn.last_name, (CASE when pad.country in ('DK', 'SE', 'FR' , 'DE' ,'BE', 'FR', 'GB') then (pad.address_line_1 ||chr(10)|| pad.postal_code||' '|| pad.town_or_city||chr(10)|| ter1.territory_short_name) WHEN pad.country = 'US' then (pad.address_line_1||chr(10)|| pad.town_or_city||', '||upper(pad.REGION_2)||pad.postal_code||chr(10)|| pad.REGION_1||chr(10)|| upper(ter1.territory_short_name)) WHEN pad.country = 'CN' then (upper(ter1.territory_short_name)||chr(10)|| pad.postal_code ||' '|| upper(pad.REGION_3)||chr(10)|| ', '||pad.ADDL_ADDRESS_ATTRIBUTE2||chr(10)|| pad.address_line_1||chr(10) ) WHEN pad.country in ('AE', 'SA', 'LY', 'SY') then (pad.address_line_1||chr(10)|| pad.ADDRESS_LINE_2||chr(10)|| pad.town_or_city||chr(10)|| pad.postal_code||chr(10)|| ter1.territory_short_name) ELSE (pad.address_line_1 ||chr(10)|| pad.postal_code||' '|| pad.town_or_city||chr(10)|| ter1.territory_short_name) END) Address_Emp, TO_CHAR(pp.date_of_birth,'DD-MON-YYYY') Person_Date_of_Birth, pj.name Extract_Assignment_Name, pg.name Assignment_Grade_Code, csa.salary_amount*csb.salary_annualization_factor Assignment_Salary, pam.normal_hours Assignment_Standard, (select name from hr_all_organization_units where organization_id = pam.organization_id) ORG_NAME, ppf.person_id, pam.assignment_id, pam.legal_entity_id, csa.salary_id, csb.salary_basis_id, (select nm.DISPLAY_NAME from PER_PERSON_NAMES_F_V nm, PER_ASSIGNMENT_SUPERVISORS_F sup where nm.PERSON_ID = sup.MANAGER_ID and nm.name_type = 'GLOBAL' and sup.PERSON_ID = ppf.PERSON_ID and sup.ASSIGNMENT_ID = pam.ASSIGNMENT_ID and sysdate between sup.effective_start_date and nvl(sup.effective_end_date, sysdate+1)) MGR_NAME FROM per_all_people_f ppf, per_person_names_f ppn, per_all_assignments_m pam, PER_JOBS_F_VL pj, per_grades_f_vl pg, cmp_salary csa , cmp_salary_bases_vl csb, per_addresses_f pad, per_persons pp, per_national_identifiers pni, fnd_territories_vl ter1 WHERE ppf.person_id =pam.person_id AND(pad.COUNTRY = ter1.territory_code(+)) AND ppn.person_id=ppf.person_id AND sysdate BETWEEN ppf.effective_start_date(+) AND ppf.effective_end_date(+) AND sysdate BETWEEN ppn.effective_start_date(+) AND ppn.effective_end_date(+) AND sysdate BETWEEN pam.effective_start_date(+) AND pam.effective_end_date(+) AND sysdate BETWEEN pj.effective_start_date(+) AND pj.effective_end_date(+) AND sysdate BETWEEN pg.effective_start_date(+) AND pg.effective_end_date(+) AND sysdate BETWEEN pad.effective_start_date(+) AND pad.effective_end_date(+) AND sysdate BETWEEN csa.date_from(+) AND csa.date_to(+) AND pam.effective_latest_change ='Y' AND pam.assignment_id = csa.assignment_id(+) AND csa.salary_basis_id = csb.salary_basis_id(+) AND pj.job_id(+) =pam.job_id AND pp.person_id =ppf.person_id AND ppf.mailing_address_id = pad.address_id(+) and pg.grade_id(+)=pam.grade_id and pni.person_id(+)=ppf.person_id and ppn.name_type='GLOBAL' and ppf.person_id = (select person_id from per_person_names_f where name_type = 'GLOBAL' and upper(display_name)=upper(:Emp)) and pj.name is not null and pam.primary_flag='Y' |
2 |
select nm.DISPLAY_NAME, RESP.PERSON_ID, resp.ASSIGNMENT_ID, resp.LEGAL_ENTITY_ID, (select EMAIL_ADDRESS from PER_EMAIL_ADDRESSES where person_id = nm.PERSON_ID and sysdate between DATE_FROM and nvl(DATE_TO, SYSDATE+1)) EMAIL from PER_ASG_RESPONSIBILITIES resp, PER_PERSON_NAMES_F_V nm where nm.PERSON_ID = resp.PERSON_ID and nm.name_type = 'GLOBAL' AND SYSDATE BETWEEN RESP.START_DATE AND NVL(resp.END_DATE, SYSDATE+1) and RESPONSIBILITY_TYPE = 'HR_REP' AND upper(STATUS) ='ACTIVE' and LEGAL_ENTITY_ID is not null |
Now we would also need a Link between the above two queries.
Assuming Query 1 is represented by Data Set G_1 and second via Data Set G_2 the link would be represented as:
G_1. LEGAL_ENTITY_ID = G_2. LEGAL_ENTITY_ID
When the same details are used to create a Data Model in Fusion Applications we get something which looks as below:
In the above screenshot you must have noticed that we have a Parameter defined (this is based on a List of Value) which would need to be fined too as shown below:
Query for LOV:
SELECT distinct display_name FROM per_person_names_f ppn WHERE name_type = 'GLOBAL' order by display_name asc
With this we come to end of step1
Step2: Create a RTF Template
Next we would need to create a RTF Template for this Welcome letter and it would look like
The texts having a grey background (for example ABCD ) is the one which holds dynamic values (XML Tags) and would change depending on the individual selected (while running the report via user input). All other text in the template are static.
You may create the RTF Template in offline mode and in-case you are not aware about how-to create a RTF Template please refer to below link:
Article Link from Apps2Fusion about ‘How-To create a RTF Template’
This brings me to end of step2.
Step3: Generate the Report
Now, we have already created the Data Model (Step1) and the RTF Template (Step2) and you may refer to the article “How-To Create a Custom BIP Report in Fusion Applications”
(Complete article at: http://www.apps2fusion.com/oracle-fusion-online-training/fusion-applications/fusion-payroll/1148-how-to-create-a-custom-bip-report-in-fusion-applications )
You would be able to create a Report as per instructions given in above link and the Final output would look as:
We now have reached the end of Step3.
Associated Files:
We have now reached the end of article and I would leave you all with the hope that you all would try to replicate and create the same in your POD (Fusion Instance) and verify the results.
Have a Nice Day!!!!
Comments
This is the very first time I frequented your website page and to this point?
I surprised with the analysis you made to create this actual post amazing.
Magnificent activity!
how can i subscribe for a blog website? The account aided me a acceptable deal.
I had been tiny bit acquainted of this your broadcast provided bright clear concept
writing like yours nowadays. I seriously appreciate individuals like you!
Take care!!
website; this web site carries remarkable and truly fine information for readers.
post is written by him as nobody else know such detailed about my problem.
You are wonderful! Thanks!
be up tto date all the time.
Take a look at myy site КиноКонг: http://kinokong-zfilm.pw/
all is presented on net?
Also visit my homepage: kinogo: http://kinogo-fiilm.com
so I decided to browse your blog on my iphone during
lunch break. I enjoy the information you provide here and can't wait to take a look when I get home.
I'm shocked at how fast your blog loaded on my phone .. I'm not even using WIFI, just 3G ..
Anyhow, very good site!
It's nice to come acros a blog every once in a while that isn't the same out of
date rehashed material. Excellent read! I've saved yopur site and I'm adding your RSS feeds to my Google
account.
Here is myy web site ... Сериалы онлайн: http://gov-bbv-c.top
The sketch is tasteful, your authored subject matter stylish.
nonetheless, you command get got an edginess over that you wish be delivering the following.
unwell unquestionably come further formerly again since exactly the same nearly
very often inside case you shield this hike.
I don't recognise wwho you are but certainly you're
going tto a famous blokgger for those who are not already.
Cheers!
My website; Сериалы онлайн: http://gidonline777.top
talking about over the internet. You certainly realize how to bring a problerm to light andd makle
it important. More people have tto check this outt
annd understand this side oof your story. I was
surprised that you aren't more popular because you defunitely possess the gift.
My web-site; Мультики онлайн: http://gidonlineee.com
paragraph posted at this website is truly nice.
Thank you a lot and I am taking a look forward to touch you.
Will you please drop me a e-mail?
for me to pay a quick visit this web page, it includes important
Information.
And i'm glad reading your article. But wnt to remark on spme general things, The web site style is great, thee articles is really excellent :
D. Good job, cheers
Heere is my blog post :: Фильмы онлайн: http://gov-bbv-c.top
Just wanted to say I love reading through your blog and look forward to all your posts!
Keep up the excellent work!
What could you suggest about your publish that you made some days
in the past? Any positive?
The text in your content seem to be running off the screen in Internet explorer.
I'm not sure if this is a format issue or something
to do with web browser compatibility but I thought I'd post to let you know.
The design and style look great though! Hope you get the problem solved soon. Many thanks
posts. In any case I will be subscribing to your feed and I am hoping you write once
more very soon!
you make blogging look easy. The overall look of
your web site is great, let alone the content!
yet I never found any interesting article like yours. It's lovely worth sufficient for me.
In my view, if all webmasters and bloggers made excellent content material as
you probably did, the web will likely be much more useful than ever before.
a little comment to support you.
views of all mates concerning this paragraph, while I am also keen of getting experience.
information written in such an ideal approach? I've a mission that I'm just now working on, and I've been at the look out for such info.
that in fact how to do running a blog.
provides feature ϲontents, thanks
Also visit my website ... HD Rezka: http://the-hdrezka.com
јust wanted to give a quick shout out and tell you I genuinely
enjoy reading through your articles. Can you sugvgest any other blogs/websites/ foгums that deal with the
same sսbjects? Thank you!
Also visit my web site - hdrezkaa.com: http://hdrezkaa.com
have got here on this post. I'll be coming back to your
site for more soon.
Continue the good work!
My weƅ page лордфильм: http://tv.lordfilm-lu.com
I needs to spend some time learning more or understanding morе.
Thanks foor fantastic info I was lоoking fоr this info for
my mission.
Takke a look aat my weЬ-site ... HD Rezka: http://the-hdrezka.com
Its very well written; I love whаt youve got to say.
Ᏼut mayƅee you coulɗ a litte more iin the way of content so pеople cоuld connect with it better.
Youve got an awfuⅼ llot of text for only having 1 oг 2
images. Maybe you could spacfe it out ƅetter?
Here iѕ my bloog лордфильм: http://tv.lordfilm-lu.com
taking his clock time on this one.
keep it up.
surfing around your blog posts. After all I will be subscribing to your rss feed and I hope you write
again soon!
we be in contact more about your article on AOL?
I require a specialist in this house to unravel my problem.
Maybe that is you! Having a look ahead to look you.
as well as from our dialogue made here.
I mean, what you say is important and all. Hօwever
think about if you added soome ɡreat graphicѕ or vіdeos to give your posts more,
"pop"! Your content iis excellent but with ρics and videоs, this site could definitely be one of tthe verʏ best in its
niche. Very good blog!
Here is my web site ... қkinogo.biz: http://kkinogo.biz
He always kept talkіng about this. I will forward
this article to him. Pretty sure he will have a good read.
Ƭhanks ffor sharing!
Also visit my blog :: hdrezka.lu: http://hdrezka.lu
RSS feed for comments to this post