Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud November 2025 Update Unlock faster trends, personalized analytics, and efficient data management with the latest OAC AI and admin enhancements.
Introducing the Oracle Analytics & AI Challenge 2026 Showcase your Analytics & AI skills in this Community Challenge!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

Here is an example: curl -X GET -u user:password -o op.html -H "Content-Type:multipart/form-data" -v -F 'ReportRequest={"attributeFormat":"html"};type=application/json' http://<host>:<port>/xmlpserver/services/rest/v1/reports/Test%252FBalance%20Letter/run FYI this will not work if you are running against an FA SaaS…

in How to connect BI Publisher using REST services Comment by Kevin M-Oracle Dec 10, 2025 3:30PM
You can use an eTEXT template with CSV formatting to generate the headers. Rgds, Kevin

in How can I get the original column header in the CSV output of a BI report without underscore Comment by Kevin M-Oracle Dec 8, 2025 2:39PM
Try running the Enable / Disable Template Builder (included with the desktop). Rgds, Kevin

in Why does the Publisher Word Add-in not appear ? Comment by Kevin M-Oracle Nov 17, 2025 3:08PM
Use {(SYSDATE()$} see: https://docs.oracle.com/middleware/12212/bip/BIPUG/GUID-BC0A8B60-1BB5-4D85-85BB-B199C1A5C418.htm#BIPUG219 Rgds, Kevin

in BIP Report Dynamically Comment by Kevin M-Oracle Nov 13, 2025 2:38PM
I used logon, it provided a sessionID, I used that to execute copy2. See: Examples of "webCatalogService" Webservice Methods in Oracle Analytics (Doc ID 3018011.1). Rgds, Kevin

in Analysis / Dashboard Download with API Comment by Kevin M-Oracle Nov 6, 2025 2:49PM
I have used this end point: /analytics-ws/saw.dll/wsdl/v12?wsdl Then use these methods: v12:logon v12:copyItem2 --archive 12:pasteItem2 --unarchive Rgds, Kevin

in Analysis / Dashboard Download with API Comment by Kevin M-Oracle Nov 6, 2025 1:55PM
See: Using JWT token authentification with BIP web services (Doc ID 2954741.1). That is not an option at this time. Kevin

in Does SOAP Api Supports JWT for getting BIP Reports O/P - xmlpserver/services/v2/ScheduleService?wsdl Comment by Kevin M-Oracle Oct 31, 2025 2:30PM
Try one of these two: ScheduleReportWSSService ExternalReportWSSService Then set basic authentication in SoapUI. Kevin

in Does SOAP Api Supports JWT for getting BIP Reports O/P - xmlpserver/services/v2/ScheduleService?wsdl Comment by Kevin M-Oracle Oct 30, 2025 8:34PM
There are BIP wsdls built for FA SaaS. See: Fusion Application BI Publisher (BIP) : Available Public Webservices in Fusion Applications(Doc ID 2086077.1). Rgds, Kevin

in Does SOAP Api Supports JWT for getting BIP Reports O/P - xmlpserver/services/v2/ScheduleService?wsdl Comment by Kevin M-Oracle Oct 28, 2025 1:59PM
I am glad I could help. You are very welcome. Kevin

in If/Else Conditional Region based on Purchasing Category for PO PDF Output Comment by Kevin M-Oracle Sep 24, 2025 12:54PM
The syntax is not correct. See: Using Conditional Formatting https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-04477E49-F671-4BF1-8353-06A7CDEAD2CC.htm#GUID-755E5D35-0D47-4D9E-B39A-2925D008498F You might also find a case statement is better for your requirements. Rgds, Kevin

in If/Else Conditional Region based on Purchasing Category for PO PDF Output Comment by Kevin M-Oracle Sep 23, 2025 12:33PM
The RTF does not show any markup logic. I would suggest logging an SR so you can get direct assistance. Rgds, Kevin

in BI Publisher Table Grouping Help Comment by Kevin M-Oracle Sep 17, 2025 4:59PM
Put the set variable to 0 before the for-each@section:G_1. Set the variable inside the G_1 loop. In the header only use get. Kevin

in Unable fetch the value of a Variable in RTF Header Section Comment by Kevin M-Oracle Sep 8, 2025 5:28PM
Have your tried adding @section to the for-loop that refreshes the header. Ex: <?for-each:G_1?> is changed to <?for-each@section:G_1?>. Rgds, Kevin

in Unable fetch the value of a Variable in RTF Header Section Comment by Kevin M-Oracle Aug 29, 2025 4:16PM
You are very welcome. Have a great weekend! Kevin

in Is there a REST or SOAP API to post receipts to the ledger in Oracle Cloud Financials? Comment by Kevin M-Oracle Aug 8, 2025 8:37PM
This Community is for Analytics Publisher. For FA questions, please post in the CCC - Cloud Customer Connect: https://community.oracle.com/customerconnect/ Rgds, Kevin

in Is there a REST or SOAP API to post receipts to the ledger in Oracle Cloud Financials? Comment by Kevin M-Oracle Aug 8, 2025 8:01PM
You can test just the new request in a separate Report. Once you get it working, if they use the same deliver-by, you can merge the two queries using UNION. Then run for one report. Rgds, Kevin

in how to Add Bursting logic based on a Employee's Legal entity and Business Unit for an existing one.? Comment by Kevin M-Oracle Aug 6, 2025 3:02PM
OK, can you share a simple sample RTF, no CI or PI? Rgds, Kevin

in BI Publisher Table Grouping Help Comment by Kevin M-Oracle Jul 28, 2025 7:57PM
Can you share a simple sample RTF, no CI or PI? Rgds, Kevin

in BI Publisher Table Grouping Help Comment by Kevin M-Oracle Jul 28, 2025 6:59PM
In the layout use for-each-group instead of for-each. Rgds, Kevin

in BI Publisher Table Grouping Help Comment by Kevin M-Oracle Jul 28, 2025 4:48PM

More Comments

Welcome to the Oracle Analytics Community

Kevin M-Oracle Rank 6 - Analytics & AI Lead

Comments