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.
Reporting and Analytics for ERP
Discussion List
-
How to disable Edit option in OTBI Reports?Summary How to disable Edit option in OTBI ReportsContent Need to disable the Edit Option from the OTBI Analysis. Could you please suggest how we can achieve this? -
Newsfeed vs Banner vs PanelSummary Default Home Page Layout OptionsContent Is there a recommended option for Default Home Page Layout? Are there benefits of going with one over the other? Looking … -
Project Invoice DistributionSummary Project Invoice DistributionContent Hello All, I want to know from which table we can get below information:- -
Segment Value Security for Chart of Accounts in Custom BI Publisher reportSummary Enable Segment Value Security for Chart of Accounts in Custom BI Publisher report in bulk modeContent We have a requirement to enable Segment Values Security for… -
Missing account coding data for Invoices in Workflow tables in PRODContent Hello, We have a custom BI report that tracks the Account coding details for AP Invoices. We are using the workflow tables to get these details. Per my understan… -
BIP Report Error with XDOException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid numberSummary As soon as report is submitted it throws XDOException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid numberCode Snippet WITH tax_cal_datesAS (SELECT (SELE… -
Influencing the SQL Optimizer in SaaS ERP ApplicationsSummary We have a query that was running perfectly in our non-prod environment for month up until mid December 2020. Then it suddenly timed out and performs poorly.Conte…
-
BI Publisher report with cashing multi-million records query and staggered upload to FTPSummary BIP Maximum Rows for CSV output limit is 2 million. need elegant solution to query database only once for bigger record count and then have staggered upload of r… -
A company wants to sell part of its businessSummary Typical Organization planning for De-MergerContent There is a Company A, who is on oracle Cloud and now it wants to split the business into two parts i.e. Compan…
-
Need number of asset transfers and modifications in 2020Content Hi, I need to find the total number of asset transfers and modifications made in 2020. Is there a BIP query that can return this information please? regards Nige… -
BIP Deeplink in report to view Purchase OrderContent Has anyone added a deeplink in a BIP report to view a PO? Please could you share.
-
Schedule Job Manager in OTBI to export the report output to Object Storage (OCI)Content Is there a way to export an OTBI BI publisher report to object storage (OCI) as part of a Job Manager scheduled job? -
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…
-
OTBI analysis timeoutContent Hi, we have a customized OTBI analysis report in sharefolder. Some users could run the report successfully serveral months ago, but recently they can't get the r…
-
API to Manage Objects in BI CatalogSummary API availability to upload or download BI Catalog objectsContent Is there any working example of managing BI Catalog objects in terms of uploading and downloadin…
-
Add a custom calculation columnSummary I want to add a couple of columns into my analysis which contain custom formulasContent Hello, I am sure this is a very simple answer but I was hoping someone wo…
-
query to get ar receipt reversal reason nameContent when i reverse receipt.i entered a reason i need a query to get a reason name
-
get balance for each rowContent invoice amount receipt amount balance 100000 30000 70000 40000 30000 30000 0 how can i get balance value using bi ?
-
General Ledger - Balance Real Time measures are nullSummary when using General Ledger - Balance Real Time OTBI subject area all the measures come back nullContent I have users that are trying to create new OTBI reports fr… -
Best Practice for implementing Financials and then HCMContent My organization has decided to implement Oracle ERP Cloud Financials prior to Oracle ERP Cloud HCM. What considerations should be taken to ensure our minimalist …
-
Listing of all FIN reports in foregin languageContent Hi, Can someone let me know where we can find full list of reports ( jobs) available for Financials offering but with translation on Russian Language? When loggi… -
Custom Job running concurrently & seeded program running sequentiallySummary Custom Job running concurrently & seeded program running sequentiallyContent We have developed the custom program basing on seeded program. Where we noticed cust… -
ERP Cloud DR(Disaster Recovery) specificationContent Hi, Experts, Currently, we are discussing about DR operation of ERP Cloud with our clients. As a preliminary investigation, we read up note:SaaS Engineering Info…
-
How to get the back dated(History Record) data using OTBI Real Time Subject Area for Finance Module.Content Hi All, Good Day !!! Can any one help me how to get back dated(History Record) data using OTBI Real Time Subject Area to create report like Aging Report etc., Re…
-
Warning for payment with 0 amountSummary Warning for payment with 0 amountContent Sometimes we need to adjust the invoice amount by creating a debit memo and after that make payment for these 2 transact…User_2025-02-10-22-13-59-726 49 views 2 comments 1 point Most recent by User_2025-02-10-22-13-59-726
-
Fiscal Year format has commaSummary Is there anyway to change the default format of Fiscal Year in OTBI to remove the ','Content While in OTBI it appears that all of the finical subject areas that …
-
Creating new Employee report with Expense Account InformationSummary What is the field and record to pull in the Employee Expense Account InformationContent We are building a new employee report and have a requirement to add the '… -
Explore the VBA code of ADF SpreadsheetSummary Explore the VBA code of ADF SpreadsheetContent I want to explore the VBA code of the ADF Spreadsheet. is there generic password for that ? -
How to create a Batch name from BIP report.Summary How to create a Batch name from BIP report.Content All, any examples on how to create a Batch name from the BIP report. I think we can do it using an eText templ…
-
Not-for-Profit Statement of ActivitiesSummary Seeking sample Statement of ActivitiesContent Statement of Activities quantifying revenue and expenses of our not-for-profit entity for a reporting period. The n…User_2025-02-11-03-09-13-126 23 views 0 comments 1 point Most recent by User_2025-02-11-03-09-13-126