How to create formula to show PR where all lines have processed requisition line flag as yes — Oracle Analytics

Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to create formula to show PR where all lines have processed requisition line flag as yes

Received Response
71
Views
4
Comments

Summary:

We are trying to create an analysis to display those particular requisitions where all lines are processed successfully into PO

Content (required):

Need help to create formula to display those particular PR where all the lines of the PR have processed requisition line flag as yes

Version (include the version you are using, if applicable):

Oracle Fusion Cloud Applications 22D (11.13.22.10.0)

Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Answers

  • Bharath Raghupathi-Oracle
    Bharath Raghupathi-Oracle Rank 4 - Community Specialist

    Hello,

    You can try to build the report something like below



  • JITHU JOSE
    JITHU JOSE Rank 2 - Community Beginner

    @Bharath Raghupathi-Oracle I had tried this, but the issue with this method is that even if one of the lines have processed flag as 'Yes', then it will display such purchase requisition although the remaining lines are not processed into Purchase order. However, the requirement is to only display those requisitions for which all the lines are completely processed into purchase orders

  • Bharath Raghupathi-Oracle
    Bharath Raghupathi-Oracle Rank 4 - Community Specialist

    @JITHU JOSE . Understood. There might few ways to handle this. You can try the below approach.

    1) First create a filter report that contains requisitions with at least one line which is not processed.


    2) Now create a main report, and filter out the Requisitions that are in the above report. You can apply the filter as below.

    This will provide a list of requisitions which are completely processed.


    Thanks,

    Bharath

  • JITHU JOSE
    JITHU JOSE Rank 2 - Community Beginner

    @Bharath Raghupathi-Oracle It worked fine and now am getting the results as expected. Thanks a lot for the help