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
-
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 525 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
-
Procurement – Purchasing Real TimeContent i need from Procurement – Purchasing Real Time item /quantity/unit price/line amount(quantity * unit price)
-
ESS Monitor: Cancelling a scheduled daily processSummary I'm trying to cancel a scheduled daily process, that day gets cancelled, but it keeps all other scheduled daysContent I'm trying to cancel a scheduled daily proc…
-
analysis from (Procurement – Purchasing Real Time) and (Procurement - Procure to Pay Real Time)Content i need to create analysis contain data from 2 subject area Procurement – Purchasing Real Time & Procurement - Procure to Pay Real Time is this available ? if ava…
-
Segment Security in BI ReportSummary Restrict the BI report based on the user logged in and their Natural Account/Department.Content Folks, We have a requirement to restrict the BI report by Segment…
-
Differences between running Reports Online vs Schedule/ESSSummary Can anyone list the differences in terms of restrictions of running Reports Online from BI Catalog vs Schedule / ESS DefinitionContent Hi Team, Our customer is a…
-
create dashboard from supplier trial balance &procure to payContent i need to create a dashboard from subject area supplier trial balance and procure to pay , i created analysis from 2 subject area and put supplier as prompt,i cr…
-
How to fix table position at the bottom of my pageSummary Need to fix table position at the bottom of my last pageContent Hello, I have a requirement to fix a table at the bottom of my last page. I have managed to get t…
-
Capacity of Smartview report breaching 250k lines in ExcelSummary When running a Smartview TB Report, if it is filtered by more than 1 segment Eg, Account then fund, it will not run the query as it brings back > 250k linesConte…
-
Which roles to use to secure custom OTBI ObjectsSummary In Otbi I see job roles, Duty Roles and Privileges what should I use to secure custom content in OTBI catalogContent All, When setting up custom folders in OTBI …
-
OTBI Report Suppress option and excel filters issueSummary When the columns are merged in suppress mode, Filters don't work properly in excelContent Hi, We created an OTBI report with suppress checkbox enabled for all th…
-
Is there a way to see the date a Project Forecast was created?Summary Is there a way to see the date a Project Forecast was created?Content I'm trying to find project forecasts created between a specific date range regardless of th…