Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Balakrishna Chaturvedula
    Is there a way we can write logic to refer a field on the...
    Topic posted May 23, 2018 by Balakrishna ChaturvedulaBronze Trophy: 5,000+ Points, last edited January 30, 2019, tagged Financials 
    1524 Views, 24 Comments
    Title:
    Is there a way we can write logic to refer a field on the page
    Summary:
    Is there a way we can write logic to refer a field on the page
    Content:

    Hi,

    Is there a way I can refer to the field on the page and retrieve value. Example, when AP invoice was saved, I would like to refer to identifying PO field on header. I intend to refer to this value in the one of the queries associated with value sets. 

    Thanks, Bala.

    Comment

     

    • Alexey Shtrakhov

      Hmm, can you please add a little bit more information on your requirements. What do you mean you "would like to refer to identifying PO field on header"?
      You can use some seeded binding variables on the related page flow to do some personalizations.

       

    • Balakrishna Chaturvedula

      Hi,

      When user creates an invoice, I would like to default a Y or N on invoice DFF (read only for users) depending on one of the PO header DFF. For this reason, I would like to refer to field "Identifying PO" on the header in the valueset query. In Oracle EBS, we can always refer to a form field in valueset. Can we do the same in Cloud?

      Thanks, Bala. 

    • Alexey Shtrakhov

      Please check these documents:
      https://blogs.oracle.com/fadevrel/examples-of-expression-language-from-the-customer-connect-event
      https://blogs.oracle.com/fadevrel/using-expressions-to-add-logic-to-page-composer
       

      Please check also this attached doc

       

       

    • Chris Pinto

      Hi,

      In addition to the information Alexey has provided, there is an option to default values using Groovy Expression when creating a DFF. You can try it out. I have attached a screenshot for your reference. (Setup and maintenance -> Manage Payables Descriptive Flexfields)

       

    • Glen Ryen

      Bala,

      If you're looking for the ability to reference like you could in EBS custom.pll or Forms Personalizations (:BLOCK_NAME.FIELD_NAME), then I think the answer's no (somewhat).  The Financials pillar does not give you access to Application Composer, which is what I think you'd like here.  Alexey mentioned EL and that can set field defaults and reference other fields on a page, but I'm not sure if you can default a **DFF segment** with it.  You can't validate user choices, though perhaps it lets you set a default and disable update.  See https://blogs.oracle.com/fadevrel/what-options-page-composer-supports-for-fusion-applications-and-what-it-doesnt for a good summary on Page Composer capabilities.

      What Chris mentioned looks like a nice new R12 feature, found some documentation on it at https://blogs.oracle.com/fadevrel/release-12%3a-descriptive-flexfields-get-groovy.  But that page also says "It should be noted that the code should be a simple expression (not attempts at CRUD operations) and that direct access to other attributes and data is not possible."  So I'm not sure it would help you in this case.

      As a workaround, you can run a BI Publisher report after the fact and email out exceptions.  Some custom SQL could detect when the DFF doesn't match the PO, if you can catch the data before it goes further downstream.  I've had customers that have had to take that approach before, when facing a DFF limitation like this.

      Hope that helps,

      Glen

    • Alexey Shtrakhov

      Bala,

      for some cases we came to a conclusion to incorporate on an invoice edit page so called validation section. This section includes various validations based on Business Logic (business controls). We bring to a user one step verification that all the needed information is provided on the invoice and there is no any logical errors or other data / process related issues.

      This is a very flexible way to provide controlled common view before user submits invoice for Approvals.

      Attaching some screenshot where you can see that this section is at the bottom of the invoice and it is an injected BIP report where we have custom logic. It is a dynamic section which receives as dynamic binding variable invoice_id and vendor_id. Here we are cross checking supplier masterdata information and invoice information. We bring with RED/YELLOW/GREEN flags if user needs to correct something or ready to go or has to additionally possibly verify something.

      As it is a custom BIP report we can bring closely to user needed Business logic.

      => I understand that this is not exactly what we could do in EBS but we saw this as a best way till now how to overpass the issue you have addressed with DFF fields and other invoice data related validations.

      With respect
      Alexey

      • afton liu

        Alexey,

        I want to know how custom BIP report dynamically binds variable invoice_id and vendor_id.

        Can you share the detailed steps?

         

         

        Thanks and Best Regard

        • Alexey Shtrakhov

          Hi Afton,

          You can follow this document: Adding and embedding BI content into Fusion Cloud Applications
          https://cloudcustomerconnect.oracle.com/posts/023dbae005
          It is actually very similar solution. The only difference is where you embed your BIP report (on which page/task flow). Otherwise the binding process is quite the same.

          Here, on this invoice edit page I had small difficulties to embed this report and did some tricks to put this report in the exact place where I wanted it (at the bottom of the invoice edit page). Let me know if you need exactly the same solution, so I can create document for that.

          With respect
          Alexey

          • afton liu

            hi,Alexey

            I can embed the bip report successfully according to the related documents provided by you. Thank you very much.
            Previously, I tried to implement OTBI embedding on the fusion ERP page by following the CX product documentation in the attachment.
            Unfortunately, although trying hard to try too much, there is still no success.
            And found that dev gives the relevant ER. (Enh 27657254 - OTBI EMBEDDED IN PURCHASE REQUISITION IS NOT FILTERING DATA)
            It would be nice if the future fusion erp could also be embedded in OTBI analysis like CX.

            Very much looking forward to the release of this ER function as soon as possible

             

             

    • Alexey Shtrakhov

      ok, guys, could do it.

      Here is the final link:
      "https://[BI Server]/payables/BIProxy?cid=BIPresentationServer&RedirectURL=saw.dll%3fPortalPages&PortalPath=%2Fshared%2FCustom%2F_portal%2FInvoice%20Additional%20Data&Page=page%201&Action=Navigate&col1=%22-%20General%20Information%22.%22Invoice%20Number%22&val1=%22#{bindings.InvoiceNum.inputValue}%22&psa1=%22Payables%20Invoices%20-%20Transactions%20Real%20Time%22"

      I followed actually provided document instructions.
      Important part here was to change the beginning of the generated URL to get the report without ANY BI wrapper elements. So this is a really cool way to incorporate Custom BI with the feeling of native app.

      Please find document explaining how I did it for AP Manage invoices screen: InjectingDynamicOTBIReport.docx

      • Alexey Shtrakhov

        report i did is just a POC so it doesnt include so much additional info... but you can do again whatever analysis using available binding variables to give your user needed information.

        attaching also analysis, prompt and dashboard artifacts. You can install them to the places mentioned in the document to make POC on your own.

      • Alexey Shtrakhov

        What exactly you dont get? Or what errors?

        • afton liu

          sorry,..attachment uploaded error. now  i reupload

           

           

          Hi,Alexey
          I'm not the same as yours. You can't succeed by following my steps. Attachments are my steps and confusion

        • afton liu

          Hi,Alexey

           

          the steps described in the attachment(DynamicOTBIReport sandbox.docx) refer to the sales cloud document to implement BI embedding but cannot succeed

      • Alexey Shtrakhov

        Hi Afton,

        Ok, now I got it. Thanks for provided info.
        I provided as a parameter for this analysis as: #{bindings.InvoiceNum.inputValue}
        But it doesnt work. It doesnt retrieve it dynamically. If I manually provide invoice number in the parameter it works ok.

        Strange because whenever I use the Expression Builder and Press TEST i see the correct value there in the output. See image attached.

        I will check more and come back.

        Till then, you can use my previous post as a workaround for this issue. Then you would be able to add dynamic OTBI report.

         

        With respect
        Alexey

      • Alexey Shtrakhov

        Hi Afton,

        yes I was trying to check around on this issue and looks like we need to create an SR.

        I got following answer: "looks like the parent page is not properly calculating or making the value available at runtime. It looks like might need the owner of the container page (i.e. product developer) to investigate why " => SR to be open..

        I will create for AP page and in the meanwhile if you can try with some other product and you can try to open SR as well if not working.
        I will try as well for one of the GL pages just to verify if it is a product related or generic issue.

        => ALSO in the meanwhile you can use my workaround to inject the OTBI report using the dynamic HTML link (see my post from posted June 27, 2018)

      • Alexey Shtrakhov

        There is an ER: ABILITY TO PASS PARAMETER VALUES IN CUSTOM ANALYSIS VIA PAGE CUSTOMIZATION(Bug ID 28331495)

        Will raise an Idea fr you to vote to get it as fast as possible.

        Alexey

      • Alexey Shtrakhov