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
-
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 … -
Smart View Error - "XML Load Error: 'End tag 'head' does not match the start tag 'meta'Summary Smart View Error - "XML Load Error: 'End tag 'head' does not match the start tag 'meta'Content We just started receiving this error on Saturday after 20D was app…
-
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…
-
How to remove/supress subtotal lines in SmartviewSummary Is it possible when drilling down in a Smartview report to 'remove subtotal rows' in the same was as you can with a standard pivot table output?
-
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…
-
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…
-
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…
-
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…
-
What role or access need to provide for showing all submission option in spreadsheet Journal creatioContent What role or access need to provide for showing all submission option in spreadsheet Journal creation. We have a custom role and when submitting journal from spr…
-
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 …
-
Audit Report for OTBI Reports Metadata ChangesSummary Audit Report for OTBI Reports Metadata ChangesContent Hi Gurus, It is year end Audit time and we need some information on the changes made to "Key Reports" durin… -
Request Guidance of Changes Oracle makes to seeded Oracle ReportsSummary Does Oracle have a list of changes they made to Oracle Reports on a Quarterly basis?Content During our Quarterly Updates Readiness Review process, it would be ve…
-
Smartview - reversing the signs so revenue presents as positiveSummary Wanting to pull in revenue as a positive valueContent We are new to Oracle and Smartview, and are learning how to use the tool. We have not determined how to bri…
-
How to get Request Id at runtime for the BI-Publisher ReportSummary How to get Request Id at runtime for the BI-Publisher ReportContent In the custom reports, the business users are expecting to capture the Request-Id/Report-Job-…
-
How can i find BI Tables easily?Summary How can i find BI Tables easily?Content How can I find BI tables where specific data is stored, I spend so many times trying to map and also get a table I want f… -
Audit Policy Performance ImplicationsSummary Will enabling Audit have any performance or other implications?Content We are looking to define Audit Configuration for Business Object Attributes. I am wonderin… -
FRS search members by description starting with, Ending with, ContainsSummary FRS search members by description starting with, Ending with, ContainsContent Our client doesnot have specific values for each row. Instead they have conditions …
-
generating more than 75k record in OTBISummary generating more than 75k record in OTBIContent Is it possible to exceed the limit of 75k records in OTBI by importing an OTBI report as a data model in BI? Versi…
-
Access DBCS tables in SaaS BI Publisher ReportsSummary Is it possible to access DBCS tables while creating BI publisher reports in SaaSContent Hello We have a requirement to build some BIP reports out of the tables t…
-
How to Display Date and Time as per User Local Settings in Excel TemplateSummary We need to display the Date and Time as per the User Regional Settings. We need to know how to use the XDODEFDATE and XDODEFTIME in Excel TemplateContent Our Req…
-
BI Publisher Procedure call that populate temp tableSummary BI Publisher Procedure call that populate temp tableContent Is it possible to create BI Publisher Procedure call that run one of the customeraging Requests that … -
How to Change view PO PDF standard report to customizedContent Dear , We need to change PDF view standard report to our customized report in which i read the Oracle Doc ID 2302842.1. But issue is when wo go to oracle standar… -
How to fetch invoice_no and invoice_date from wsh_ tablesSummary Need to fetch invoice_no and invoice_date from wsh_ tablesContent Need to fetch invoice_no and invoice_date from wsh_ tables or from doo_ tables