BI Publisher
Discussion List
-
Table details which store scenario present on Inquire on Detail BalanceSummary: Table details which store scenario present on Inquire on Detail Balance Content (required): Version (include the version you are using, if applicable): Code Sni…Nidhi Chhajed 315 views 8 comments 0 points Most recent by Nidhi Chhajed Reporting and Analytics for ERP
-
QR CodeSummary: Normally we will add one field/ concatenate more than one field to generate the QR code from oracle bip rtf template, can we generate QR code for complate XML f…
-
Print Receivable Transaction Program sending invoice to all contacts of an accountSummary: Print Receivable Transaction Program sending invoice to all contacts of an account despite invoice having a single contact associated. We have an invoice in our…Dhruvjoshi23 31 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
ESS Job Report Output File NameSummary: Content (required): We used Bursting to set the file name of the report. It is displayed correctly on the ESS Job screen but when we click on the file to downlo…Vinay Gharge 542 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
BI Template Sum Function Not Working ProperlySummary: The Sum function in the BI template not working as expected. Content (required): We have a custom report where we used the sum function on specific field but it…Ahmed Maher Kadeh 61 views 3 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Performance Issue caused after 22B upgrade for CF Activity ReportSummary: Hi Team, We have performance issue in our report after 22B update. Regards Nidhi... Content (required): Version (include the version you are using, if applicabl…Nidhi Chhajed 21 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
How to find the PTD, YTD and LTD for budget and actual for PPM BIP report?Summary: I want to fetch : 1) Period Name 2) From Project Number 3) To Project Number 4) FERC Code 5) Major Capital Category 6) Minor Capital Category 7) Project Owning …Anshul Varshney 401 views 0 comments 0 points Started by Anshul Varshney Reporting and Analytics for ERP
-
Is possible to create a report wit the purchase orders that no have any attachment?Summary: I want to know if is possible to create a report wit the purchase orders that no have any attachment. Content (required): I found that the documents of the purc…Jessica Yamilet Valdes Romero 42 views 2 comments 0 points Most recent by Jessica Yamilet Valdes Romero Reporting and Analytics for ERP
-
Backend Table for failed bursting casesSummary: Content (required): Is there a backend table or report we can use to show which all bursting emails were failed to sent to the supplier/customers? When we run "…Vinay Gharge 32 views 4 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Group Filter not working in Custom ReportContent We have developed a custom Report. The Data Model is a master detail query includes a main query and three child queries Q_1 - Main Q_2, Q_3, Q_4 are child queri…Balachander G-Oracle 78 views 7 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for ERP
-
File Error Data may have been lostin OTBI - BI Publisher report that has multiple tabs is showing this error on opening the excel file. File error : data may have been lost Users are able to provide a sp…Dhruvjoshi23 71 views 2 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Query or the table that contains financial catogory for manage value UISummary: Hello all, We have a report in which we need to pick the financial category code we put against an account in manage value UI.please advise! BR, Sushan Peiris C…Sushan Peiris 261 views 13 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How to Translate the BI Publisher Catalog Report Name and parameter to multiple languages.Summary How to Translate the BI Publisher Catalog Report Name and parameter to multiple languages.Content How to Translate the BI Publisher Catalog Report Name and param…
-
General Ledger Transaction Listing ReportSummary Lists down all Journal Entries along with corresponding subledger detailsContent This is one single consolidated view of all the transactions in ERP. This report…
-
Unauthorized Access: Either you do not have the privilege, or you have not signed inAfter latest upgrade from Oracle fusion to version 22A and 22B - OTBI users are experiencing this error - intermittently. Everytime they refresh it connects back - but i…Dhruvjoshi23 133 views 5 comments 2 points Most recent by User_CUA6U Reporting and Analytics for ERP
-
Best practice to re-use same query in the same BIP data modelSummary: I have a common query say for selecting business unit based on certain user based login. Now I have a main data model query with multiple sub-queries in it. And…Ashu Raj-Oracle 34 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Strange SQL results, can't explain causeHi, I am comparing the use of SQL via Analytics between instances used by 2 different customers, both on version 22A. Example URL: example.fa.ocs.oraclecloud.com/analyti…
-
Is there any way to get the sub category for module identify column in HRC_TXN_HEADER tableWe could see lot of transactions for Manage Employment (Under Module Identify field --> Table HRC_TXN_HEADER). We are trying to segregate the transactions. We are trying…Kiran Kollamsetti 11 views 0 comments 0 points Started by Kiran Kollamsetti Reporting and Analytics for ERP
-
How to download OTBI and BIP reports before the refresh of the instance ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):DJ Kumar 41 views 4 comments 0 points Most recent by Deshin Pillay-Oracle Reporting and Analytics for ERP
-
BIP report Excel output is formatting large numbers as General/scientificSummary: We created a BIP report for Fixed Assets. Any numerical values in the tens of millions or higher export to Excel as scientific. For example, an asset Cost of 42…Brad Kirschner 708 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
BIP Report to read file from UCMSummary Need to read file in UCM using BIP ReportContent Hi Team, Could you please let us know whether it is possible to read file from UCM via BIP report ? If anyone ha…Uvaraja-Oracle 182 views 7 comments 0 points Most recent by Rory Mullin Reporting and Analytics for ERP
-
Read a file from UCM via Web Service as Private Data SourceSummary: Read File from UCM Web Service BI Publisher Content (required): We need to be able to read a file from UCM utilizing a data model in BI Publisher. We were able …
-
Fixed Asset Balances - Real Time subject area is not updatingSummary: Content (required): We have developed a report using the Fixed Asset Extract Balances table and the recent transactions re not updated in the table. The "Extrac…Dian Minshan 142 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
GL Trial Balance Report Custom TemplateSummary:We've created custom template for TrialBalalnce.xdo, But still ESS job is taking standard template.Is there are changes required in configuration to pick custom …
-
Graph or Chart in BIP ReportSummary: We need to build a report that shows a table with all the data and then a graph/chart for the same data. We have an RTF template built for the same. Please advi…Ashu Raj-Oracle 41 views 2 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
Table which holds errored workflow Items.Summary: Finding the table which holds errored workflow items Content (required): Hi there, I'm trying to locate the table that holds the errored workflow transactions (…
-
FBDI Fails to import Data containing Double Quotes(")Summary: FBDI Fails to import Data containing Double Quotes("). We are loading Items through "ItemImportTemplate" FBDI template. In item description we have data like WO…Lucky Sharma 213 views 8 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
How to tackle different date formats being entered by user in Supporting Reference in BIP Report?I have a scenario when users input dates in multiple formats eg.18/Mar/2022, 18/March/2022, 18/03/2022, 2022/03/18 while posting a Journal in the Supporting References. …User_2025-02-12-15-34-52-841 21 views 2 comments 1 point Most recent by User_2025-02-12-15-34-52-841 Reporting and Analytics for ERP
-
After 22A upgrade we are not able to delete BI email server from Oracle Cloud Non-Prod InstancesSummary: Please suggest, After 22A upgrade we are not able to delete BI email server from Oracle Cloud Non-Prod Instances Content (required): After 22A upgrade completed…User_J7H19 31 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
ERP Cloud BIP report data model schema integrate with EPBCSHi all, I need to create a metadata / dimension integration from our ERP Cloud GL to EPBCS via data management. Can you please help me find in ERP the SQL query on top f…