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.
Is there a log that can be checked on our side that might help with the issue. I've submitted an SR, however it is currently being bounced around between different areas. Could not establish connection. oracle.xdo.delivery.ssh2.SSHMessageException: Error in decrypting message Current thought is that this is an issue with…
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
We are encountering issues with our OTBI dashboards where there is no option to export to Excel. This seems to be a new issue after the latest update to 26B. I made a change to the report layout (moved one analysis into its own section), and now I cannot export the page. As you can see in my attached photos, the export…
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
