Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
27
Views
3
Comments

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

  • Eyad Elgarhy
    Eyad Elgarhy Rank 2 - Community Beginner

    Hi @MandeepGupta

    Yes i'm talking about purchase requisitions

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited Dec 12, 2024 4:19PM

    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.