I am trying to build an OTBI report that shows PRS with the status

Eyad Elgarhy

I am trying to build an OTBI report that shows PRS with the status, if it's pending approval i need the name of the current assignee

Is it applicable by OTBI ?

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24027/i-am-trying-to-build-an-otbi-report-that-shows-prs-with-the-status

Hi,

Are you talking about purchase requisitions?

Thanks.

Eyad Elgarhy

Hi @MandeepGupta

Yes i'm talking about purchase requisitions

Nathan CCC

Hi, Here you go. For your analysis in OTBI or report in OTBI build a query using this subject area. It includes the status of both the header and the line on a purchase requisition. It also has the distributions.

Procurement - Requisitions Real Time

https://docs.oracle.com/en/cloud/saas/procurement/24d/faopb/Procurement--Requisitions-Real-Time-SA-7.html

for example

select all 0 s_0

, "Requisition Header Detail"."Requisition Number" as purchase_requisition_header_number

, "Requisition Header Detail"."Requisition Header Id" as purchase_requisition_header_id

, "Status"."Document Status Meaning" as purchase_requisition_header_status

, "- Requisition Line Detail"."Line Number" as purchase_requisition_line_number

, "- Requisition Line Detail"."Requisition Line Id" as purchase_requisition_line_id

, "- Requisition Line Status"."Line Status Meaning" as purchase_requisition_line_status_name

, "Requisition Header Detail"."Lifecycle Status" as purchase_requisition_lifecycle_status_name

from "Procurement - Requisitions Real Time"

fetch first 7 rows only

This gives you status. However to get the one or more current assignees in the approval workflow you will need to get this from various other sources depending on whether the approval data has been archived or purged yet or no. You can search for lots of content online for how people do this to get approvals data. For example, from fa_fusion_soainfra.wftask, fnd_bpm_task_b etc.