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
-
Trial Balance Report in JapaneseSummary Looking for Trial Balance Report in Japanese language. How to generate this and what privileges are needed for the user and steps to be followed?Version 20AUser_2025-02-07-02-12-25-586 22 views 0 comments 0 points Most recent by User_2025-02-07-02-12-25-586 -
List of ESS Jobs in Oracle FusionSummary List of ESS Jobs in Oracle FusionContent Can someone point me in the direction as to where I can get a list of all Jobs by Product Version Oracle Fusion Release … -
"Insert text item" field is extending up to end of frameSummary "Insert text item" field is extending up to end of frameContent Hi I created a BI Report in Cloud. In the heading section of the report, need to display the para…
-
Join Subledger and Journal lineContent Good day I would like to join two datamarts SUBLEDGERJOURNALDISTRIBUTIONPVO and JOURNALLINEPVO, do you know if this is possible? or do I need another datamart to…
-
User_2025-02-04-14-03-09-386 24 views 0 comments 0 points Most recent by User_2025-02-04-14-03-09-386
-
BI Query to get Difference between Dates in numeric formatSummary We have requirement to get the Average time required to complete particular ESS Job in Minutes or Seconds.Content Here are more details - We need to calculate th…
-
Need Sample KPI and KPI WatchlistsSummary Need Sample KPI and KPI WatchlistsContent Hi All, We need sample KPI and KPI Watchlists created for ERP modules. Thanks in advance. Regards Siva. Version 20A -
Expense -Audit Email Notification TemplateSummary Expense -Audit Email Notification TemplateContent Hi All, We currently have a requirement for amending the email notification template for Fusion Expense, Audit.…
-
Delaying the Execution of Dashboard Pages - change the default message.Summary Delaying the Execution of Dashboard Pages - change the default message.Content Hi, We have enabled the delay in execution of the Dashboard, following this https:…
-
Accessing External DataSource via Fusion BIP reportsSummary We have a requirement to build a report the data of which will be in oracle cloud as well as in external database.Content Hi Guru's We have a requirement to buil…
-
Cover Page in Report BookSummary I have a Report Book with a title page - the title page will only render if the book is run from EPMContent I have a report book with a cover page. If I run the …User_2025-02-06-10-37-19-523 20 views 0 comments 0 points Most recent by User_2025-02-06-10-37-19-523
-
FRS - Does RelativeMember Function work on Prompted AccountingPeriod?Summary FRS - Issue with period-to-period comparison on prompted valuesContent I am creating a Period-to-Period Financial comparison report, where Accounting Period need…
-
OTBI Report with Payments Disbursements and Invoices with Invoice distributionSummary OTBI Report with Payments Disbursements and Invoices with Invoice distributionContent I am trying to create a report that shows only the invoice expense account …
-
ERP – How Oracle Modernized Finance with Oracle ERP Cloud, 8 April 2020, 9 a.m. PT - Submit QuestionContent Submit your questions for the ERP – How Oracle Modernized Finance with Oracle ERP Cloud session to have them answered during the live event. Post your questions …
-
Need OTBI Analysis/Logical SQL behind Standard InfoletsSummary Need OTBI Analysis/Logical SQL behind Standard InfoletsContent Dear All, How to get the OTBI Analysis/Logical SQL behind the Standard Infolets Ex:Invoices Home …
-
SQL Query or table for User CategorySummary SQL Query or table for User CategoryContent I need to create a query that extracts the information of the user and the user category it's under
-
DFF Value (Change/Update) reflection in OTBI Subject AreaSummary I have a DFF with current value as A and OTBI shows that DFF value as A... Now I change the DFF field value to B Does the Value B automatically gets reflected in…
-
452 4.4.5 Insufficient disk space; try again laterSummary Failed Delivery of ReportsContent Does anyone have this error message for daily scheduled reports? I have a report that runs every morning and is sent to my emai… -
Multiple selection for Enterprise Scheduler JobContent Hello, Is it possible to do a multiple selection for a parameter in Enterprise Scheduler Job ? We don't have seen option to do this, and we can't write like this…
-
BI Reports Usage AnalyticsContent Hello, Is there a way we can see the last time a specific BI report has been accessed by any user? Thank you Version 19DUser_2025-02-05-02-16-41-526 60 views 3 comments 0 points Most recent by User_2025-02-05-22-11-22-331
-
Unable to find Payables Invoices - Line Distribution for OTBISummary Report for AP invoice line - Account distributionContent I am writing a report in OTBI and I cannot find the Invoice Lines Distribution. The subject area is : Pa…
-
Payables invoices consolidated to 1 currency in OTBISummary Write report for AP Invoices from different BUContent We have many business units in our system and each of them are having different ledger currency. We would l…
-
OTBI Analysis - Profile Option ValueSummary Is it possible to access profile option value in OTBI Analysis?Content We are creating a custom profile and setting the values at user level. Is it possible to a…
-
HZ Classification ReferenceContent Hi Team, I'm looking for Classification Orginal System Referenc, If I join OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS and OWNER_TABLE_ID from HZ_ORIG_SYS_REFERENCES…
-
Dashboard or report to show all changes/updates to reports/data models for auditingSummary Hi we need a report that will show if any bi reports or data models for BI have been updated in the last 90 days for audit purposes?
-
Employee corporate card or cash Expense OTBI AnalysisSummary Employee corporate card or cash Expense OTBI AnalysisContent I am in the process of creating an employee expense OTBI analysis in order to see all corporate card…
-
Accounts Receivables Month end closing in Cloud 20 ASummary Accounts Receivables Month end closing in Cloud 20 AContent We want to close AR month end closing in Cloud 20A. I developed a query from AR tables withe invoice …
-
Issue with finds captures authorization custom layoutSummary Length() not returning correct value when used with sum()Content Hi Experts, We are in oracle fusion 19D. We are using Oracle Business Intelligence 11.1.1.9.0 I …User_2025-01-30-00-35-05-558 18 views 0 comments 0 points Most recent by User_2025-01-30-00-35-05-558
-
Tables to query files imported to ERPSummary We want to create a report that list the files imported to the ERP from external systems for reconciliation purposes.Content Hello evryone, Anyone can hep me to …
-
Modifying Configurable Expense Report TemplateSummary Access in current user detailsContent Hi,We want to access current logged in user details in configurable expense report template,1. Is it similar to how do it i…