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
-
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 40 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 19 views 0 comments 1 point Most recent by User_2025-02-11-03-09-13-126 -
What is best practice for Functional Designs for OTBI Reports for support purposesSummary What design documents if any are you creating for OTBI reports created by power users for support purposesContent We are in the middle of a cloud implementation … -
Person data reporting with Financial only implementationSummary We need to do Person data reporting can we use Workforce Management - Person Real Time OTBI subject area on a finance only implementationContent We are currently… -
User Interface Across the Financial ModulesSummary Can anyone confirm if there are plans to update the User Interface in the Financial Modules?Content Our customer has just moved to the Responsive UI for HCM and … -
create analysis (item/on hand quantity/item cost )Content i need to create analysis item/on hand quantity/item cost/quantity*item cost -
How to use Validation type "View Object" in the valuesets?Summary How to use Validation type "View Object" in the valuesets?Content Hi Experts, I am trying to understand how to use the validation type with "View Object" in the … -
General Ledger - Balances Real Time Subject Area: not returning Beginning and Ending BalanceSummary General Ledger - Balances Real Time Subject Area: not returning Beginning and Ending BalanceContent I am trying to create an analysis based on General Ledger - B… -
Schedule BIP report only when it has DataSummary Schedule BIP report only when it has DataContent We have one requirement for BIP report where we have schedule BIP report daily. so we need that if report data i… -
Financial ReportsSummary Balance Sheet and Income Statement ReportsContent Hello All, Are there the following seeded reports in Oracle? * Balance Sheet * Income Statements * Cash Flow I …