Reporting and Analytics for SCM

Get Involved. Join the Conversation.

Topic

    Ashish Gupta
    BI Publisher: Parameters not getting passed from custom ESS...
    Topic posted November 6, 2019 by Ashish GuptaRed Ribbon: 250+ Points, tagged BI Publisher, BI Publisher Reports 
    32 Views, 2 Comments
    Title:
    BI Publisher: Parameters not getting passed from custom ESS job to BIP report
    Summary:
    BI Publisher: Parameters not getting passed from custom ESS job to BIP report
    Content:

    Hi

     

    We have a requirement to create a custom BIP report with From and To date parameters. In addition to this, they want ESS job to be created for this BIP report to be run. We have created ESS job with 2 parameters but when we are running the job, parameters are not getting passed to BIP report. In xml and output, it shows blank for from and to date parameter.

     

    We also tried to deselect "Enable submission from Scheduled Processes" flag but in this case it passes only one parameter i.e. to date.

    Please advise how can we achieve this.

     

    Regards

    Ashish

    Version:
    19c

    Comment

     

    • Rajasekhar Bandaru
      Hi Ashish, Could you please schedule the BIP report directly from bip and check whether parameters are getting passed properly are not. If it's work fine in BIP then same will work from ESS. Thanks and Regards Rajasekhar
    • Tejaswi p

      Hi Gurus,

      I am new to Oracle cloud.We are not able to get proper link between the tables mentioned below.

      Could you please help me in getting the joins between EGP_SYSTEM_ITEMS_B,INV_ITEM_LOCATIONS,INV_MATERIAL_TXNS,INV_SERIAL_NUMBERS.

      Also i need fm_serial_number ,i am confused from which column i need to get this field joining above table.

      Appreciate your help ASAP.

       

      Thanks & Regards,

      Tejaswi