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?
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
