Reports
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 … -
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
-
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…
-
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
-
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
-
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.
-
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
-
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
-
How to call a web service in BIP SQL queryI have implemented a web service call in Oracle Fusion. Is there any way we can invoke the web service within an SQL data model in BIPHarikumar S - NetApp 21 views 0 comments 0 points Started by Harikumar S - NetApp BI Publisher Learning Center
-
schedule or live execution discriminatingHi I want to ask you if there's a way in BI to discriminate if the execution of the report is live or scheduled? i would like to variate the template layout based on the…
-
How can we find out if there has been a recent change to Oracle ISP geolocation reporting?Summary: We're having new difficulties since about 1/25/2025 with the reported geolocation of an Oracle IP address used to deliver reports. Can we find out if there has … -
How to make US1099 report to be emailed to Vendor?Is there a way to email US 1099 to the email addresses on file? User has run this in excel and .pdf - just need to know how to distribute by email to the vendor to the a…
-
Need to schedule BICC jobs every 5-10 minsWe need to schedule BICC jobs to run every 5-10 minutes. Is it feasible to schedule these jobs through a web service or user interface?
-
Table that stores the file contents of an attachmentHello, We need a table that stores the base64 format of the attachment uploaded in a work order or if there is any table that stores the binary format of the file conten…
-
Need to know which bi reports are being run by a user in a monthly basis and how oftenWe need to know which bi reports are being ran by a user in a monthly basis. Here the challenging thing is report ran might be scheduled or adhoc (ran directly) , we nee…
-
BI report scheduled jobs are skipping though the trigger is returning recordsBI report scheduled jobs are skipping though the trigger is returning records.Swapna Rachamalla 1 view 0 comments 0 points Started by Swapna Rachamalla BI Publisher Learning Center -
How do you write a query for standard working hours in BIP?I need to get the standard working hours for employees into my query. I can see the standard working hours work is worked out in the following order : 'Standard Working …
-
Sql query to get payroll process name Under a batch Name /Instance nameHi , I am looking for SQL table to get payroll process name currently i can get batchname/Instance name via below query : SELECT pfi.instance_name FROM pay_flows pf,pay_…Surbhigupta_88-Oracle 422 views 3 comments 0 points Most recent by Karim Ahmed Abdallah BI Publisher Learning Center -
BI multivalue filter with bad performanceHello, We are tuning a query and see that the performance issue was in the multivalue filters. We are filtering invoices with the Code combinations table and filtering d…
-
RTFtemplate sorting data is there any limitWe want to sort the data in alphabetical order for “Payment Process request status report”. This is the seeded report provided by oracle when PPR is ran. Seeded report i…SivaRamaKrishna-Oracle 11 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
can we add columns with name spaces while creating an eText format of the BI publisher report?We have requirements to create and extract CSV files for another system as integration. The requirement was to have column names with space (e.g. First Name). We have do…