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

Question

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):

JITHU JOSE · Answer

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

Bharath Raghupathi-Oracle · Answer

@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 · Answer

@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