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 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 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…
-
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 …
-
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 it
-
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… -
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 BIP
-
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 to disable value details from bar Graphs and Pie chart in BI Publisher Layout(xpt template)Hi All, We have created a report which shows output as Pie chart and Bar graph. when report runs in Interactive mode, and when placing the cursor over pie chart or Bar g…
-
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…
-
How to send data from one dataset to another dataset?Hello guys, I have created one data model in which two datasets are there. is there any way to get data from one dataset to another dataset in bi publisher? for eg. I ha…
-
How to implement a link in BIP report to dynamically download logged in user's detailsWe have added a download link in BIP report and inserted following URL: https://"Environment link"/filepath".xdo?param1=@{PERSON_ID}&_xpt=1&_xf=pdf But the downloaded re…
-
Managing PGP Encryption for Reports on sFTP ServerHi, We previously set up a daily scheduled transfer of reports to the sFTP server, using PGP encryption. Our customer now requests additional reports to be sent to the s…
-
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?
-
Approaches to Encrypt Sensitive Columns in BIP Data Model ResultsSummary: We need to include an Apex URL in the email generated by BIP. The URL should be constructed using the host component and encrypted values from specific columns,…
-
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…
-
How to burst the BIP report output to AWS S3 bucket?We have created a BIP report with FTP delivery bursting, and now the report output is being uploaded to an SFTP location. I would like to store the same file in an AWS S…
-
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…
-
BI report scheduled jobs are skipping though the trigger is returning recordsBI report scheduled jobs are skipping though the trigger is returning records. -
Limited Oracle Allow List IP's For Outbound Connectivity For Fusion ApplicationsSummary: Limiting Oracle BI reports direct transfer IPs Safe list Content (please ensure you mask any confidential information): Base on this doc "Oracle Allow List IP's…
-
Link between the gl/xla tables and tax tablesHello, I need to display the tax information (tax code, tax rate) for Journals having source 'Tax' (Note that these are journals created using the 'Create Taxable Transa… -
Table for Bursting Output ResultsWe have a required to update SO EFF based on bursting output results. However when few of the bursting fails, Job is completing in error and Logs are not providing any i…
-
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… -
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…
-
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…
-
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… -
Bursting Email not getting sentHI While I am using Parameter3 of query as my company's domain mail. It is not getting sent . Please suggest client does not want email sender to be shown as Oracle. How…
-
How to send bursting email using personal email address?How to send bursting email using personal email address?Do we need to configure something or mail address can be used directly in bursting query?
-
EDI Transactions Each Day, Total for AP Checks and Total Funding Required for Paymode ReportTrying to Create a Report Current Reporting Tools: They currently don’t pull reports from the HOST system but use IBM Document Direct linked to HOST activities. Identify…
-
rtf template payment "due date"Hi, I want to modify an XML template (rtf format) to payment batches formatting. I get now the invoice due date SUBSTR(to_char(to_date(to_date(PaymentDueDate,'YYYYY-MM-D…