Oracle Fusion #35: ESS Job with Parameters using Lookups

Поділитися
Вставка
  • Опубліковано 15 вер 2024

КОМЕНТАРІ • 40

  • @kalaiyarasisampath5210
    @kalaiyarasisampath5210 2 роки тому +1

    Thank you Naresh, this ESS job videos are very clear , very useful to me

  • @PraveenKumar-cr3mi
    @PraveenKumar-cr3mi 3 роки тому +1

    Thanks for the video

  • @anandch6539
    @anandch6539 2 роки тому +1

    Thanks Naresh

  • @ayyagarunamasthe3770
    @ayyagarunamasthe3770 Рік тому +1

    Thanks sir

  • @Kazimirka
    @Kazimirka 2 роки тому +1

    Thanks, Naresh - your channel is great. Did you also make an example of selecting multiple values as a parameter ? Like menu in Data Model . Is that feasible ?

    • @TechTalkwithNaresh
      @TechTalkwithNaresh  2 роки тому +1

      Hi Kazimirka Please share you requirement on nareshtech21@gmail.com in detail.

    • @Kazimirka
      @Kazimirka 2 роки тому +1

      @@TechTalkwithNaresh ok, I will do it - thanks but bottom line is how you can pass to ESS Jobs multiple values (as an array) for specific parameter

    • @TechTalkwithNaresh
      @TechTalkwithNaresh  2 роки тому +1

      @Kazimirka You can use value set or lookup

    • @Kazimirka
      @Kazimirka 2 роки тому

      @@TechTalkwithNaresh can you use value set based on view defined in ERP cloud ? custom value set. Maybe I will send you specific case by email tomorrow from my work

    • @Kazimirka
      @Kazimirka 2 роки тому +1

      @@TechTalkwithNaresh thanks for rapid response, you are great, appreciate it

  • @user-id5ts1mm8z
    @user-id5ts1mm8z Рік тому +1

    @TechTalkwithNaresh If I have multiple steps that need a date value can I merge them so that user doesnt have to enter multiple times when they run the job set?

    • @TechTalkwithNaresh
      @TechTalkwithNaresh  Рік тому

      I@User If you have to use only one date u can create one paramater for that and u can use.

  • @satishpatil4073
    @satishpatil4073 3 роки тому +1

    Hi sir, can you please make a video on E-text templates??

  • @rakeshmr3329
    @rakeshmr3329 2 роки тому +1

    Can you please tell how to transfer output file after running ESS Job from Content Server to 3rd party FTP Server

  • @technicalconsultantpoint
    @technicalconsultantpoint 7 місяців тому +1

    How can we schedule extract.. pause and see extract that are schedule by others

  • @p51mustang31
    @p51mustang31 Рік тому +1

    I have defined the Common Lookup LOV, and am using it in my ESS Job as a parameter, I also have some other ESS parameters that are based on User Defined (SQL) List of Values Sources. The problem is when I run the ESS Job, I am getting an error in BI Publisher of "Invalid Parameters Requested". The Data Model works fine when running it stand-alone, but when triggered from the ESS Job is when I am facing this error. I am also not clear on how the mapping occurs between the ESS Parameter(s) and the BIP Data Model Parameter(s). Is it possible we can connect on this issue?

    • @TechTalkwithNaresh
      @TechTalkwithNaresh  Рік тому

      @P51 Hard code all the parameters and run the report then after add the parameter one by one and test for each one. When u get any error then check that parameter issue.

    • @p51mustang31
      @p51mustang31 Рік тому +1

      @@TechTalkwithNaresh I got it working by isolating it one parameter at a time to find the issue, thanks! Another question - Is it possible in the ESS job to have a Dependent query-based parameter, that will have it's values filtered based on another parameter that already have some other value selected? Similar to a Cascading dropdown list, dependent on what is selected on another parameter...

    • @TechTalkwithNaresh
      @TechTalkwithNaresh  Рік тому

      @P51 Yes it is possible. It will work as depended Value set. I have one video in my fusion playlist, go through it.

    • @p51mustang31
      @p51mustang31 Рік тому +1

      @Tech Talk's with Naresh but the Value Set is just a static (hardcoded) list of values correct? I need a LOV that is dynamic, like the User Defined (SQL) LOV definition I can create in the ESS job. Is this possible?

    • @TechTalkwithNaresh
      @TechTalkwithNaresh  Рік тому +1

      @P51 This feature is Possible in R12, I have to dig down for Fusion. Will cross check once and write back to you once I done.

  • @mtoracle
    @mtoracle 2 роки тому +1

    Thanks Naresh

    • @TechTalkwithNaresh
      @TechTalkwithNaresh  2 роки тому

      👍

    • @ArunKumar-ov5fe
      @ArunKumar-ov5fe 2 роки тому

      Hi Naresh, Thanks for making the excellent video this is very useful..
      When you are going to start new batch?
      I am a SCM functional consultant. I would like to become techno functional consultant.. how much this training would be helpful for me.. which are topics are going to cover in course. Please send me course content..
      Please send me your mobile number