Report Output
Discussion List
-
Authenticationadf.login=true issue when opening the hyperlink in excel outputHi Team , can anyone help me in resolving the issue Authenticationadf.login=true when trying to open the invoice pdf attachment available as hyperlink in excel output of…
-
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…
-
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 …
-
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…
-
How to insert a new line in rtf templateHow to insert a line break dynamically inside RTF Template?
-
How to display date in the format (like April 1st 2025) using RTF tags.The requirement is to display the date like April 1st, 2025 in the RTF Template using RTF Tags.Nalsoft Pvt Ltd 23 views 3 comments 0 points Most recent by Hari Haran Reporting & Analytics for Fusion Service
-
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…
-
Custom Fonts Not Reflected in PDF Output – BI Publisher RTF Template (OLC Certification)Hi All, In the OLC module, our client provides certifications with text styled in custom fonts. I have uploaded an RTF template in BI Publisher and exported it to PDF fo…
-
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 …
-
What is the support version of Excel in Oracle Fusion BI Report?Is it only support Excel 97-2003? Does it support .xlsx format, please?Venus Yim 12 views 1 comment 0 points Most recent by kanchana venkatasubramanian BI Publisher Learning Center
-
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…
-
Changing the POV of migrated Financial Report to Reports (Insert Formatted) reportWhen I edit the POV of a report downloaded using Insert Formatted Report, it appears to open a new Excel sheet rather than simply refreshing the values within the existi…Patrick Pontillas 3 views 0 comments 0 points Started by Patrick Pontillas BI Publisher Learning Center
-
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…Omran Zeaiter 305 views 8 comments 1 point Most recent by GauravSethiya BI Publisher Learning Center
-
Oracle BI report for account hierarchyI am trying to create a oracle BI report for account hierarchy, but I'm a bit stuck. I used the code below but get a message of missing right parentheses. SELECT LEVEL A…
-
where to find the database connection manager in FRS workspaceHi, I am trying to get the database connection definition and details for FRS report, however i can't find the database connection manager in 23D. I do see the Essbase a…nehayadav86 11 views 2 comments 0 points Most recent by Prasanna Villari BI Publisher Learning Center
-
Bi Publisher data model parameter not displaying into Bi publisher report parameterHi Team, I observed one issue in FDI Bi Publisher environment data model created with List of Values and parameter. Data model working perfectly. But when same data mode…Indranil Basak-Oracle 18 views 0 comments 0 points Started by Indranil Basak-Oracle BI Publisher Learning Center
-
Image reflecting differently in RTF Template and BI Report OutputIn RTF Template I have made the background transparent But in the BI Report Output it is coming as
-
How to add new columns in a Pivot table developed using BI Publisher extension.The requirement is to add calculation columns like Average and Variance in a BIP RTF template which has a pivot table. The calculation columns need to added after the pi…
-
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
-
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 5 views 0 comments 0 points Started by ChicagoConsultant 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…
-
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 3 views 1 comment 0 points Most recent by Praveen Kumar Ponnusamy BI Publisher Learning Center
-
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.
-
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…
-
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 3 views 0 comments 0 points Started by Eswarvoona-Oracle BI Publisher Learning Center
-
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…
-
Time Stamp Date and Time in BIP report NameHi, I am Scheduling BIP report for everyday. I wanted to Timestamp the Date and time in the output file name. For Example : The Schedule process is run on 15th June 2022…Shashank Verma-Oracle 1.9K views 7 comments 0 points Most recent by Ken Padgett BI Publisher Learning Center
-
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
-
Missing/incomplete Data produced in the Oracle fusion BI publisher reports XML FormatWe have developed a custom BI Publisher report in the Oracle Fusion Cloud instance. The report is expected in the xml format. We have an issue here. i.e., the report com…