Oracle Transactional Business Intelligence

Products Banner

Issue with developing analyses for requisition to purchase order cycle time

Received Response
57
Views
2
Comments

Summary:

We are trying to create a custom analyses as per requirement of customer to analyze the purchase requisition to purchase order cycle time but not able to identify which all requisitions have been fully converted into purchase orders

Content (required):

We have created a new analyses and tried to calculate the PR to PO cycle time. However for some particular requisitions which had multiple lines but not all lines were converted into purchase orders, we need to remove such requisitions from the calculation. We couldn't find any attribute to achieve the same. The purchase requisition status shows as "approved" even if some lines in the requisition is still not converted to purchase orders. We need find a way in which we can filter out only those particular requisitions for which all the lines have been fully converted into purchase orders for calculating the PR to PO cycle time. Please guide in achieving the above requirement.

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

  • Jahnavi-Oracle
    Jahnavi-Oracle ✭✭✭✭✭

    Hi @JITHU JOSE , I am not sure on the exact column which can help you identify the requisition lines which were approved. But one way could be if you check all the values of Approved date (LAST_APPROVAL_DATE) at requisition line level .Assuming that LAST_APPROVAL_DATE column value will be null for the lines not yet approved and it will have some date if the requisition line is approved.

  • @Jahnavi-Oracle But the scenario we were facing is that all the lines of the PR are approved but not all are processed by buyer into PO. All the lines and the header of PR are in approved status but some lines are not converted into PO. We need to remove such PRs while calculating the cycle time as the entire PR is not processed into PO.