-
In Custom BI Report, we are using Standard FA_UCM_PROVISIONED to read document from this Content ser
In Custom BI Report, we are using Standard FA_UCM_PROVISIONED to read document from this Content server but normal business are not able to run this report they are getting error Fusion BI Publisher: Custom BIP Report Fails with "Could not get data source connection for: FA_UCM_PROVISIONED" error Please do let us know how…
-
Auto Numbering Adjustment in RTF Templates for Offer Letter
Customer have multiple paragraphs in a Offer Letter template which are numbered and some of them have conditions so if the condition is met the paragraph is displayed, if not it is hidden. The challenge we are facing is to re-number paragraphs if there are hidden paragraphs due to conditions not satisfied in-between. e.g…
-
BI Publisher Error - message39 - how do I fix?
Summary BI Publisher Error - message39 - how do I fix? Content I have the most up to date version of OPA installed on my machine. I have also got BI Publisher installed, however the header of the word document looks broken: When I go to load the XML data, I get a particularly unhelpful error message: Has anyone come across…
-
Hyperlink (image or text box) issue
I have a main page that access many different tabs in my dashboard. In this main tab there was a text box with hyperlink in each text to access these tabs. In the last 3 weeks i started to face a issue that a click on this to access a certain tab then the loading bar goes like 90% and stops. I already replaced this text…
-
100% stacked bar chart in BI Publisher
Hello everyone, I need to create a report in BI Publisher instead of OTBI because OTBI is too slow. The report should include a 100% stacked bar chart. Is this possible in BI Publisher, and if so, how can it be done? Thanks in advance.
-
How to edit the sales order Report data model
I want to add new columns in the sales order print dala model. But I found out that the data model is not in sql but in XML format. When I downloaded the file it is in .xmdz file extension, which not opening in readable or editiable mode. Please help me in finding a way to add new columns in the data model of sales order…
-
Error Installing BI Publisher - Set Word2007 flg failed
I am currently trying to install BI Publisher on my laptop. When trying to install I'm getting an error that states "Set Word2007 flg failed". Has anyone experienced this before? Appreciate any guidance you may have!
-
How to ungroup data or unmerge data rows when pivot table is used in interactive template in BIP Rep
Issue description clarification. Rows are getting merged for repeating labels after pivot table has been applied in the Interactive template. We want to unmerge those rows.
-
In Oracle Fusion BI Publisher, where can we see the package body referenced by standard reports?
In BI Publisher, some seeded reports use packages in triggers (like before report). Where can we see or get the PL/SQL package body for it? For example, from the report DM: As of Date Inventory Valuation Report Data Model, located in /shared/Supply Chain Management/Cost Management/Cost Accounting/Data Models It references…
-
Still bip report running, but user signing out error showing when changing interactive to html outp
Summary Still bip report running, but user signing out error showing when changing interactive to html output in obiee bip 12c Content Hi All, I run bip report in interactive mode, in between running time in interactive changed to html output due to white screen in interactive mode(no clue to end users, running report or…
-
Microsoft Publisher retirement coming soon. What's the impact to Oracle BI Publisher?
Summary: Microsoft Publisher retirement coming soon Content (please ensure you mask any confidential information): Microsoft has announced that Publisher will be retired in the coming months. In July 2026 the Microsoft Publisher application will be removed from all Windows computers and you will not be able to open or edit…
-
BIP Report produces output when bursting is not selected, when bursting selected no output
We have an odd issue with a report with bursting that suddenly has stopped working. The report output is produced when the report is scheduled without the bursting option. When the bursting option is selected, there is no output - however, clicking the XML link shows report data. The xml confirms that the 'key' is present…
-
<Line 3, Column 98>: XML-22002: (Fatal Error) Error while processing include XSL file..
When running the report, getting below error, The report cannot be rendered because of an error, please contact the administrator. Error Details: <Line 3, Column 98>: XML-22002: (Fatal Error) Error while processing includes XSL file (xdoxsl:///Custom/PhoenixCommonLetterHeadTemplate/CommonHeadersFooter.xsb). The same report…
-
I need a BIP/OTBI report If the rating in any of the question is 3 & below-BHR intervene & solve.
Proposing to integrate three feedback forms into our HRMS, triggered automatically at the 30-, 60-, and 90-day milestones, to capture each new joiner’s onboarding experience in real time. 5-scale rating with 9 questions along with 1 open-ended question If the rating in any of the question is 3 & below – we can then ask…
-
How to force URL defined in BIP Layout editor to open in a new window
We need to open a standard application redwood page using the URL functionality in the layout editor. Example target page is: <POD Name>/fscmUI/redwood/procurement/workconfirmation?PONumber=PCOR100010 The above URL is generated fine but always opens in the same window as the report which is not acceptable. If the target…
-
Oracle BI Publisher Excel Output Headers Misaligned
I’m using the Word Oracle BI Publisher plugin to generate Excel output with a table. I have: a header row detail rows grouped by device an empty row inserted whenever the device changes The problem I am facing is that the excel file it generated, the header is not showing correctly For example, the layer should be in E but…
-
Is it possible to add border based on groups to a table created by Word's BI Publisher Table Wizard?
I created a rtf file using the BI Publisher Table Wizard in Word. Is there any way to let it add border when a columns value changes? (For example, we want to add a thick border when Order Type changes), so it could look like this in the excel? (there is a thick border line after A, and another thick border line after B )
-
How to enable Report Job History to BI Consumer in Home page of BI Catalog?
Please refer to the BI Catalog Home page of BI Author and BI Consumer. How to enable also Report Job History link in Home page of BI catalog to BI Consumer? What is the relevant privilege?
-
do we have a way to gather all XDO reports which contains only pdf output [please check the below]
Hi Everyone, I am looking for query or table which include the below information: i believe this data stored somewhere in the DB. but i tried too much to get all reports which have PDF output. the main requirements is to make sure that watermark is applied to all PDF reports Best Regards,
-
Dynamic Data field on Interactive Dashboard
I am building a dashboard (in online template builder in Fusion BIP) with various charts and detailed information, all based on one dataset in a BI Publisher Data Model. At the top I have 4 KPI cards that are structured as Data Fields that I dropped into a Layout Grid. The dashboard is interactive in that when you click on…
-
Empty column missing from csv output
Hi All, When the CSV file format report is generated , the output does not show the columns having null values eg: Below columns to be displayed in .csv report col1 -10 col2-20 col3- 30 col4- null col5- null csv output file generated only with the columns having the below values. col1, col2,col3 10,20,30 NOTE : Col4, col5…
-
BI Publisher Desktop add-in "Error while trying to access Report Server Location"
Hi all, I have the BI publisher desktop add-in for Word/Excel etc to build RTF templates, but I can not log on, I get the error msg "Error while trying to access Report Server Location: The remote server returned an error : (400) Bad Request. Report Server Location is: our URL" URL, username/password are all fine ( port is…
-
How to Schedule Job that FTPs Report via REST scheduleJob API
Hi, I've recently stumbled upon the "REST API for Oracle Analytics Publisher in Oracle Analytics Server" documentation for the "scheduleJob" API. I'm able to schedule a job via the API but have not been able to deliver the report via FTP. Note that we can FTP reports when we manually schedule the job. I've searched the web…
-
header etext template for empty data set
-
We need to build a BIP with json as input parameter and xml as the output
We have a requirement wherein: We need to create a BI publisher, data model with type, which accepts JSON as input. Then using this, we need to create the data template. has anyone come across such requirement? Please share your thoughts
-
How to recover / find who has deleted the data model.
Unfortunately, the data model got deleted. So we need to know who has deleted the data model. Could you please share the steps to check the history of data model.
-
PO Approval Notification – Custom Field Not Reflecting After Report Customization
We would like to customize the PO approval notification by adding a new field. We have already customize the Purchase Order Notification Report and added the required field; however, the field is not reflecting in the PO approval notification. Could you please advise if there are any additional setups, configurations, or…
-
Modifying the ESS scheduled process 'Run Grade Step Progression' generated Log Output files in HCM
Hi All, We would like to request a change in the wording used in the log output file that is generated after running the scheduled process “Run Grade Step Progression” in Oracle Fusion HCM. Currently, the log output displays the term “Errored Assignments.” We would like to update this wording to “Unprocessed” in the…
-
Custom Job Role to View Output of Specific ESS Job Submitted By Another User Not Functioning
Hi All, I am facing this issue after creating a custom role to view the output of a specific ESS job submitted by another user. I followed oracle Doc ID 1980772.1. Also…
-
We have a custom report and when trying to run the report there are an error displayed
We customized the Purchase Order Notification report by modifying its data model. After running the report, everything worked correctly. However, when we tried to add a new field to the RTF template and ran the report again, we encountered the following error: Error displayed: “The report cannot be rendered because of an…
