Oracle Transactional Business Intelligence
Issue with developing analyses for requisition to purchase order cycle time
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
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 (184.108.40.206.0)
Code Snippet (add any code snippets that support your topic, if applicable):