BI Publisher
Discussion List
-
How to add standard report icon in springboardSummary: I have a requirement to add icon of a standard BIP report in springboard. I am using static URL to create page entry. We cannot open a standard BIP report from …AeeTee 359 views 1 comment 0 points Most recent by Ramneek Grover-Oracle Reporting and Analytics for ERP -
How to Pass Parameter value Of All in REST APIWe use REST API to call BIPublisher report - we are able to pass specific values in the parameters however if the report parameter has a Value of All (aba.batch_name in … -
How to get list of all the reports that are run in the last 3 monthsSummary: Is there a way to get list of all the reports that are run in the last 3 months in Oracle Fusion(Not just ESS Jobs but also run directly in catalog). Content (r…VinayGeddam 58 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Award Project amountsSummary: Award Project amounts Content (required): Can you please help me with table name or query to extract amount on Manage Award --> Open award --> Financial Perform…Nidhi Chhajed 20 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
How do I implement custom barcode fontSummary: We have a requirement to print barcodes in BC3of9 and Code128 fonts. We implemented using the delivered Oracle-supported fonts. However, the client tested and s…Lisa Taroma 133 views 2 comments 0 points Most recent by Lisa Taroma Reporting and Analytics for ERP
-
Is it possible to report on requisition approval volumesSummary: Our business users are asking for reports to see who has approved purchase requisitions made in the business so that they can track volumes etc. Does anyone hav…DLMorgan 26 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
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 368 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 44 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 567 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 65 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 27 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 430 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 47 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 37 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 84 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 77 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 282 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 158 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 38 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 17 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 45 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 800 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 215 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 186 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 …