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
-
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… -
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… -
OTBI Administrations security manage privileges changes impact of upgradesSummary Are changes to OTBI Administrations security manage privileges need to be reapplied after upgradesContent We would like to make some additional features of OTBI … -
Reporting from both Oracle ERP Cloud and PaaSSummary How to build report using data from both Oracle ERP Cloud and PaaSContent How to build a report using data from both Oracle ERP Cloud and PaaS? What are the vari… -
OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumenSummary OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumentContent Hi, We got to see that PO Communication date to supp… -
How to restrict Audit Reports on basis of AORSummary How to restrict Audit Reports on basis of AORContent Hi All, I have a requirement to restrict data access on the output of Audit reports via Navigator - Tools - …
-
How to create custom OTBI Subject Areas in Oracle CloudSummary How to create custom OTBI Subject Areas in Oracle CloudContent Hi Experts, My client is Oracle cloud 20 C. My client have non oracle application that contain pro…
-
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
-
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 ? -
OTBI AP invoices detailsSummary OTBI AP invoices detailsContent I created a report for AP unpaid invoices my question is how I can make a hyperlink to the invoice number to open the invoice dir…User_2025-02-10-22-13-59-726 66 views 2 comments 0 points Most recent by User_2025-02-10-22-13-59-726
-
How to export a report to a CSV format?Content Hi team, I create a a simple table format data set, and create a simple layout by this data set. I'd like to view this report on CSV format, but the result does …
-
Using Task Number instead of Task IDSummary I want to use Task Number as a Prompt but when i am searching with task number. system search with task IDContent Hi, I am using Task Number value in a Prompt. M…
-
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 …
-
Remove last page and logoContent Hi, In the AR invoice report which is run using Print Receivables Transaction the report runs for 132 pages everything is fine but found that it is printing last… -
BIP report needs to pick transactoions from the last successful runSummary BIP report needs to pick transactoions from the last successful runContent All, How to incorporate logic for a BIP report which needs to pick transactions from t…
-
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 '… -
in gl how i get account balance for specific dayContent if i want to create a report from gl to get account balance for specific day and get balance before this day as open balance can i do it with financial reporting…
-
sql to get po number & receipt number from glContent if i create a report in gl to get each journal, if journal get from AP i need purchase order number and receipt number. i need a sql statement .
-
Limitations of OTBI reportsContent Can someone please share the limitations on OTBI reporting compared to BI reporting. I'll inputs regarding the performance, number of records/columns that can be…User_2025-02-08-08-48-00-058 516 views 5 comments 0 points Most recent by User_2025-02-08-08-48-00-058
-
order management (order type table)Content i need to know table of order type in order management
-
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…
-
RTF Template : Hide Row based on SUM() after complex RegroupingSummary Has anyone tried to Hide a row after regrouping the data and the conditions should be based on the SUM() of a column obtained after groupingContent The XML data …
-
action link & agentContent in OTBI i need an example for action link. and another example agent.
-
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 0 points Most recent by User_2025-02-11-03-09-13-126
-
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…
-
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 …
-
OTBI GL Subject Area : 'General Ledger - Journal Real Time'Summary OTBI GL Subject Area : 'General Ledger - Journal Real Time'Content We are developing Analysis reports relating to Cloud General Ledger in Oracle Transaction Busi…
-
OTBI Reports MigrationSummary OTBI Reports Migration StrategyContent Hi, Do we have any DevOps approach in migrating OTBI Reports like catalog,datamodel and template from one environment to t… -
How to restrict Data Model options to avoid users to access directly to the tables (SQL Query)?Summary Power users and contracts need to create data models based on BI Analysis, but this will also give them access to run SQL Queries. We want to restrict SQL Query … -
create analysis (item/on hand quantity/item cost )Content i need to create analysis item/on hand quantity/item cost/quantity*item cost