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

 

If you have worked in Oracle EBS Applications I am sure you might have faced some tough times figuring out how to pass a Data Type Input Parameter to a Concurrent Program. One might still be able to cope up with this challenge using some format type-casting in the underlying code which accepts the input from the UI makes some format changes and then passes on the required format to the calling package/procedure. But in a Cloud Deployment Model one does not has the liberty to make any changes in the underlying code. Changes if any has to be done on the UI itself ( be it the ESS UI page or the BIP Report UI Page or the Data Model UI Page).

 

In this article we will try to figure out what should be the ideal format in which a date type input should be passed to call a BI Report.

 

We would be trying out various scenarios which are:

  1. Defining a Date Type Parameter (format MM-DD-YYYY which is the recommended format for passing date type parameter) and not defining any date format type on ESS Job definiton page. At this point I assume you all are aware of how to create an ESS job in Oracle Fusion Application but if thats not the case please do spend some time and read through this post here and hopefully you would be good to proceed.

  2. Defining a Date Type Parameter (format MM-DD-YYYY at BI Data Model UI Page) and defining the same date format type on ESS Job Definition page.

  3. Defining a Date Type Parameter (format YYYY-MM-DD which is the format in which ESS UI page passes the argument value to the BIP Report..yes the ESS Job definition page provides different date type format selection options but they are all for display purpose.. We will get this covered during our demonstration)

  4. Defining a Text Type Parameter (Textbox input) which takes the value as send by the ESS job page

 

So without much ado lets begin.

 

Pre-requisite

 

In order to proceed with this we will define a very simple SQL query which would have a input parameter. The SQL query will fetch the “person number” and the “start date” details from per_all_people_f table.

SQL Query

SELECT  papf.person_number,

                papf.start_date

FROM      per_all_people_f papf

WHERE   :p_effective_date between papf.effective_start_date and papf.effective_end_date

Once done we will pass a value try to get results and save sample data ( this is required before a BIP Report can be created from SQL Data Model)

 

Next we will make a Report from this data model and run the same the sample output will appear as below:

 

 

We would also create an ESS Job and the job definition page would appear as below:

 

 

The section highlighted in yellow explains the following points:

  1. Data Type of Parameter is Date or Time

  2. Only the Date part is to be shown

  3. There is no default date format assigned.

 

Now we will get started with running the ESS Job (created above). We would refer BI Data Model Date Data Type as BIDATE <format> and ESSDATE<format> for ease of understanding purpose

 

Scenario 1: BIDATE <MM-DD-YYYY> and ESSDATE <No Format>

 

In this scenario we will submit the ESS job with current configuration

 

 

And if we check the results we could see that there is no output returned. A further deep dive and the XML data shows that the value of date paramter is completely different from the one passed which was passed from UI.

 

 

Scenario 2: BIDATE <MM-DD-YYYY> and ESSDATE <MM-DD-YYYY>

 

Now before runnng  this scenario we would have to modify the ESS job definition and set the default date format to MM-dd-yyyy as shown below:

 

Now we will run the ESS job

 

 

And when we check the ESS job output we find that there were no records retrieved from the BIP Report and also the parameter value passed to the BI Data Model was totally different from the one specified on the ESS UI

 

Scenario 3: BIDATE <YYYY-MM-DD> and ESSDATE <YYYY-MM-DD>

 

For this scenario we will make two changes. First one is to change the ESS Job parameter default date format to YYYY-MM-DD (as shown below)

 

 

The second change is to change the Date Format of the BI Data Model (as shown below)

 

 

And next we will submit the ESS job

 

 

And on verifying the results we will find that we do get an Output and also the value of input parameter as passed to the BI Data Model is excatly matching with the one passed from ESS UI.

 

 

Scenario 3: BI Parmater (Data Type as Text) and ESS Parameter (No Default Date Format)

 

In this scenario we will make two changes again. The first change is to ensure that there is no default date format for the ESS Job parameter (as shown)

 

 

And the second change is to change the data type of BI Data Model parameter to Text

 

 

And we would next submit the scheduled process

 

 

And we look at the BI Report output we find that it has data.

 


Ashish Harbhajanka

Comments   

0 #1 bloopay 2022-04-09 08:05
https://bestadalafil.com/ - Cialis Ririem Cialis Paris Sans Ordonnance Aoluix Cialis Zjeajt cialis commentaire Buy Lasix Australia Vbhqty https://bestadalafil.com/ - Cialis
Quote
0 #2 donate for ukraine 2022-07-03 01:31
Thanks for the auspicious writeup. It in fact was a leisure account it.
Look advanced to far delivered agreeable from you!
However, how could we be in contact? donate for ukraine: https://www.aid4ue.org/about/
Quote
0 #3 donate for ukraine 2022-07-04 06:02
Greetings! I've been following your web site for a long time now and finally got the
courage to go ahead and give you a shout out from Kingwood Texas!
Just wanted to tell you keep up the fantastic job! donate for ukraine: https://www.aid4ue.org/about/
Quote
0 #4 Dralfup 2022-08-26 22:24
Orlistat From Mexico stromectol sales
Quote
0 #5 wp themes 2022-09-18 13:30
It's really a nice and helpful piece of info.
I am glad that you shared this helpful info with
us. Please keep us up to date like this. Thanks for sharing.


wordpress plugins: http://refund.in/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
wordpress themes: http://www.kendenney.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
Quote
0 #6 wordpress plugins 2022-09-18 22:17
Thanks for one's marvelous posting! I truly enjoyed reading it, you happen to
be a great author. I will make sure to bookmark your blog and will
often come back at some point. I want to encourage
you to definitely continue your great posts, have a nice afternoon!

wordpress plugins: http://www.quickandcleantips.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
wordpress plugins: http://southcarolinaaviationjournal.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
Quote
0 #7 wordpress plugins 2022-09-18 23:28
Now I am ready to do my breakfast, afterward having
my breakfast coming again to read additional news.


wp themes: http://www.qfgolfclub.info/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
wordpress themes: http://onairsolutions.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
Quote
0 #8 wordpress themes 2022-09-18 23:41
Thanks a bunch for sharing this with all people you really realize what you are talking
about! Bookmarked. Please also discuss with my website =).
We could have a hyperlink alternate contract between us

wp plugins: http://rave420.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
wp
themes: http://vintageitaliana.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
Quote
0 #9 wp plugins 2022-09-20 08:28
Asking questions are truly pleasant thing if you are not understanding
something totally, however this piece of writing provides pleasant understanding even.

wordpress plugins: http://etruckworld.com/__media__/js/netsoltrademark.php?d=www.blogexpander.com
wp themes: http://myhrbi.com/__media__/js/netsoltrademark.php?d=www.blogexpander.com
Quote
0 #10 Fran 2022-09-26 11:34
Adoption is the nuclear choice, however we aren’t actually prepared to pursue that
except it’s one thing that BIL wished as well - nephew is his kid, and supporting them as a household is 100% the goal.


Also visit my web-site :: EB2 business plan, Fran: https://.Ob.Ejam.Esa.Le.Ngjianf.Ei2013@%25252525252525252525252525252525252525252525252525252525252525252525252525252525252525252525252525252525252528...%%25252525252525252525252525252525252525252525252525252525252525252525252525252525252525252525252525252525252520.xn%@l.2.%2525252525252525252525252525252525252525252525252525252525252525252525252525252525252525252525252525252525255C%@@/en/node/2265/track,
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