Fusion Financial reporting
Discussion List
-
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 6 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 11 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 134 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 827 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 26 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 15 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 11 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 1 view 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.2K 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 5 views 0 comments 0 points Started by Mohammad Merie Reporting and Analytics for ERP
-
How can I access the list of EU countries?I have a query; SELECT * FROM hz_geographies WHERE geography_type IN ('ECONOMIC REGIONS') I want to question the countries within the EU. However, when I run the query, …Gül Öner 24 views 1 comment 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for ERP
-
Smart View handled an unknown exception thrown by Microsoft OfficeSummary Smart View error using ExcelContent Hi, I'm using Smart View version 11.1.2.5.910 with Microsoft Office Standard 2016, I'm constantly receiving this error "Smart… -
Issue Fetching Accounting Period in FRS Report HeaderSummary: Hello, While attempting to use the MemberName function in the header of an FRS report to display the Accounting Period selected in the grid, I am encountering t…
-
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…User_2025-02-04-10-47-46-258 53 views 4 comments 0 points Most recent by User_HI2N6 Reporting and Analytics for ERP -
How to get data for Audit Reasons column in OTBI like the Expense Auditor Dashboard ?Summary: We are working on a custom dashboard for Expense auditors and one of the fields requested in 'Audit Reasons'. The subject area 'Expense- Expense Transactions Re… -
Journal approval and rejection reportSummary: Do we a report in Oracle that provide information on journals which were submitted for approval and have been rejected. If not can anyone share any queries wher…
-
Create Data Model From View ObjectSummary: We are in an Oracle Fusion Saas environment. I have been looking at the View Object Data Model, We have Data Sources that populate for ERP and HCM in the dropdo…Christopher Haupt 22 views 0 comments 1 point Started by Christopher Haupt Reporting and Analytics for ERP -
Any Roadmap for Oracle Cloud Financial Redwood?Summary: Hi All, Is there any road map for redwood implementation for Oracle Cloud Financial, what all new features will be added and what will be time line. If any one …Tauseef_Akram909 42 views 2 comments 4 points Most recent by Maureen Jones Reporting and Analytics for ERP
-
Requirement to have 7 buckets in Customer Statement reportSummary: Client requires 7 buckets in Customer Statement Report. We have defined a statement aging method to have 7 buckets but only 5 buckets are visible in the report …Anand Kandasamy 19 views 1 comment 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for ERP
-
What table stores the system transactions reference number for Bank Statement (CE) reconciled itemsSummary: We are attempting to replicate the Cash Management Bank Statements>Manual Reconciliation page>Reconciled tab in a custom OTBI Report. For system transactions li… -
SmartView Duplicate name Error from sharded driveSummary: Smartview Spreadsheets are kept in a shared drive (OneDrive). After a hierarchy change (A single value added or moved)we continually see errors like : Essbase E…Service Desk Claremont 41 views 3 comments 0 points Most recent by Sukrut Reporting and Analytics for ERP
-
create customer statements ESS job output in Excel formatSummary: Requirement is to generate Statements in PDF and Excel format for the standard ESS job "Create Customer Statements". No option to select output type as Excel. A…Anand Kandasamy 67 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Query to Fetch Tax Calsification Code Value From the Transaction LineSummary: We have a requriement to create a report to fetch Tax Classification Code value from the transaction line Content (please ensure you mask any confidential infor…Mamdouh Ahmed 27 views 4 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for ERP
-
AR Transaction Register Report erroring as too many records. how have people got round thisSummary: AR Transaction Register Report erroring as too many records (trying to run for full quarter as needed for external audit). how have people got round this? Conte…Jill Stanton 31 views 8 comments 0 points Most recent by Rinku Gautam Reporting and Analytics for ERP
-
ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabledSummary: Hi Team, I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the whe…Shashidhar Goud 625 views 12 comments 0 points Most recent by Naveen_CCC Reporting and Analytics for ERP
-
Guidance for copying seeded report for customizationSummary: As someone new to OTBI, I'm hoping to copy a seeded report (Payables Trials Balance Report) to run for specific vendors. I've copied the report, but don't know …
-
Read only access to data modelSummary: We want to provide read only access to data model for some key BIP reports, to our Internal audit team as they want to review the code behind key sox reports. W…Hemant Jain 74 views 10 comments 0 points Most recent by Hemant Jain Reporting and Analytics for ERP