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 ?
Hi,
Are you talking about purchase requisitions?
Thanks.
Hi @MandeepGupta
Yes i'm talking about purchase requisitions
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.
Agenda Presentation: EPM Integrator connectors and Salesforce CRM Connector. Join us to learn more about the EPM Integrator connectors and Salesforce CRM Connector in Oracle FDI. We will explore the enhanced capabilities of the EPM integrator connectors and how you can load data from EPM modules to FDI to deliver a…
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?
Where can I find the calculated time breakdowns in HWM_TM_REC? I am using Oracle BI publisher SQL.
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…
