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 ESS job not visible to all EmployeesContent Hello, We have created a custom ESS Job , but its not visible to all employees. We need it to be visible for all employees. We have referred the following docume… -
Is it possible to add bursting to a seeded Oracle Report?Summary: Hi. I want to ask if it is possible to add a bursting to a seeded Oracle report so that it would be sent to multiple emails? Currently, no bursting code is in t… -
Adding Distribution Information to Payables Invoice InquiryYou can extend pages with custom OTBI reports, for example with budgetary control charge account and projects information is useful when viewing invoices. The Embedded I… -
Unable to insert fields using BI Publisher add in for MS WordSummary: Hi Experts I have installed BI publisher add in for MS word but the menu looks some different and also clicking on insert field does nothing (i have loaded samp… -
How to get data for Audit Reasons column in OTBI like the Expense Auditor Dashboard ?Summary: We are working on a custom dashboard for Expense auditors and one of the fields requested in 'Audit Reasons'. The subject area 'Expense- Expense Transactions Re… -
Smartview Essbase Error [1020098]: Duplicate name found in Grid, unable to resolve.Summary: I get the following Smartview error in report that used to work fine, adjusting the Account dimension values fails to resolve the issue, Essbase Error [1020098]… -
How to customise Requisition Approval E-Mail ReportSummary: We customized the “Requisition Approval E-Mail Report” to display the supplier name in the purchase requisition approval email and in the notification content. … -
OTBi for subject Payables Invoices>Transactions Real time>Distribution not showing correct AmountSummary: We are building OTBi report for Payables Invoices - Transactions Real time->Distributions->Invoice Distributions->Invoice Distribution Amount. In this when we a…
-
Requisition Approval E-Mail Report Template changes is not getting reflected in output file.Summary: I have customized the seeded report named "Requisition Approval E-Mail Report" but the changes is not getting reflected in the notification. It is taking the la…
-
Bulk report to identify users and roles with access to custom BI Publisher reports.We have over 100+ custom BI Publisher reports across different folders under /Custom . We need an audit extract showing each report’s catalog path, directly assigned and…
-
BICC - Custom offerings migration Import / ExportSummary Dears, We created custom offerings and added PVOs in that custom offerings. BICC Job is created and the source is the PVOs with in that custom offerings. Now the…
-
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
-
Budget balances not available in General Ledger subject areasSummary Can we query budget balances in General Ledger subject areas?Content Budget balances not available in General Ledger subject areas like 'General Ledger - Balance… -
Redwood Plan for Oracle Cloud ERPSummary: I haven't found clear discussion on how the Redwood would affect Oracle Cloud ERP. I see documentations and notices for EPM, HCM, and SCM, but I'm unclear on wh…
-
Job Set in Cloud Financials, how to copy report parameter values from one report to the next report?Summary: We defined a custom Job Set for two Cloud Assets reports, Asset Additions Report FAS420 and Journal Entry Reserve Ledger Report FAS400. When running the job set…
-
The expiry period for Email NotificationsSummary: Hi, I would like to understand the expiry period for email notifications received for approval requests in Oracle Fusion. When users receive an approval email, …
-
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS…
-
line managers are unable to view any data from my team - team skills centerSummary: line managers are unable to view any data from my team - team skills center although one of his directs has skills data be he is even unable to view his directs…
-
OTBI Agent - Invoke an HTTP RequestSummary: While invoking an HTTP Request as an Action from Agent, receiving below error in Fusion ERP Cloud. Could you please provide steps on how to resolve this in Fusi… -
Is event organization missing from subject area Project Billing - Event Real Time??I can't find it in the list of fields available, but it seems a bit odd for the event organisation to be missing. It also seems to be unavailable to add to View Columns …
-
what is column for Taxpayer Identification Number (TIN) for customers in OracleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Looking for PO Receipt Number and related data in OTBISummary Cannot find PO Receipt Number, Receipt Date and related date in OTBI Subject Area: Procurement: Procure to Pay Real TimeContent Cannot find PO Receipt Number, Re…
-
What are the differences between Enterprise Set and Common Set?Summary: What are the differences between Enterprise Set and Common Set? Content (required): What are the differences between Enterprise Set and Common Set? Version (inc…
-
Replicating a few dozen Fusion tables to ADB for heavy reporting: what worked and what brokeThere was an error rendering this rich post.
-
How to customize Subledger Period Close Exception ReportSummary: How to customize Sub-ledger Period Close Exception Report Content (required): Ledger Set Parameter to be added to the report. when i'm trying to edit datamodel,…
-
Understanding the 'Disallow Previous Password' in Oracle fusion ERP password policy setupSummary: We are enabling the password policy in our system and needed to understand below regarding the field 'Disallow Previous Password' in password policy setup: How …
-
sql query to fetch bank account details that are linked to supplier addressSummary: Hi all, I would require an sql query to fetch bank account details that are linked to supplier address levle Content (please ensure you mask any confidential in…
-
Need Lease Accounting White Paper and DocumentationSummary: Hi Team, could you please share the latest Lease Accounting white paper for Oracle Fusion Cloud or guide me to the appropriate documentation? Your assistance wo…
-
How to create a custom table in Oracle fusion SAASSummary: How to create a custom table in Oracle fusion SAAS Content (please ensure you mask any confidential information): How to create a custom table in Oracle fusion … -
ERP Finance: Do we have any subject area that represents the data in XLA_ACCOUNTING_ERRORS tableSummary: We would like to understand is there any subject area that showcases the create accounting warnings/errors, majorly looking for XLA_ACCOUNTING_ERRRORS. MESSAGE_…