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
-
How to Burst Email and FTP Output Delivery from the Same Schedule in BIP Report?I have a data model and a report in BIP, and there is a requirement to distribute the report output both by email to HR representatives and also to store the output on a… -
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
-
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…
-
bi report and otbi svswe have svs but is possible to have bi report and otbi with svs apply? how can i do?
-
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…
-
How to add response of questionnaire?Hi team, I want to add response of questionnaire for below query. Could anyone help me? SELECT distinct paam.person_id ,to_char(paam.person_id) PERSON_NUMBER ,PPNF.DISPL…
-
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…
-
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 …
-
Is there a way to increase the BI Publisher FTP connection timeout?We are currently utilizing a BIP report as part of an integration process with an external system, transmitted via FTP. While the process executes successfully on most d… -
Oracle Fusion Cloud Database Schema Export for AI contextI am looking to get a database schema file in JSON or YAML that shows tables, columns, ideally column descriptions, primary keys, and foreign keys. This is so I can prov…
-
How to insert a new line in rtf templateHow to insert a line break dynamically inside RTF Template?
-
Is there any table which stores Subledger balances for sources like Payables and specific accounts?I need an information about the tables through which Subledger level balances for specific sources like Payables, Receivables and Fixed Assets and specific accounts (GL_…
-
scheduled BIP report’s job ID shown in the job history is missing from backend tablesSummary: We are unable to locate the job ID of a scheduled BI Publisher (BIP) report in the backend tables, even though it appears in the Job History page. Specifically,…
-
I am trying to populate latest date record to be printed for BPA from PO tables in a custom BIPPer the business requirement, we need to print COO from BPA attached to the shipment, if the shipment lines having country of origin code is NULL, and since there maybe …
-
how BIP job that retrieves data from an Oracle Database table containing a BLOB columnWe have a BIP job that retrieves data from an Oracle Database table containing a BLOB column (e.g., storing PDF or image files). For downstream processing and integratio…
-
requirement to automatically trigger BICC/BIP batch jobs after the ComCal are completed in the FIC.We have a requirement to automatically trigger BICC/BIP batch jobs after the Compensation Calculations are completed in the FIC (Fusion Incentive Compensation) applicati…
-
Hi everyone, could you share an SQL to fetch the latest HCM Group of an employee?Hi everyone, could you share an SQL to fetch the latest HCM Group of an employee?
-
How to send report output files over email or as a link based on file sizeWe have a custom BI report. The report generates excel output and the file size can be of 100 MB or more. We have a requirement that if the file size is less than 10 MB … -
Would it possible to extend the sql quey time limit.Hi Team, There is an BIP report scheduled and it was taking more than 1800 secs to run. While it was crossing 1800secs the report is failing. Is there any way we can ext…
-
OTM BI Publisher - barcode fontHi, We are modifying a report in Oracle Analytics using LibreBarcode39Extended-Regular.ttf font but when making any changes to the existing report the barcode is not dis…
-
How to review scheduled BIP jobs not yet running?I'm submitting several jobs to run at different hours and I would like to review the schedule before report are running. How can I do this? Thanks -
How lexical parameters are replaced in fusion BI reportHow is lexical parameter like &LP_FA_DEPRN_DETAIL getting replaced in Form 4562 - Depreciation and Amortization Report.
-
What Value should be provided to Lexical parameter for Seeded Report Data modelHi All, What value should be provided to below Lexical parameter for Seeded Report Data model of Uninvoiced Receipts Accrual Report ? &ACCRUAL_ACCOUNT &CHARGE_ACCOUNT Th…
-
How do I adjust time zone ins rtf date fieldI'm configuring a RTF template to a term document, but here's my problem, in that document it must contain the from date of a compensation plan, but when I put the field… -
Need the last modification date of 'Generate Audit Report'Hi Cloud Community, Currently, we don't have access to data model/report for the seeded report 'Generate Audit Report' in Oracle Cloud Fusion. Business user has a requir…
-
SQL Query to get Change Order TasksHi. I am looking for Query to get Change Order Tasks from SCM Oracle fusion tables. Attaching Screenshot