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
-
sent automated email when records are more than 50I have a report which lists failed records for ar invoice. I need to send a email with list of records, when there are more than 50 records failed. Can this be achieved … -
Hi Team, In BIP report I'm calling a rtf sub template. Report error out.Hi Team, In BIP report I'm calling a rtf sub template. Report error out for reason "Template invoked but not defined.". Can you advise what could be the issue I used the…
-
Need to know DB table for BIP report history 'Output and Delivery' sectionHi team, We need table name to build report to extract 'Output and Delivery' (highlighted in orange box)from BIP report history, any help is highly appreciated. Regards,…
-
From which table can I obtain the name of the owner of a Succession Plan?Starting from this query, i try to obtain the name of the owner plan but without results. Can you help me with one suggestion, please? SELECT HP.PLAN_NAME, HP.PLAN_TYPE,…
-
How to update a DFF field from a BI publisher report?We need to modify Generate Extensible Work Order Traveler Report and accommodate a print counter, last print date, last printed by at the top of the report. The purpose … -
How can i integrate the p_start_date and p_end _date parameters into this query in BI Publisher?Summary: I need to integrate the p_start_date and p_end _date parameters into this query in BI Publisher Content (please ensure you mask any confidential information): V…
-
BIP reports usageSummary: Is that possible to run a BIP report that show all BIP reports that have been running in our POD? We know we can see the scheduled reports in ESS table but we a… -
Displaying Data from Multiple Datasets in BI Publisher RTF Template with Hyperlink SupportWe have a business requirement to include hyperlinks in the output of an Oracle Fusion BI Publisher report, enabling users to directly navigate to specific application p…
-
Dynamic Picture watermark based on the conditionThe requirement is to get Picture Watermark only for a specific sponsor of the employee. If the employee has a different sponsor, we should not get any watermark. How ca…
-
EBS sftp connection does not establish BI Admin (FTP), what need to be donehi, I am developing cloud BI report with bursting mode FTP delivery mode, file transfer scp cloud to EBS. Creating FTP connection (BI admin) based on EBS FTP details. it…
-
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 Configure Request Payload for POST Method in BIP DataModelHello Oracle Community, I am currently working on a project where I need to invoke a REST API from a BIP DataModel/Report. However, I'm facing an issue with configuring …
-
IF condition issue in docx templateUsing the .docx template to generate reports in oracle APEX In this template, we are unable To include if condition To hide/show a table row based on if condition We hav…
-
I need to call external rest api to using custom ESS JobHi, I need to call External rest api using Custom ESS Job based on Datamodel (BI report). if you have any method available. please share me.
-
Getting the the error when executing the ess job ?####[2023-10-26T09:15:36.294+00:00] [INFO] dummy file is deleted ================ BIPJobExecutable Execution Started ============ OutputFile : /u01/APPLTOP/instance/ess/…
-
How to remove new Line from a clob column?Hello experts, I am trying to write a report which includes a CLOB column. But in the table there's blank line in every row, and getting an issue in excel output where t…
-
Columns removed while editing the dataset in Data Model for BIP reportHi All, We are editing the 'Statement Generation Data Model' ,. We have few existing columns which are available in the Structure diagram, but same is not available in D…
-
How to pass multiple values for a parameter in BIP report URLWe are trying to access a BIP report via URL. It is working fine when single values are selected. However when multiple values need to be passed for a parameter in URL, …
-
What values should be provided to lexical parameters for seeded data model for Asset Register ReportWhat values should be provided to lexical parameters for seeded BIP data model for Asset Register Report - *&L_INVOICES *&L_SOB_INV *&d_category_segs *&d_asset_key_segs … -
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 …
-
Custom UCM datasource To Retrieve The Text Attachments for PDFHi. I used this document: How to create Custom UCM datasource To Retrieve The Text Attachments for PDF ? ( Doc ID 2643214.1 ). I was able to follow all of the steps and … -
BI Publisher Exel Output is Aggregating Multiple Values in Single FieldThe output from one of our custom BI Publisher reports is sometimes aggregating two values into the same column on more than one column. The values can sometimes be diff…
-
How do we track / audit of the PVO customization in BICC?How do we track / audit of the PVO customization in BICC? We have multiple teams working on creating Jobs in BICC after doing some PVO customization. It is overriding th…
-
Reports on Generative AI Usage and AuditsSummary: Reports to get data on Generative AI Usages and feedback. We are implementing Gen AI for feedback generation but need reports to understand GenAI feedback and U…
-
Oracle BIP Access Denied, check SOAP privilegeI'm doing an automation for Oracle BIP when I got an Access Denied error but the credential I'm using is an Administrator account. I'm using the login method from the ht…
-
Need to hide a sheet when no Data Exists in Excel Mutilsheet Excel Template ReportHello I created a Data Model with multiple data sheets in Oracle Cloud BI. I have also created a multisheet Excel Template. The template is working fine but i want to hi…
-
How to burst BI Publisher reports that use PL/SQL Procedure call?I've used the following PL/SQL code: DECLARE TYPE REFCURSOR IS REF CURSOR; XDO_CURSOR REFCURSOR; L_DATA_CLOB CLOB; BEGIN L_DATA_CLOB := L_DATA_CLOB ||'' ||'SUCCESS' ||''…
-
The report output isn't available. You must schedule the report to run.Summary: Hello, I am trying to create a BI Publisher report for users under the custom folder so that they can run it from FRC. I am able to run it but when uesrs are ru…
-
disable send button in bi report output and deliveryHi Team, is there a way we can disable/hide "send " button in bi publisher report output and delivery section in report history page
-
How to send report name with timestampHi Team We have created the BIP report and business requirement is to send the report through email. we can able to send the file but how to put date and time in the out…