BI Publisher
Discussion List
-
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… -
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 31 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 13 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):DIPAK KUMAR JENA 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 383 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 145 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 71 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 46 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 171 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. …
-
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… -
oracle report to google sheet directlyis there any way to connect oracle BI and OTBI reports with online google sheet or offline excel file ? ThanksSandeep Nihalani 31 views 2 comments 0 points Most recent by Melissa G Reporting and Analytics for ERP
-
BI Publisher Output File NameSummary BI Publisher output file name Suffixes Template/Layout NameContent BI Publisher report output file from Oracle Fusion cloud suffixes the Template/Layout name at …Senthilrajan V 112 views 12 comments 2 points Most recent by Ravi Tilekar Reporting and Analytics for ERP -
Vacation and Delegation Rules reportSummary: Hi All, We have a requirement to create the below report for Vacation and Delegation rules in the application. Say when Line Manager is going on Holiday and he …Dharmendra Jha 62 views 3 comments 0 points Most recent by Stephen_J Reporting and Analytics for ERP
-
which table Notification attachments are storedSummary: While approving the any approval notification the user can add attachment in the notification. where this attachment are stored. Content (required): Notificatio…
-
Need to push output files of the job Import Project Budgets through SFTP.Summary: Content (required): The issue can be reproduced with the following steps: Step1: We are scheduling the Import Project Budgets job. This is a seeded processes. S…Lokesh Senthilnathan 1 view 0 comments 0 points Started by Lokesh Senthilnathan Reporting and Analytics for ERP
-
HWM_TM_STATUSES - Many entries for a given timecard entry (Human Workforce Management / Timecards)We would like to know how the HWM_TM_STATUSES table works in regards to timecard entry changes (when a timecard is submitted, approved, then modfied). In our observed be…
-
Bursting Enabled or DisabledHi Team, We wanted to check if we have a table or sql query to check how many reports have bursting enabled so a report or list can be prepared for the same. Please let …Swapnil Kashid 42 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
OTBI-Report-Supplier Portal - Invoice Real Time-Roles RequieredSummary: OTBI-Report-Supplier Portal - Invoice Real Time-Roles Requiered Content (required): Hello The following document state the role required to run the Supplier Por…Cesar Saveedra 61 views 3 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for ERP
-
BI - Seeded and Custom Folders Mirroring Each Other?!Summary: We are experiencing several custom template issues and have noticed that our Custom and Seeded Folders are mirroring each other without human intervention. Cont… -
Create a report that shows invoice data on day it was loaded?Summary: Hi everyone. I am curious if there is a way to create a report that allows me to collect data from an invoice on the day it was created. Such as Problem Type. I… -
What tables hold the project costs expenditure batch workflow details for creator and approverSummary:Does anyone know if this information can be reported on using BI Publisher or OTBI to view the approval workflow for project cost expenditure batches? This infor…Rich Merkel 199 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
OTBI report - export to Excel limitationSummary: We have OTBI reports that will exceed the 50,000 field limitation for exporting to Excel. Content (required): Can you "schedule" an OTBI report to get around th…Kathy King 71 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
BIP Excel output always adds additional comma to end of values when saving as csvSummary: Content (required): In BI Publisher, I need to export a simple table report to XLS (not csv) to be used as a template. However, once completed and then saved as…Marcus131975 22 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP