Category 67
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…Praveen Kumar Ponnusamy 1 view 1 comment 0 points Most recent by Swathi Shetty BI Publisher Learning Center
-
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,…Kalpesh Salunke-Oracle 1 view 0 comments 0 points Started by Kalpesh Salunke-Oracle BI Publisher Learning Center
-
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 … -
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…Tauseef-Oracle 22 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle BI Publisher Learning Center
-
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…Nalsoft Pvt Ltd 11 views 0 comments 0 points Started by Nalsoft Pvt Ltd BI Publisher Learning Center
-
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.
-
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…Satyanarayan Panda 21 views 3 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle BI Publisher Learning Center
-
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 …Manu Krishna T M 6 views 0 comments 0 points Started by Manu Krishna T M BI Publisher Learning Center
-
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 …Paul H - Terillium 93 views 3 comments 0 points Most recent by Narasimha Raju BI Publisher Learning Center -
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…ChicagoConsultant 1 view 0 comments 0 points Started by ChicagoConsultant BI Publisher Learning Center
-
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…Carlito Conrado 321 views 2 comments 0 points Most recent by User_NGGGG BI Publisher Learning Center
-
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…
-
Sending new hires notifications to managers before the actual hire dateHi All, Is there a way that we can create a BI report and using bursting we can send new hires notifications to managers before the actual hire date. Notification email …
-
In BIP report, how to call an image stored in Catalog pathHi Team, Company Logo is uploaded in Catalog path (/shared/Custom/Logo/image.gif). I need to call this image in rtf template. I used below syntax but it did not work. Ca…Praveen Kumar Ponnusamy 11 views 1 comment 0 points Most recent by Praveen Kumar Ponnusamy BI Publisher Learning Center
-
How to call fast formula using procedure call sql typeHow to call fast formula using procedure call sql type such that i can use for the remaining calculation to build BI report.
-
How to keep rich text format bip report in Excel output.We are using rich text format for Questionnaire answer format. can we possible to fetch below like links & Bold format in excel output.
-
requisition approval tree not generted how to write BIP queryCreate notification like when requisition approval tree not generated trigger notification.SivaRamaKrishna-Oracle 1 view 0 comments 0 points Started by SivaRamaKrishna-Oracle BI Publisher Learning Center
-
Jan2025 CPU CVE-2016-1000027 shows vulnerability in BI Publisher 7.6.0In the January 2025 Critical Patch Update (https://www.oracle.com/security-alerts/cpujan2025.html#AppendixANLY) CVE-2016-1000027 shows a vulnerability in BI Publisher 7.… -
Setup fusion bi publisher bursting output to Microsoft teams channelSetup fusion bi publisher bursting output to Microsoft teams channel
-
Dynamic BIP Query executionWe have a requirement to execute dynamic query using BIP in oracle ERP Saas and was going through this (Doc ID 2636492.1) which says passing dynamic query as parameter d… -
How to call one particular data model query into another report's Data Model without repeat query.We had a requirement that I have to use the query written in report-1 in report -2 without writing the whole query. I just want to refer that report-1 query and will bui…
-
Scheduled HTML output report does not deliver the message put in the Output tab of scheduled pageHello All, Hope you are doing fine. There is a business need to keep the output type as HTML of a Oracle fusion BIP report. Also when this report is run through scheduli…
-
Open button missing on Dashboard report, how to get it?Unable to see the Payables Withholding Tax Report Open button missing for this Dashboard report, I added BI Admin roles but can't see itEswarvoona-Oracle 1 view 0 comments 0 points Started by Eswarvoona-Oracle BI Publisher Learning Center
-
What does the asterisks in table comments mean?Hi all When reading the table definitions, for example here: https://docs.oracle.com/en/cloud/saas/project-management/25a/oedpp/pjcexpitemsall-24862.html#Details there i…Anders W. Langholm 2 views 0 comments 0 points Started by Anders W. Langholm BI Publisher Learning Center