Reports
Discussion List
-
Updating KFF tree versions causes OTBI Analyses to fail when created in “General Ledger – Balances RSummary We are testing changes to the KFF segment values and hierarchies (aka trees). All seems fine with all changes, and GL OTBI reporting until ‘something’ happens an… -
Report and Dashboard prompts on multi tab DashboardSummary Prompts not clearing and show selections from other report promptsContent I have a multi tab Dashboard with two to three reports on each tab. Each report has it'…User_2025-01-28-20-19-02-475 63 views 1 comment 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for ERP -
How do we distinguish between custom reports and standard reports?Summary We want to know how many custom reports are created in reporting center. How do we distinguish between custom reports and standard reports?Version Oracle Fusion …Patrick Chrabieh 224 views 2 comments 7 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
If we need to run a report or a query on all the profile options currently set for our client in FusSummary If we need to run a report or a query on all the profile options currently set for our client in Fusion, is there any way?Version 21AUser_2025-02-08-12-06-31-659 38 views 1 comment 1 point Most recent by OmkarAdkar Reporting and Analytics for ERP -
Query to fetch sum of debit memos and credit memos for an original invoiceSummary Am looking for a query to get sum of credit memos linked to original invoice ie Original invoice -HCS1 Credit memo-HCS2 as shown in below screenshots.Content I w…Sankeerthana Anumasula-Oracle 920 views 2 comments 1 point Most recent by Sankeerthana Anumasula-Oracle Reporting and Analytics for ERP -
BI Publisher report should send email with Digital signatures in email body.Summary We have a business requirement to digitally sign the email while transmitting transaction prints to customers. Basically, the email body needs to have the digita…User_85V95 42 views 4 comments 2 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
Access to Fusion Accounting Hub Reporting Cloud Service ( FAHRCS).Content Hi all, Please clarify whether the "General Accountant" role has access to Fusion Accounting Hub Reporting Cloud Service ( FAHRCS). Best Regards, VipushaVipusha Chandrakumaran 73 views 1 comment 1 point Most recent by Anca A-Oracle Reporting and Analytics for ERP -
Account Segment Group ObjectsContent Our team is looking to group together certain accounting segments for use in some of their reporting and imports. They currently have specific payroll object gro… -
BI REST APIsSummary BI REST APIsContent Hi All, Has anyone tried using the REST APIs to invoke a BI Report? I am having a hard time to get it working. If you have sample code and ca…Arun Raj 95 views 1 comment 0 points Most recent by Suresh Pallapothu Reporting and Analytics for ERP -
How to access Custom ESS Job SetContent Business Users are not able to access the Custom ESS Job Set. We checked the below Oracle notes, but nothing works. How to Grant Execution Privileges to ESS Cust… -
Configuring Key Flexfield Segments in Oracle Financials Cloud to leverage OTBI for ad-hoc analysesSummary Configuration Steps to enable OTBI reporting of Key Flexfields (KFF's) in GL, Budgetary Control and Fixed Assets (Rel 11)Content To report on Key Flexfield Segme…Anand DN-Oracle 1.7K views 8 comments 12 points Most recent by Chris Lynch - AST Reporting and Analytics for ERP -
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… -
Fixed Asset Report- OTBISummary Fixed Asset Report- OTBIContent I created a Fixed Asset OTBI report. The report is working well only recently it starts dropping data. its only reflecting 25000 … -
Missing account coding data for Invoices in Workflow tables in PRODContent Hello, We have a custom BI report that tracks the Account coding details for AP Invoices. We are using the workflow tables to get these details. Per my understan…Shruthi Ramesh 61 views 3 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP -
Bursting A Report With SubTemplatesSummary How to burst a report using a sub template.Content Hi Experts, We have a custom report which uses a sub-template. The report also uses bursting to email. But the… -
OTBI report - Issue with Expense Transactions Real Time subject areaSummary OTBI report using this subject area no longer shows data from prior assignmentsContent We have an SR for this issue but I'm wondering if anyone else has noticed … -
ExternalReportWSSService sample payload to pass template nameSummary ExternalReportWSSService sample payload to pass template nameContent Hi, Can we pass report template name to ExternalReportWSSService SOAP service which triggers…Vinod Kumar Mohanraj 391 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP -
OTBI Analysis: Using TIMESTAMPADD to derive last day of the month based on Period Name in Subject ArContent Hello There, I have an OTBI analysis for Subject Area: "General Ledger - Balances Real Time". The analysis has a column "Time"."Accounting Period Name" OR "Time"… -
Report results pull in journals 1 hour prior to parametersSummary User selects date greater than 3/10/2021 at 12PM, yet the report results is pulling in journals with a timestamp 1 hour prior to set parameterContent User select…User_2025-02-05-22-11-22-331 28 views 1 comment 1 point Most recent by User_2025-02-05-22-11-22-331 Reporting and Analytics for ERP -
Table to get BI Report Template and Data Model DetailsSummary Table to get BI Report Template and Data Model DetailsContent Hello, In EBS, we had XDO tables which stored BI Report and Data Definition details. Do we have any…Vinay Gharge 1.1K views 3 comments 2 points Most recent by SimonTomey Reporting and Analytics for ERP -
How to use Flexfield feature at BIP data model?Content Hi, Are there any document about BIP data model flexfield feature? I hope the feature make me easy to query AFF info when I create custome BIP report. ThanksTsubasa Kokubu-Oracle 56 views 4 comments 2 points Most recent by Anil Kola-Oracle Reporting and Analytics for ERP -
Change ESS Job Description while submitting it from BIPSummary Change ESS Job Description while submitting it from BIPContent In Cloud, we can submit the ESS Job from BIP using "ESS_RUNTIME.set_submit_args" procedure. Is the…Vinay Gharge 40 views 0 comments 1 point Most recent by Vinay Gharge Reporting and Analytics for ERP -
tables that stores the submission of BI Publisher reports which are not scheduledSummary tables that stores the submission of BI Publisher reports which are not scheduledContent Hello, Are there any tables that stores the submission of BI Publisher r… -
Geography Municipalities ExtractionContent Hello Guys, We need to create a report in order to extract Geography Municipalities data, where could we find this information? Best Regards, GiuseppeGiuseppe Iacono 23 views 0 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for ERP -
Inventory Reconciliation with GL - ReportContent All - I have a requirement to show the Inventory Reconciliation with GL and I see two OOB reports (Costing balances and Inventory Valuation) to satisfy the requi…Hari Thyagaraj 50 views 2 comments 0 points Most recent by Ahmed Eldemerdash Reporting and Analytics for ERP -
OCI – ERP Analytics: What's New And What's Next On The ERP Analytics Roadmap, 27 April 2021, 9 a.m.Content Submit your questions for the OCI – ERP Analytics: What's New And What's Next On The ERP Analytics Roadmap session to have them answered during the live event. P…mauricio -Oracle 31 views 0 comments 2 points Most recent by mauricio -Oracle Reporting and Analytics for ERP -
Customize Print Receivables Transaction for all Invoice TypesSummary Customize Print Receivables Transaction for all Invoice TypesContent Hello, Oracle has provided 4 different templates for 4 Invoice Types: Invoice, Debit Memo, C…Vinay Gharge 404 views 1 comment 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Unsuccessful Login Audit Report & Sign-on Responsibilities Audit ReportSummary Oracle Fusion does have a seeded report/ Bi-report for audit purposes.Content Hi All, We would like to know if there is a fusion seeded report that can give belo…User_2025-02-07-22-21-23-100 73 views 2 comments 2 points Most recent by SimonTomey Reporting and Analytics for ERP -
Joining between database SQL and Excel Data Sources in the Data ModelContent Hi, I hope someone can help me out here. We have created a report where we have defined a data model with a join between an SQL data set and an Excel (xlsx) data… -
find field name behind oracle formSummary find the 'activity class' field in the the AR tablesContent Hello all, Can you please help me with something? I am trying to find out the table behind the Transa…User_2025-02-04-08-34-10-102 50 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP