BI Publisher
Discussion List
-
BI Excel Template missing formula when data generatedSummary: I've created a BI Excel template based on a DM and the requirement is to have certain columns color coded in the end of the report and also have a formula field…KrishnakumarPathipati 31 views 5 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Identifying Underlying Queries for SmartLOV/ VOs In BI PublisherSummary: Content (please ensure you mask any confidential information): Hi experts, Would any of you know how to identify the underlying query for a view object in BI Pu…
-
Etext template output file(.txt) is unable to print Arabic language in sequenceSummary: We have custom Etext template under disbursement payment file formats. In that Supplier name is required to show in Arabic language in output file. for testing …SireeshaJaladi 41 views 2 comments 1 point Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
Is it possible to generate barcode for space in BIP fusion?Summary: Is it possible to generate barcode for space in BIP fusion? Content (please ensure you mask any confidential information): We've already setup BIP barcode font …Lucy.liu 41 views 3 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
BIP report historySummary: I have a requirement to pull the BI reports from Report history for failed runs. Do we have any table to pull the BIP report data based on date range. Content (…
-
RTF template to xls report with blank rows due to conditional regionHi All I created a rtf template which need to output as a xls file. After it generated, it shows some blank rows due to the conditional region in ref template. xls outpu…
-
SQL-How I get all the children/parent of account in GL ?Summary: SQL-How I get all the children/parent of account in GL ? Content (please ensure you mask any confidential information): Hello I am looking for a custom report t…Cesar Saveedra 21 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Fixed Asset ReportingSummary Reporting from Fixed Asset Sub-LedgerContent Hello - I'm looking for the following information in a report from the Fixed Asset sub-ledger. I am looking for a re…User_2025-01-29-20-33-47-986 163 views 6 comments 1 point Most recent by Tim Sweeney-279789 Reporting and Analytics for ERP -
Schedule in Analytics is Greyed-OutSummary: The Schedule button is Greyed-out Content (please ensure you mask any confidential information): Please help! Version (include the version you are using, if app…Dorren Veil Laniog 134 views 2 comments 0 points Most recent by Dorren Veil Laniog Reporting and Analytics for ERP -
Making Tax Digital - UK VAT ReturnsSummary Report needed to extract data for HMRC VAT returnContent All VAT registered businesses in the UK are required to submit their monthly VAT returns to HMRC electro…Patrick Haston 298 views 5 comments 2 points Most recent by Patrick Haston Reporting and Analytics for ERP -
How to bursting a report with multiple data sets ?Hi all, I have a BIP report with multiple data sets to query different data to different excel sheets. I'd like to use bursting function on this report, but I found that…Weitao 653 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
How to create an OTBI Report to display GL Parent/Child values ?Summary: How to create an OTBI Report to display GL Parent/Child values ? Content (please ensure you mask any confidential information): Hello I would like to have a Cha…Cesar Saveedra 231 views 2 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for ERP
-
Can anyone help in sharing an idea for developing contra account report.Summary: For example, if in parameter, an account is selected, all relevant Debit and Credit which were generated against that account gets reported. Content (required):…Usman Ul Haq 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Table/Query to find the BPM work flow notification pending with particular personSummary: We are looking for Workflow notifications (Especially Expense report) pending with one particular person for approval. Do we have any table which stores this de…Thanigainathan R 474 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
can we pull historical details of CANCELLED ESS jobs from back-end?Problem Description --------------------------------------------------- AUDIT CONCERN: can we pull historical details of CANCELLED ESS jobs from back-end? During an audi…Janardhan ACS-Oracle 33 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
How to link between General Ledger, Subledger and Receivables tables in BI PublisherSummary: I'm trying to add information from the Receivables tables to a General Ledger query on income when a transaction has come from the receivables ledger. But I am …
-
Oracle roles required for developing BI reportSummary: Need to know what Oracle roles are required for an user to develop BI report Content (please ensure you mask any confidential information): Version (include the…
-
Searching for table containing segment values and descriptionsSummary I'm writing the SQL in a data model where I need to display account value and descriptionContent I'm creating a data model where I want to display segments in th…User_2025-01-25-00-55-11-011 1.6K views 8 comments 1 point Most recent by GAVMAX Reporting and Analytics for ERP
-
Can we call OTBI/Analytics dashboard using SOAP/REST webservices in oracle fusion?Hi , We have a requirement to run/submit the analytics/OTBI dashboard using rest/soap webservices. Please share your inputs. Appreciate your help. Thanks in advance.Bhavani Rikkula 286 views 2 comments 0 points Most recent by Bhavani Rikkula Reporting and Analytics for ERP
-
How to print tables side by side in BI publisherHi, I was trying to develop a rtf template to print the Invoice copy. As part of the requirement, I need to print tables side by side. I was able to add the tables side …AVN 162 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
REST API to run FRS reports in FusionSummary: Need to know REST API details if any to run FRS reports in Fusion Content (required): REST API to run FRS reports in Fusion Version (include the version you are…Sudha KOVURU 361 views 4 comments 0 points Most recent by Subbareddy Kandala Reporting and Analytics for ERP -
DFF Value (Change/Update) reflection in OTBI Subject AreaSummary I have a DFF with current value as A and OTBI shows that DFF value as A... Now I change the DFF field value to B Does the Value B automatically gets reflected in…UjasB 307 views 11 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP
-
How can we get GL accounting date for budgetary control ?Summary: Hi Team, We have requirement to build a report which will have accounting date for each line in budgetary control. How can we link budget and GL tables to fetch…Nidhi Chhajed 31 views 3 comments 0 points Most recent by Lakshmanji Karupalli Reporting and Analytics for ERP
-
Sending Reports to a Google DriveSummary: One of our customers is looking to have certain reports from ERP delivered to a Google drive location. Has anyone tried this and if yes how was it done? Any inp…Govind Srinivasan-Oracle 141 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Trial Balance with UNPOST journal entriesContent Dear experts, We got an requirement that create Trial Balance with Unpost JEs. I tried to use OTBI with cross subject areas GL-Balance and GL-Journals by adding …SSS Song 89 views 1 comment 1 point Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
How to add Reports to Task Menu (Reports and Analytics) in UI?Summary How to add Reports to Task Menu (Reports and Analytics) in UI?Content Hi How to add Reports to Task Menu (Reports and Analytics) in UI? We have requirement like … -
How does SQL Pruning in the data model affects the report performance?Hello, We have a customized version of the AP Aging report. The report performance is slow compared to the standard one. To improve the performance we did some adjustmen…Kristelle 41 views 1 comment 1 point Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
What happens if a report is scheduled by a user and, the user is inactivated in futureSummary: What happens if a report is scheduled by a user and later once the schedule is active, the user is inactivated. Also, how can a new user take control of the sch…Abhilash K - Deloitte USI 41 views 3 comments 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
unable to get all the column values in Excel output in BIP reportSummary: Hi, When I run the BIP report to get the output in CSV, HTML etc. its fetching all the column values but when I run it to get the output in Excel format few col…Satish123 61 views 10 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
23D Table ImpactedHello Team, Can anyone tell me the List of Table that is getting depreciated or new table being introduced in 23D release of Oracle Cloud ERP. Thanks, Sandeep Shaw