Fusion Financial reporting
Discussion List
-
What are the tables or SQL query to fetch ESS job name, Report name, Report path detailsHi Team, I have requirement to develop custom SQL query to fetch details like All ESS Job names, Display names, Report names, Report paths etc. I have used tables like E…anusha chunduru 3.4K views 6 comments 1 point Most recent by User_S6U3H Reporting and Analytics for ERP -
Drill Down To Fusion Financial Applications from OTBI ERP ReportsSummary The purpose of this White Paper is to demonstrate how users can drill from Oracle Transactional Business Intelligence (OTBI) adhoc reports to transaction details…Veronica Dumitriu 9.1K views 168 comments 46 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for ERP -
Automatically create a prepayment invoice from POSummary: Is there a way to automate the creation of prepayment invoices in AP from a PO? We would like to be able to create a PO and somehow specify the PO is expected t…AndresGlz2109 241 views 4 comments 0 points Most recent by AndresGlz2109 Reporting and Analytics for ERP -
Ability to get the Payment Approval Rule details defined on BPM by queries in Reports and AnalyticsIdea Number: 707234…Thomas De Leeuw 13 views 2 comments 0 points Most recent by Thomas De Leeuw Reporting and Analytics for ERP
-
How do I get my OTBI Income Statement to default to the current GL period?Summary: My OTBI Income Statement is defaulted to January 2022, but we would like it to dynamically open to the current GL period. Content (please ensure you mask any co…
-
IC and GL Reports that capture DFF detailsDo we have any seeded report that can capture the details of DFFs configured in the following tables: IC- FUN_DIST_LINES GL- GL_JE_LINES If none, could you please sugges…
-
BPM Workflow Invoice Approval - Standard ReportHi, Scenario: During the workflow of invoice approval, when one of the approver has delegated the authority to someone else in organization Ask: Business would like to k…SaurabhSinghal26 81 views 1 comment 0 points Most recent by Umasankar Payables, Payments & Cash Management
-
Which Table Stores the GL Overridden Natural Account Code in Oracle Fusion?Summary: Hello everyone, I am currently working on a data model in Oracle Fusion and need to identify which table stores the value for the GL overridden natural account … -
How to add the segments of the Chart of Accounts to the OTBI Subject AreaSummary: Unable to find the 4th and 5th segments of the Chart of Accounts in the General Ledger or Budgetary Control subject areas Content (required): Our COA has 5 segm…Julia Looi 401 views 5 comments 1 point Most recent by Marynol Algura-Oracle Reporting and Analytics for ERP -
Need a query to get total of Current Cost, Accumulated Depreciation, Impairment for asset categoriesContent Hi all, Can someone give me a query that gives a total of : * Current Cost * Accumulated Depreciation * Impairment per asset categories in Fixed Assets Module. R…Sushan Peiris 1.1K views 2 comments 1 point Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
Is there a way to custom the buckets of Aging 7 Buckets?Summary: I need to change the period of the buckets. Content (please ensure you mask any confidential information): Is there a way to create a customized report based on… -
Payables Invoices - Transactions Real Time - does not return all invoicesSummary: Payables Invoices - Transactions Real Time - does not return all invoices Content (please ensure you mask any confidential information): Hi - if I run this SQL …
-
Payables Invoices by Cost Centre/SupplierSummary Dashboard & reports showing summary of AP invoice value by period/cost centre/supplier, with drill-down to invoice detailsContent Please see attached documents f…Andy Gough 1K views 12 comments 13 points Most recent by Samuel Bassey Reporting and Analytics for ERP -
Is there a mapping document from eBS to Fusion CloudSummary: We are moving one of existing eBS customer to Cloud and while moving existing reports for customer, we are facing many challenges to map eBS fields to Fusion Cl…Sanjaykuamar Varma-Oracle 1.2K views 8 comments 0 points Most recent by MangalThorat Reporting and Analytics for ERP -
How to extract attachments for Journals and Payables Invoices for a given period of timeOur company is being sold and we need an extract of journal and payables invoice attachments for a given period of time for audit purposes. We would like the attachment …
-
Charts on a report positioning when exporting to excelIs there any way to have charts on a report created on Financial Reporting Studio be positioned in the same side by side structure when exporting the report to excel?
-
In what subject area can i find the details of a Return Lines (Return to Supplier)Summary: Hi In what subject area can i find the details of a Return Lines (Return to Supplier), specifically the details of the receipt number, RMA, Document Number (PO)…Johann Christian 34 views 5 comments 1 point Most recent by Becca Edwards Reporting and Analytics for ERP
-
How to create a parent schedule for multiple schedule of one BI Publisher reportClient has created multiple schedule of one one BI Publisher report using different parameters ex-cost centres and different recipient in each schedule. Is it possible t…Saikat1 21 views 2 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Oracle Fusion BI Publisher Custom Physical SQL SecuritySummary Oracle Fusion BI Publisher Custom SQL - Security ConsiderationsContent Hi, When you create a Business Intelligence Publisher data model with physical SQL, you ha…User_2025-02-05-04-43-06-903 133 views 6 comments 3 points Most recent by Carlos Benassi Reporting and Analytics for ERP -
Customizing the Accrual Reconciliation report to a more usable excel sheetSummary: Business is using the Accrual reconciliation report to reconcile the accrual account with the PO details. Currently business has huge data in this report for ce…
-
How to restrict users from using direct base tables in Data ModelWe have to provide certain users with Create Data Model access in BIP, but need to restrict them to usage of only certain tables or certain data in the tables. Do we hav…
-
Do we really need the ESS Administrator Role to run the Approval Groups Report ESS Job?Summary: We figured out two levels of security are required to run the "Approval Groups Report": Enable the user to Submit the Scheduled Process /oracle/apps/ess/financi…Thomas De Leeuw 52 views 2 comments 1 point Most recent by Thomas De Leeuw Reporting and Analytics for ERP
-
Restricting Data retrieved by BIP report queryHi, We have requirement to restrict the data returned by BIP query based on Data Access Security setup on ERP Cloud. We find that we have concept of Secured List Views (…AbdulBasith 32 views 3 comments 1 point Most recent by James McBride Reporting and Analytics for ERP
-
BIP internal bank account table?Hi Guys When I search online I get told to use view CE_INTERNAL_BANK_ACCOUNTS_V to lookup field INTERNAL_BANK_ACCOUNT_ID out of table iby_pay_service_requests. However w…
-
How to unmerge the cells when the rtf template is exported to Excel ?Summary: We have a report requirement that rtf template is exported as an excel output report, but the issues are the rows are getting merged in excel Output. Content (r…Abhhishek42 455 views 7 comments 0 points Most recent by Ralph Aldrich Magno Reporting and Analytics for ERP
-
PO Column for Receipt Accounting Source in Oracle Fusion. Which role or privilege needs to be added?Summary: PO Column for Receipt Accounting Source in Custom Account Analysis Report in Oracle Fusion. Which role or privilege needs to be added? Content (please ensure yo…
-
Why do scheduled reports with a daily frequency cannot be received on a weekend (Saturday & Sunday)?Summary: The business users created a schedule for the daily backup of a report, but the backup mail is being received only from Monday to Friday. Mail for Saturday and …Czarina Morales 21 views 3 comments 1 point Most recent by Czarina Morales Reporting and Analytics for ERP
-
How can I configure "All" prompts in BI PublisherSummary: Content (please ensure you mask any confidential information): I have a report with some parameters, I would like them to come with the default value "All" and,…
-
How to add 2 columns in group by in Excel templateSummary: Need to add 2 columns in Group by expression in EXCEL template Content (please ensure you mask any confidential information): below condition is working for 1 c…Thanigainathan R 143 views 2 comments 0 points Most recent by User_6NK6Y Reporting and Analytics for ERP