To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
BI Publisher Learning Center
Discussion List
-
Need Approval Group Details in GeneralLedgerHi all, I am working on a GL Manual workflow BIP report where I need to fetch ApprovalGroup Details like ApprovalGroupName, Approval Sequence, Approval Comments in GL. P… -
How to retrieve user information who is running BI reportI need to display user name of who is running a BI report. I am using select :xdo_user_name from dual. But this is returning email id. But from security console I can se… -
ESS Job Status Shows "Error" Despite Successful Report Output in Oracle FusionHi Team, We are facing an issue in Oracle Fusion Applications where a report or ESS job scheduled via "Schedule New Process" generates the expected output file, but the …
-
Deprecation of download logs in help menu for Oracle BICC (BI Cloud Connector) in release 25CSummary: Download logs in BI Cloud Connector (BICC) is not longer available in release 25C. Content (please ensure you mask any confidential information): In release 25C…
-
Aa BIP has a data fetching limit of 2GB .What will be alternative solutions to get huge data.As we are aware, Business Intelligence Publisher (BIP) has a data fetching limit of 2GB, which can pose challenges when working with large datasets. This limitation may …
-
BIP report scheduled with ET time zone and the report got triggered in UTC timescheduled the BIP report in ET time zone at 1:00 AM but the report got triggered at 9:00 AM ET. ca anyone help us to understand what causes this?
-
BIP report scheduled with ET time zone and the report got triggered in UTC timescheduled the BIP report in ET time zone at 1:00 AM but the report got triggered at 9:00 AM ET. ca anyone help us to understand what causes this?
-
To print a table at the bottom of the page, irrespective of the space taken up by the previous tableUsing the Oracle BI Publisher add on for Microsoft word we need to print a table at the bottom of the page, irrespective of the space taken up by the rest of the data/te…
-
How to convert User Defined Table text to date in BI PublisherHello I'm trying to work with a User-Defined Table (UDT) and am running into reporting issues working with the data in BI Publisher and am looking for help. The business…
-
How can we implement SQL-based data security in a BI Publisher Data Model to restrict PII columns?We have a custom BI report which contain 5 columns of data and out of these 3 columns are related to PII(Personal Identifiable Information). These 3 fields are secured o…
-
OTBI Prompt returning wrong DataWe are creating a report in OTBI using subject area "Maintenance Management-Work order performance Real Time". Select Work Order Priority in Data as well as Prompt. In D…
-
Can we add hyperlink for ESS jobs in fusionHello Everyone, We have a requirement to call the seeded ESS job: Print Packing Slip Report from Manage Work Orders UI. What is the syntax to add through Page Composer a… -
Need to Fetch Last Updated Records in ess_request_history tableI’m building a report using the ess_request_history table, where I need to fetch incremental records based on a timestamp filter. However, I couldn’t find a 'last update…
-
Schedule BI Publisher report to run every first Monday based on Fiscal Month EndWe need to schedule a BI Publisher report which should be ran on every first Monday when the Fiscal Month ends. For exm : January 2025 Fiscal year starts from 12/28/2024…
-
Number to name conversion of currency value in RTF templateI have currently developed a BIP report using RTF template for a receipt voucher. It contains values in both Arabic and English. I would like to know whether there is a …
-
How can I build an ASL report in BI Publisher with supplier, item, and organization names?Hello, I am currently building a BI Publisher report based on the PO_APPROVED_SUPPLIER_LIST table. The report works fine when using this table alone, but I need to enric…
-
How to report on the notifications sent via "Send Job Application Notification"Summary: Hi team, we'd like to extact all notifications sent via process "Send Job Application Notification". How is this possibile? Thank you, Claudia Content (please e… -
Inquiry Regarding Availability of "Go Noto" Font Installation Files in Cloud ERPMay I confirm that, as a Cloud ERP product, there is no available feature to download the installation files for the "Go Noto" font used in the PDF reports generated by …
-
FA Asset Addition and FA Asset Register reports lexical parameter and Temporary tableHi , Both of these reports use lexical parameter &l_fa_whatif_rep_t. We want to understand how this parameter value is derived. We tried to use fa_whatif_rep_t table, to…
-
Unable to find audit logs for archive or unarchive activity on BIP data model/report in ERP FusionOur client has a requirement to build a BIP report for audit purposes that can fetch information, such as when a user archives or unarchives the BIP data model or report…
-
HCM Tables which store BIP/OTBI Scheduled Report email recipientHi Team - We've requirement to list down all the BIP & OTBI reports which are scheduled along with their email recipient details. (some notification could be dynamic bas…
-
Which SQL Table store the Activity Information of Time Entry in OTL.Which SQL Table store the Activity Information of Time Entry in OTL. Please share the inputs if you know -
How to Trigger 'Send to Fixed Email' for an Integrated Report in a Dashboard Using Action LinksHello, We are trying to automate a dashboard that contains a report (prompted by an OpportunityID) to be sent to our automation server, for example, via a button. Unfort…
-
Oracle Fusion Publisher - How to design a template with merged cells and recurring rowsHi Community, I am trying to develop a excel template report for my client with Oracle Fusion Publisher. This report composes of multiple tables with recurring rows at t…
-
Generate multiple Excel sheets based on parameter valueHi All, We are using Oracle Fusion Cloud Application 25C and Oracle BI Publisher Desktop for developing data template reports. Our requirement is to generate Excel outpu…
-
セールスクラウドで、ロックされたユーザーのリストを毎日出力したいセールスクラウドのユーザーでロックされた人のリストを出力し、毎日特定のアドレスにメール送信したいです。 BIのエージェント機能を使って送信できたらと思うのですが、確認できる… -
BI report data limitationWhat is the BI report data limitation or ideal batch size when used by MuleSoft via API fetch records from Fusion
-
Ability to view the output of BIP reports run by other users in Scheduled Processes.Hi Team, Is it possible to view the output of BIP reports run by other users from the Scheduled Processes tab without the BI Admin role? I assigned the necessary data se…
-
BI Publisher not working in MS Word, and how can I fix it?I downloaded BI Publisher to work on an RTF template, but every time I try to open MS Word, it crashes and becomes unresponsive. The issue resolves only when I remove th…
-
How can we apply conditional formatting in rtf templateNeed to put condition on rtf template , our requirement is to display the 'Accomplishment' section if there is data(count > 0) for accomplishment ,if there is no data ,e…