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
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.
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.
Hi Sara - did this ever get resolved? I'm in the same boat, looking for an otbi report showing the current assigned approver for purchase requisitions.
Any insight is appreciated,
Thanks,
Kevin
Hi Wilson,
Try creating a report from : Procurement - Requisitions Real Time subject Area
https://docs.oracle.com/en/cloud/saas/procurement/25b/faopb/Procurement-Requisitions-Real-Time-SA-403.html
Requisition Number Requisition Status Current Approver Name Approval Status
Filter by Pending Approvals to show only requisitions awaiting action.
https://docs.oracle.com/en/cloud/saas/procurement/25b/faopb/Procurement-Requisitions-Real-Time-SA-403.html/
Thanks @Riyaz Ali-Oracle ,
I dont see that as an available subject area. I have the Procurement Manager and Buyer roles.
Any ideas? Should I check my data access and re-run LDAP?
Hey Kevin,
Please check "Procurement - Requisitions Real Time"
Procurement - Requisitions Real Time
Hi Riyaz,
We dont find the Current Approver Name in the subject area - Procurement - Requisitions Real Time.
Any solution on this requirement ?
Agreed with @Govardhani T C , this is not available in this subject area
-Kevin
The Procurement - Requisitions Real Time subject area does not seem to expose the Current Approver Name directly.
The Transaction Console in Oracle Fusion allows you to view the current approver for requisitions. You can manually check the approval status there, but it may not be available for reporting.
2. BI Publisher Query for Approval Details
You can retrieve the current approver using a BI Publisher report with a SQL query. A discussion on pulling non-approved requisitions and their current approver using SQL is available below.
SQL Query for Current Assigned Approver of Requisition — Cloud Customer Connect
Hello Riyaz,
I have a similar need for obtaining the current approver from Payables invoices in workflow approval. Can you possibly provide the payables SQL as you did for the Requisition approver?
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…
We have a Talent Community Pool configured with Organization and Job Family criteria. Some candidates were added to the pool, but we are unable to determine which specific criterion they matched. Is there a report, analysis subject area, audit history, or backend table that shows the attribute values that resulted in a…
Hi, We are looking for PVOs for below tables in BICC Can you guide us on the approach to extract data for these? PON_AGREEMENT_LINES_ALL PON_AGREEMENTS_ALL PON_APPROVAL_HISTORY PON_CONTRACT_PARTIES PON_PRICING_TERMS PON_TERMS_AND_CLAUSES Thanks, Nitin
Hi All, We are using Oracle Fusion Cloud Procurement and would like to secure the Purchase Order (PO) PDF that is generated from Oracle Fusion. Our requirement is to have the generated PO PDF password-protected, so that the recipient must enter a password before the PDF can be opened. Can someone please advise? We are…
Does Fusion release supports propagating an HTTP XML Feed authentication exception into the BIP-based ESS job’s completion text.
