Reports
Discussion List
-
Seeking Assistance Querying for Basic Transactional MetricsSummary How to get counts of journal lines, invoices, and payments per month?Content I'm hoping someone can give me a head start on how to query for the following transa… -
Required User Input OTBI Prompt - Not throwing error if input value is not selectedSummary Required User Input OTBI Prompt - Not throwing error if input value is not selectedContent Required User Input OTBI Prompt - Not throwing error if input value is…User_2025-02-03-21-08-45-135 39 views 3 comments 0 points Most recent by User_2025-02-03-21-08-45-135 Reporting and Analytics for ERP -
Output to show the Prompts that the OTBI Results was run for/with Parameters.Summary Output to show the Prompts that the OTBI Results was run for/with Parameters.Content Hi All, Is there any way that we can display the Parameters that we ran for …User_2025-02-03-21-08-45-135 53 views 6 comments 1 point Most recent by User_2025-02-03-21-08-45-135 Reporting and Analytics for ERP
-
New OTBI Help Landing PageSummary Introducing a brand-new OTBI Help Landing PageContent This e-mail is sent by Oracle OTBI product management. Starting with Release 13.18.10, a brand-new OTBI Hel…User720640-Oracle 75 views 0 comments 6 points Most recent by User720640-Oracle Reporting and Analytics for ERP -
Data for disabled segment values no longer included on reportsSummary OTBI and SmartView are not reporting historic balances for end-dated cost centresContent Hi all, We have a situation where we have end-dated a couple of cost cen… -
Custom Infolet Drill to Detail in Context of the record selectedSummary How to link a detailed report to return data in the context of the record clicked in the infoletContent I have created an analytic Supplier Holds and render as a…User_2025-01-28-03-03-10-649 51 views 0 comments 0 points Most recent by User_2025-01-28-03-03-10-649 Reporting and Analytics for ERP
-
Restrict Data in OTBI Based on Specific RoleSummary Is it possible to create role based restrictions on data within OTBI?Content In Cloud ERP, I can create data access sets and value set security rules and assign …Daniel Willmott 231 views 1 comment 1 point Most recent by User_2025-01-29-23-00-32-611 Reporting and Analytics for ERP -
Transaction time in the report and in Payables Application are differentSummary Transaction time in the report and in Payables Application are differentContent Hi all, Developed a report using Payables -transactions real time subject area.In…Dev Thota 56 views 4 comments 0 points Most recent by Manish Pesswani Reporting and Analytics for ERP -
Number of Values to Display in List on ParamtersSummary How to increase number of values range greater then its highest limit 999Content We have a custom report where we we want to find input values greater then 1000 …Bilal Ahmed 43 views 2 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP
-
BI Publisher Best PracticesSummary Looking for a document that contains Best Practices in deploying BI Publisher ReportsContent Hi All, we have created a scheduled BI Publisher Report in our Test …User_2025-01-31-18-04-59-292 100 views 3 comments 0 points Most recent by User_2025-01-31-18-04-59-292 Reporting and Analytics for ERP
-
user role security context security context value reportSummary user role security context security context value reportContent Is there a report where we can retrieve all values as shown in screen shot below?User_2025-01-28-19-49-26-512 250 views 1 comment 1 point Most recent by User_2025-01-30-20-43-00-868 Reporting and Analytics for ERP
-
Need customer master BI reprot query in oracle fusionContent I have a requirement to build custom BI report to display Customer Accounts, Account Site Addresses, and Contacts. Can you please share the query if you have. Th…User_2025-02-03-21-33-20-159 116 views 5 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP
-
Reporting on payment preference dataSummary Reporting on 'Receipt of Payment Notification Preferences' in ReceivablesContent I need to create a new report which pulls data from Manage Customers > Site > Pa… -
Image is blown up when Report is shown via EmailSummary We modified a Layout to add our Organization Logo, however, when its delivered via Email, the image blows up and is too bigContent Hi, we're trying to modify our…User_2025-01-31-18-04-59-292 53 views 1 comment 0 points Most recent by User_2025-01-31-18-04-59-292 Reporting and Analytics for ERP
-
Report Job Hoistory Table nameContent Hi Team, Could you please let me know, whether BI Report job history stores in any table, if so,could you please let me know the table name. Thanks. Uva Version …Uvaraja-Oracle 99 views 4 comments 0 points Most recent by Uvaraja-Oracle Reporting and Analytics for ERP
-
ESS Job Parameter Conditionally RequiredSummary Conditional ParameterContent Good People, Can we make the ESS Job parameter conditionally required ? e.g. I have 2 parameters say parameter P1 & P2 , can I make …Soumya Prakash Parhi 109 views 0 comments 1 point Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
Preparing a Opening Journal in Cloud from last period balances from EBSContent Team, I need help in Preparing an Opening Journal in Cloud, I am using balances from EBS for last period. I am trying to use GL_Balances Table, but I see lot of …User_2025-01-30-21-01-20-715 26 views 0 comments 0 points Most recent by User_2025-01-30-21-01-20-715 Reporting and Analytics for ERP
-
BI Publisher connecting bank account to receiptSummary Need advice on creating a data model for a BI Publisher report on AR receiptsContent I need to create a new BI Publisher data model which returns the bank accoun…
-
Column aggregates without showing measure columnsSummary Column aggregates without showing measure columnsContent Hi All, I have built a report with multiple measures. Is it possible to show only the column level aggre…Ishan B-112616 43 views 0 comments 0 points Most recent by Ishan B-112616 Reporting and Analytics for ERP
-
Trial Balance report ends in error and no report is generatedSummary Trial Balance report ends in error and no report is generatedContent Hi All We regularly run the Trial Balance report for the entire financial year from schedule… -
Report Job History is blank for BI ReportSummary Report Job History is blank for BI ReportContent Hi All, We have created a simple BI Report with one data model. When users are running this report, the activity…
-
Issue with month format to create Trend Analysis Report for Data ProgressionSummary Issue with month format to create Trend Analysis Report for Data ProgressionContent Hi All, We would like to create a dashboard to show data volume progression b…
-
Reporting on descriptive flexfields - BI Enabled checkbox not showingSummary Unable to use descriptive flexfield in OTBI - missing BI Enabled checkboxContent I need to create a new report using the Receivables - Customer Real Time subject…elenorh 183 views 2 comments 0 points Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for ERP
-
Reports Generated from Schedule Processes to be mapped to spring boardSummary Reports Generated from Schedule Processes to be mapped to spring board e.g. GL Accounts AnalysisContent Hi All, Is there a possibility to map reports generated v…Achala Munasinghe 61 views 3 comments 0 points Most recent by User_AEMC1 Reporting and Analytics for ERP -
Default "Account Period Name" value in OTBI Prompt while scheduling AgentsSummary Is there a way to default Period name on the OTBI Prompt while scheduling the Analysis from Agents?Content We have an OTBIE analysis "AP Transaction Report" that…GopiKAutomus 398 views 5 comments 0 points Most recent by User_AEMC1 Reporting and Analytics for ERP -
Report that shows Payables Invoice Approver name, Initiated by , Validated by valuesSummary We are trying to build a report in Payables that shows Invoice details along with Approver name, Initiated by, Validated by ValuesContent We are trying to build …
-
Add OTBI reports to Scheduled ProcessesSummary How to add OTBI reports to Scheduled ProcessesContent Hi, Can we add OTBI reports to Scheduled Processes rather than access them in Reports and Analytics?Lakmal 239 views 7 comments 1 point Most recent by Achala Munasinghe Reporting and Analytics for ERP -
Period-End Accrual Drill downSummary Period-End Accrual Drill down to Receipt numberContent Dear Masters, Is it possible to drill down period-end accruals from GL to particular receipt number? what …User_2025-01-30-21-01-20-715 68 views 1 comment 0 points Most recent by User_2025-01-30-21-01-20-715 Reporting and Analytics for ERP
-
Custom Data Model - Remittance Advice - Change From Check to Wire Payments?Summary Custom report using SQL data model - How to change from check payments to wire payments?Content We have a custom report for AMEX remittance advice which gives us…
-
GL/SLA Account Analysis Report - Custom Spreadsheet Output FormatSummary Custom BIP template for the Account Analysis Report that displays GL/SLA journal line output in a spreadsheet format for easier searching and filteringContent * …Linda Wong-Oracle 319 views 6 comments 2 points Most recent by User_2025-01-30-21-33-20-426 Reporting and Analytics for ERP