Fusion Financial reporting
Discussion List
-
Validation of Retained Earnings Transfer Process for Portugal STAT LedgerSummary: We are working on "Create SAFT-PT Audit File for Portugal" We have configured Portugal Statutory Ledger and Data Conversion Level - Journals As part of Business…Kuruva Narasimhulu 13 views 0 comments 0 points Started by Kuruva Narasimhulu Reporting and Analytics for ERP -
Why Selected Accounting period is not showing start period and end periodSummary: We are developing an FRS report and are using a Range prompt for the Accounting Period parameter. We would like to display the selected accounting period range …Mahesh Munagala 60 views 0 comments 0 points Started by Mahesh Munagala Reporting and Analytics for ERP -
custom AI agent to search ar invoices details.Summary: Has anyone Got a custom AI agent to do AR Transaction/invoice Search to work? I can get to work to a point but only brings back info from 2018 thru 2022. It doe… -
There is a need to show GL Account and Description in 2 separate columns in FRS ReportThere is a need to show GL Account and Description in 2 separate columns in FRS Report Is there any way to split Account into Account and Description column in FRS reportLakshmiVanarasi 43 views 2 comments 0 points Most recent by ERP User Reporting and Analytics for ERP -
Advanced CollectionsContent Hello All, Do we have any OTBI subject area which gives data related to Collections. Ex: Collector wise collections. Thanks, NishanthNishanth B Jain 133 views 9 comments 0 points Most recent by Alan S. Reporting and Analytics for ERP -
ESS.REQUEST_HISTORY table state column meaningin which oracle fusion financials, Fusion_ORA_ESS.REQUEST_HISTORY there is a columns named 'State' which shows 12,11,10 values. What is meaning of it. It seems that ESS …Vipul_vipul 10K views 15 comments 1 point Most recent by SUDERSHAN PRASAD TIWARI Reporting and Analytics for ERP -
Financial Reporting Center - Define Tags (GL_FRC_USER_ACCESS_REPORT_TAGS)Summary: Is anyone using the GL_FRC_USER_ACCESS_REPORT_TAGS table in a BI Publisher report? How are tags defined? https://docs.oracle.com/en/cloud/saas/financials/26c/oc…Meredith Bickell 23 views 0 comments 0 points Started by Meredith Bickell Reporting and Analytics for ERP -
FRS Report is opening in multiple tabs for some users and not for others. Is there a specific setup?Hello, We have created a consolidated FRS report for one of our clients and when the user downloads the report, it opens in multiple tabs in excel for one users. For oth…Shriya Srinivasan 73 views 4 comments 0 points Most recent by Rich Merkel General Ledger & Intercompany -
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 42 views 6 comments 1 point Most recent by NathanSuarez Reporting and Analytics for ERP -
Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", neSummary: Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", need to join the subject area to fetch data as there is no com…Prasad Tummalapalli 21 views 0 comments 0 points Started by Prasad Tummalapalli Reporting and Analytics for ERP -
List of FDI seeded ERP groups and users neededSummary: I need below information for FDI, what are the seeded groups & users, will there be any native user and if any service account is required in FDI for integratio… -
How to get the Fiscal year budget balance based on accounting period promptSummary: We have an FRS report requirement to display the fiscal year budget amount based on the accounting period prompt selected by the user. We have a source budget w…Hamsapriya-Oracle 14 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
How to send an ESS job output on email?Summary: Need to send an ESS job output (ex: .pdf) on email, to certain people Content (required): Needed functionality: send ESS job output on email. Tried from: Schedu… -
Table/View for AP Invoice Approval History & Workflow (BPM Flow)We are in the process of creating a customized report to track the complete approval history of AP invoices in Oracle Fusion. The requirement is to fetch details of the …sailesh_cloudare 543 views 4 comments 1 point Most recent by Jayanth Sarma Reporting and Analytics for ERP -
If a client discontinues HCM but using Finance and SCM, how will user and employee records managed.Summary: Our client is currently using Oracle Fusion applications, including HCM, Finance, and Supply Chain Management (SCM). They are now planning to discontinue Oracle…Shahbaz Mohmmed 23 views 3 comments 0 points Most recent by rajesh kumar Reporting and Analytics for ERP -
Financial Reporting Excel Export Splitting into Multiple Worksheets Instead of a Single WorksheetHi Everyone, We're experiencing an issue where Financial Reports exported from Open Workspace for Financial Reports are now split into multiple Excel worksheets based on… -
"General Ledger Journal and Subledger Transaction Mapping Report"HI Team, is it possible to get sql behind report "General Ledger Journal and Subledger Transaction Mapping Report" /shared/Financials/General Ledger/Account Analysis Gen…SushmaMeesala006 43 views 6 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP -
FRS default previewSummary: FRS reports are opening in HTML view by default when "Default Preview Mode" in preferences set to PDF Content (please ensure you mask any confidential informati…ARPITA_1 5 views 1 comment 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for ERP -
Is there a way to get a pop box with a statement on clicking on Save on Create Payables InvoiceSummary: While Creating an Payables Invoice in Classic UI, there are fields like Invoice Currency and Payment currency, so when user enters the same currencies in both t…Cemalapati Sai Charan 15 views 0 comments 0 points Started by Cemalapati Sai Charan Reporting and Analytics for ERP -
Custom ESS jobs error outSummary: We have 7 custom reports where created a related ESS job definitions and created custom role (with appropriate Privileges) to run those custom ESS jobs. Job is … -
Oracle Fusion BIP Report ESS Job Parameter Error & How to Enable XML and Diagnostic LogsHi Team, I’m facing an issue when scheduling the ESS job — as soon as I select the parameters, it immediately throws an error. The current log doesn't provide enough inf…Ashish1Soni 162 views 3 comments 0 points Most recent by AntoineSGSC Reporting and Analytics for ERP -
Query to bring the BU to which a Customer Account Site is associated toSummary: Content (required): I need a query to retrieve the BU name associated to the Account Site . Thanks. Version (include the version you are using, if applicable): …Michal Shaked 894 views 4 comments 0 points Most recent by User_RSF4I Reporting and Analytics for ERP -
Getting Errore in FRS Report - Internal Essbase JAPI errorSummary: Getting Errore in FRS Report - Internal Essbase JAPI error Content (required): Dear All, I tried to run a FRS Report and I am getting the below error. Error exe… -
poz_supp_site_requests not having an entry for Supplier Site pending approvalSummary: we have a need to create a BI Report and list all supplier and it's sites that are pending approval on profile changes or any other changes. we try to display p…Kasthuri Haridass-Oracle 24 views 2 comments 0 points Most recent by Kasthuri Haridass-Oracle Reporting and Analytics for ERP -
OTBI Subledger Reconciliation Report with GL - ReportSummary: OTBI Subledger Reconciliation Report with GL - Report Content (please ensure you mask any confidential information): Hello The Company have the below subledgers…martingabriel Kinovisques 19 views 1 comment 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for ERP -
SQL to Find AP invoices assigned for approval to wf groups where those role currently has no usersWe have a requirement to fetch the invoices assigned for approval to wf groups(roles) which has no active users, if anyone has any sql or BIP report could you please hel…Naveen_CCC 21 views 1 comment 0 points Most recent by Christian Guidibi Reporting and Analytics for ERP -
How to send attachment from content server to email through BI bursting in fusionSummary: Let’s say we have uploaded a PDF attachment in the contract, and the uploaded attachment gets saved in the content server. Now, we want to send this attachment … -
AGIS tables PVO's doesnot existsSummary: Hi Team, The below AGIS tables PVO's does not exists in BICC. Can you please advice to me. FUN_BAL_INTER_RULES FUN_BAL_INTER_ACCOUNTS_ADDL Thanks Content (pleas…Siva Kumar Bondalapati 10 views 0 comments 0 points Started by Siva Kumar Bondalapati Reporting and Analytics for ERP -
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…Roohi Syed 4.4K views 6 comments 0 points Most recent by SUDERSHAN PRASAD TIWARI Reporting and Analytics for ERP -
in the account analysis report when the category payroll the line description is blankedSummary: in the account analysis report when the category payroll the line description is blanked, from where we can fill the data for Line description Content (please e…Mohammad Merie 2 views 0 comments 0 points Started by Mohammad Merie Reporting and Analytics for ERP