I am trying to build an OTBI report that shows invoices that are pending approval along with the name of the current approver.
Perhaps you could find some help in this:
Need report that shows all approval assignees who have NOT approved invoice — Cloud Customer Connect (oracle.com)
Thanks for the information.
But I'm still having troubles when a reassign happens. I need to show last Approver (not all approvers assign) or MAX per invoice ID.
I used :( MAX("Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Approval Action Date" By "Payables Invoices - Transactions Real Time"."- General Information"."Invoice ID") on the filter but still listing each approver on the invoice.
The Filters
I am trying to build the same report (current approver only). Has anyone successfully done this? I tried all of the suggested filters and MAX on action date by invoice id, but still returns multiple approvals.
@BillW You might find the right assistance in this forum, please log a thread there.ERP Analytics Regards, Gaurav
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?
