Oracle Transactional Business Intelligence

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

Access procurement approval workflows in OTBI

Incorrect Answer
150
Views
2
Comments

Hello,

Is it possible to access the requisition/order approval workflows to add into an OTBI analysis, the people that a requisition/order is pending to be approved?

Thanks

Tagged:

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited July 2023

    Hi,

    Have a look at subject areas

    "Human Capital Management - Approval Notification Archive Real Time"

    Real time information on completed approvals of various tasks transactions that are part of Fusion HCM. The tasks transactions comprise of various categories like compensation, payroll, core hr, absence/accrual, talent management and so on.

    "Human Capital Management - Transaction Administration Real Time"

    Provides real time information on on all BPM the transactions in the system related to HCM. Transactions that are stuck, pending, in auto recovery, error, so on are available for reporting. The transactions,details like submitted user, process category, process name, transaction status can be reported. If any issues exist during the transaction, then the user that is assigned the issue, the issue status and other details are available for reporting. Count of issues and Count of transactions are seeded metrics in the subject area.

    See

    Oracle Fusion Cloud HCM

    Subject Areas for Transactional Business Intelligence in HCM

    F81649-01 23C


    But I think the former includes only completed archived historic transactions not pending and the latter includes pending but does not say who are the approver(s) it may be pending with.

  • Sara González-Gaggero
    Sara González-Gaggero Rank 2 - Community Beginner

    Hi @Nathan CCC ,

    Thank you for your answer.

    Indeed, the "Human Capital Management - Transaction Administration Real Time" subject area, can provide you the tasks that are pending to be approved, but it doesn't provide the user to which they have been assigned, not the detail of the requisition/purchase order number (just the Object ID).

    Therefore, I can't use this information.

    Hope they implement it soon as it can provide a full view of all the procurement process and help keep track of all the transactions.

    Thanks again.