Fusion Financial reporting
Discussion List
-
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 83 views 1 comment 0 points Most recent by Umasankar Damarapakam Payables, Payments & Cash Management -
R13 Financials OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Orac…Noelle Bartlam-Oracle 33.3K views 92 comments 55 points Most recent by JL-JL Reporting and Analytics for ERP
-
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 371 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 39 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 25 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 131 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 44 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 35 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 432 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 22 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 132 views 2 comments 0 points Most recent by User_6NK6Y Reporting and Analytics for ERP
-
Inquiry AP ReportSummary: Is there a Payables report that I can run that provides a clean listing of invoices as of a specific date that make up the balances shown on the Payables Trial …
-
Receivables Concatenated Segment is not showing updated account in OTBI report.Summary: Hi, We have an OTBI report using Receivables - Transactions Real Time wherein we have added 'Receivables Concatenated Segment' column but it is showing the Reve…Rahul Kumar Gupta.-Oracle 24 views 0 comments 1 point Started by Rahul Kumar Gupta.-Oracle Receivables & Collections -
Not able to add Budget Values(amount) column in FRS Report.We have an FRS Report for Profit & Loss Account where the accounted values are reflected. We have a requirement to add Budget Values also in the FRS, but we have tried e…Jagjit Singh Arora 34 views 4 comments 0 points Most recent by Jagjit Singh Arora Reporting and Analytics for ERP
-
No Data Found when Other Users run BIPSummary: I created a simple vendor report with BIP. I can run it fine and see the data such as vendor name, number, address, etc. I have another user, Employee B, who on…
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo…SimonTomey 716 views 12 comments 11 points Most recent by Melissa Goodrich Reporting and Analytics for ERP