How to Access OTBI report using Groovy within Oracle Fusion
Can you please elaborate your requirement?
Thanks.
HI @User_02ANP ,
If you are talking about the BIP Reports , yes it is possible to invoke them from Groovy using SOAP API's. SOAP API's helps to run the report and gives the result and that can can be consumed as per the requirements.
Thanks,
Sreekanth M
We have a OTBI analysis report and i want to access it in groovy and fetch/read the analysis rows from groovy
In which module are you trying to use the Report ? Is it for CRM ? If it is a BIP Report yes you will be able to access it using SOAP API's.
its CRM and its not BIP XDO report. it is just otbi analyses report
I don't see a direct way of doing it. You can definitely call BIP reports from groovy with the approach given in below note:
How To Call BIP Report Webservice From App Composer using Groovy Script (Doc ID 2150332.1)
Can you try similar approach for OTBI with webservices mentioned in below notes:
How to include date filter on OTBI report using webservice (Doc ID 2815071.1)
How To Run SAWRowsetSchemaAndData WebService To Retrieve Data From An OTBI Analysis (Doc ID 2814254.1)
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
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?
