Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 10 Oracle Analytics Lounge
- 189 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 65 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
I am trying to build an OTBI report that shows PRS with the status

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 ?
Answers
-
Hi,
Are you talking about purchase requisitions?
Thanks.
0 -
Yes i'm talking about purchase requisitions
0 -
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
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 onlyThis 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.
0