Oracle Fusion #36: ESS Job with Parameters using Value Sets

[@irgrk]

Hi Naresh, This is very useful for beginners and new to BI in Oracle Cloud. Can you please add one video for how to use dependent parameters in ESS job registration?

[@TechTalkwithNaresh]

@Ravindra I had a video on mentioned topic in my fusion playlist. Please go through it.

[@rangaswamy7538]

Hi Naresh, your videos are nice.. Can u pls upload video how will schedule a ESS job to run automatically on daily basis

[@TechTalkwithNaresh]

@Ranga Swamy I will try to upload it asap.

[@rangaswamy7538]

@@TechTalkwithNaresh Tq Bro😊

[@keshavkashyap2589]

Please create Dependent Lovs in ESS Jobs, Like Business Unit--> Tender Number--> Tender Title. So what I am expecting is when you are going to run your ess job, first it will ask business unit, once business unit is selected then Tender number lov filtered out then Tender Title. Hope you get what is the requirement.

[@TechTalkwithNaresh]

@ Kashav I had understand your requirement I already uploaded relevent video in my playlist please go through the fusion playlist.

[@keshavkashyap2589]

@@TechTalkwithNaresh Hi Naresh, I have checked your playlist, but I didn't find the exact requirement. Can you please check again because it seams it's not possible to do so and limitations are there.

[@ClaudiaZavala-xh2il]

@@keshavkashyap2589 Hi Keshav, i was wondering if you found the solution for your own question. I have same question on how to filter based on a previous selection in the ESS process perse and not in the BI report design. I created LOV but i really dont know how to send parameters from one selection to the other. A partner told me we can use public VO, i was wondering if you found something related. Thanks!

[@deovrat1000]

Hi Naresh, Thanks for this video. Can you make a video which will include "Manage Dependencies" ? Like View criterion, bind variable, and mapped parameter?

[@TechTalkwithNaresh]

@Deovrat I will try to upload on mention topic asap.

[@deovrat1000]

@@TechTalkwithNaresh Thanks !

[@nithyagnanasoundarammohand7352]

Even I need to know

[@nithyagnanasoundarammohand7352]

Can u pls put

[@yugalbhatt234]

Very Informative video sir ... Thanks Sir

[@TechTalkwithNaresh]

@Yugal Thanks

[@satheeshkumarsuthari892]

I did not get lov(which u created) link to ess job parmeter, even name is also not matching. How come parameter depends on the created lov by you? pls clarify... I mean you have created an lov using manage value sets and you did not use that valueset while creating lov in ess job..so how come it is dependent?

[@TechTalkwithNaresh]

@Satheesh Can you tell about which part of video you are talkin, give the specific time details so ee can check quickly.

[@keshav60100]

I also have the same question, In the video somewhere around 7:00 to 7:15 while creating the LOV, how did you mapped the Value set that we created one step back.

[@anilkumarraosutraye3499]

Hello Naresh, I have a quick question from my ESS job, I have created a plsql job with the right procedure in ESS, We have described the procedure as to take parameters when we are submitting the ESS job, either C or P -- C is for one of the reports and P is for another report, Whenever we want partial report will pass as 'P' and submit and vice versa, but we are not sure how to pass the parameter in plsql job from ESS, we tried SYS_EXT.cmdLine or few system properties but no luck, Could you please help me with the correct result. thank you in advance.

[@TechTalkwithNaresh]

@Anil I had a video on creating the parameter in ESS job in my fusion playlist. Go through it. If any dought tell me.

[@keshavkashyap2589]

Instead of hard coding Segment1 value, can you get these values from any query with parameter ? This is my issue.

[@TechTalkwithNaresh]

Yes you can, try table value set.

[@keshavkashyap2589]

@@TechTalkwithNaresh Not possible with 2 tables. And with :Parameters.

[@TechTalkwithNaresh]

Yes not possible with 2 Paramater. 1 SR has been already raised for this as per etrm.

[@keshavkashyap2589]

@@TechTalkwithNaresh Thank you bro for quick response. Just share the SR number, if handy.

[@dasarinarayana7286]

for ess job parameter is their any sequential ?

[@TechTalkwithNaresh]

@Dasari In which sequence you had defined the paramaters in same sequence you have to pass while running.

[@abhishek-bb6vg]

Hi Naresh, we have a requirement to customize the parameters of the seeded "cash to general ledger report" which has three parameters like gl account , from period and to period. we wanted to hide "from period" parameter and internally parameter value should defaulted as the start date of the initial period of the calendar year. lets say the GL configured in the month of Jan-2020 , so from period value should be Jan 1st , 2020. Right now we can't see this from period parameter value being directly passed from the ESS job, internally the data model global level function manipulating this from period parameter value. so how to customize this

[@TechTalkwithNaresh]

@Abhi you can customize it by creating the seprate lookup for the parameter. So you can get the value as default start date.

[@abhishek-bb6vg]

@@TechTalkwithNaresh This from date and to date are being manipulated by default seeded package. but wanted to understand how to create a lookup based on the SQL query and attach to the ESS parameter

[@TechTalkwithNaresh]

@Abhi I had a video on lookup in my fusion playlist go through it.

[@sivanerusu4416]

I am getting error while creating Standard ESS JOB --Dummy file found

[@TechTalkwithNaresh]

@Siva I was also not sure about this error, but try to give some different name while creating the ESS job.

[@sivanerusu4416]

We can duplicate standard one right with parameters

[@TechTalkwithNaresh]

@Siva yes we can but we have to change the names at few places.

[@sivanerusu4416]

I did same thing when I am adding the custom template getting error

[@gupta8245]

Could you please add videos related to OIC...

[@TechTalkwithNaresh]

@Gupta I will try to upload asap.

[@gupta8245]

@@TechTalkwithNaresh 🙏 thanks sir

[@PraveenKumar-cr3mi]

can u share the query that you are using?

[@TechTalkwithNaresh]

@Praveen You can find it under starting video in description section.

[@PraveenKumar-cr3mi]

@@TechTalkwithNaresh Thank you

[@ramakrishnamurthy5216]

How to restrict parameter values based on logged in user data security?

[@TechTalkwithNaresh]

@Ramakrishna You can apply user level data security.

[@PraveenKumar-cr3mi]

i am have a error while creating list of value source (The value of the attribute DatasourceDefName isn't valid.)

[@TechTalkwithNaresh]

@Praveen Please check all the valid name for all the entities and give accordingly. Go through the video again It will definitely resolve your issue.

[@VishnuKumar-lz5qb]

VO FULL FORM ?

[@TechTalkwithNaresh]

@Vishnu its VO is Viee Object. This is the OAF or ADF object.

[@VishnuKumar-lz5qb]

@@TechTalkwithNaresh Tq