Fusion Financial reporting
Discussion List
-
AR Docket generation - optionsSummary Business is looking to generate an AR Docket - from Oracle fusion - what options, extensions, enhancements are available for the sameContent Business is looking … -
Anyone has AR aging report logic for calculating aging as of a date. We would like to build an AR AgContent Anyone has AR aging report logic for calculating aging as of a date. We would like to build an AR Aging report from scratch but lot of logic is hidden in stored … -
Why can't I see the information for flexfields from subject areas in Results tab?Content Hi, We have Oracle Business Intelligence 11.1.1.9 and Oracle Cloud Application 21B (11.13.21.04.0) We are development an Analysis using Receivables - Bills recei… -
Struggling to Find Expense Report Line DetailsSummary Can't Find Receipt Date and Number of Days in "Expenses - Expense Transactions Real Time"Content We are seeking the following fields for Expense Report Items: -R… -
OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Summary OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Content Hi Is there standard catalog files available for primary statements whic… -
From To Accounting period condition in OTBISummary From To Accounting period condition in OTBIContent Hi all, Is it possible to keep 'From' and 'To' Accounting period as input prompts in PTBI GL/Subledger subject…Vinod Kumar Mohanraj 15 views 1 comment 1 point Most recent by SimonTomey Reporting and Analytics for ERP
-
OTBI Payables Invoices to Subledger joinContent We have a requirement to display Payables Invoices data (Payables Invoices Transactions Real Time) and their corresponding Subledger entries & other Subledger sp…Rajagopalan Rangarajan 27 views 0 comments 3 points Started by Rajagopalan Rangarajan Reporting and Analytics for ERP
-
What Role/Privilege grants access to edit Scheduled Agent "RUN AS" in OTBI?Content Does anyone know what Role/Privilege allows access to update the "Run As" field in a Scheduled Agent for an Analysis in OTBI? I've assigned the following to a te…Mike Burnett 11 views 1 comment 2 points Most recent by Syed Misbauddin-Support-Oracle Reporting and Analytics for ERP -
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…
-
Archive/Unarchive buttons missing in Catalog ReportsSummary Archive/Unarchive buttons missing in Catalog ReportsContent Hi All, Archive/Unarchive buttons missing in Catalog Reports Thanks, Dev Thota. Version 21BDevendra Thota 24 views 1 comment 3 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Oracle Fusion Cloud - SQL script logic to calculate Period to Date (PTD), Quarter to Date (QTD) andSummary We are working on Custom Trial Balance Report development and need logic to calculate PTD, QTD and YTD Balances into Oracle Fusion Cloud.Content Hi Team, We are …
-
Restrict users from sending reports to external email addressesContent Hi, As we know, Oracle allows to include the email address when adding a Destination for a report output in both OTBI and BIP reports. Is there a way to restrict…Madhu Chalamalasetty 30 views 6 comments 1 point Most recent by Madhu Chalamalasetty Reporting and Analytics for ERP -
UK Payslip CustomisationSummary UK Payslip CustomisationContent Hello Experts, Need your help. Can you please help if you have already done UK Payslip Customisation; Like the details of the cus…Bhaskar Konar-83539 53 views 2 comments 0 points Most recent by Bhaskar Konar-83539 Reporting and Analytics for ERP
-
Subledger Period Close Exceptions Report query timeoutSummary SQL query time exceeds the limit (2400 sec). Stopped processing.Content Hi, just wondering if anyone has any experiences with the Subledger Period Close Exceptio…
-
Frequently Changing HierarchiesSummary How to perform GAAP reporting on Legal Entity Rollups in ERP CloudContent All we have a use case, which I don't think is that unique, yet I am struggling with ho… -
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… -
What are the Correct Parameters for OTBI Fusion GL for ESS "Import Oracle Fusion Data Extensions forSummary This ESS request is the very last process in updating KFF OTBI Trees (so we can use OTBI "GL - Balances Real Time"). "All" or (just) "ERP" doesn't work, but "ERP…
-
How to Add the OTBI Dashboard to the Financial Reporting Center?Summary How to Add the OTBI Dashboard to the Financial Reporting Center?Content How to Add the OTBI Dashboard to the Financial Reporting Center? OR If i can make it more…ASHISH GUPTA-269725 26 views 6 comments 2 points Most recent by Raghavan p-Oracle 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 26 views 2 comments 2 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
How To Handle "&" (ampersand) symbol extracted from data using Etext templateContent We have "&" symbol used in Supplier names. Ex: ABC & Co. Oracle seeded report would generate xml data with as below: ABC & Co We are using eText template to disp…User_8AN9P 20 views 4 comments 1 point Most recent by Divya Sidhaiyan 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 20 views 2 comments 1 point Most recent by Sankeerthana Anumasula 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, Vipusha231094 16 views 1 comment 1 point Most recent by Anca Amarghioalei-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… -
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 820 views 8 comments 11 points Most recent by user9170237 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… -
Table to get Task Details from Strategy assigned to customerSummary Table to get Task Details from Strategy assigned to customerContent Hello, We are unable to find the table to get Task Details from Strategy assigned to customer…Vinay Gharge 7 views 1 comment 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
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 12 views 3 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP
-
Need Audit tables list in Oracle cloudSummary Enabled Audit feature for Supplier header and supplier sitesContent Hi, Need help in Audit tables list for Oracle cloud, as per the requirement we enabled the au…
-
OTBI Analysis Subject Area: General Ledger - Balance Real Time "Period Name" range criteria issueContent Hello There, I am using a range critera BETWEEN for a OTBI analysis Subject Area: General Ledger - Balance Real Time column name 'Accounting Period Name' and thi…