Fusion Financial reporting
Discussion List
-
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 21 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 12 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 4 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.1K 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…
-
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 21 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 25 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 13 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 33 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 66 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 21 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 611 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 72 views 10 comments 0 points Most recent by Hemant Jain Reporting and Analytics for ERP
-
Manage Audit Policies enabled but output shows 'There are no records to display'Summary: We have enabled 'Manage Audit Policies' for Payables >Invoices (attributes also SELECTED and added) last week. 1) However when we run the "Generate Audit Report…Joel Dsilva 733 views 13 comments 1 point Most recent by Donna Curtis Reporting and Analytics for ERP
-
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle 3.7K views 87 comments 10 points Most recent by ERP & EPM Cloud Reporting and Analytics for ERP -
FRS Reports erroring out intermittentlySummary: FRS Reports erroring out intermittently Content (please ensure you mask any confidential information):These are the errors received trying to run the Fin report… -
In Cash Management OTBI, is it possible to get the transactions reconcilied to a statement line?Summary: On the Manual Reconciliation Cash Management page, it is possible to see which system transactions (AP, AR, etc) are reconciled to a given bank statement line. …User_2025-02-11-06-12-35-024 211 views 5 comments 5 points Most recent by Naveen_CCC Reporting and Analytics for ERP
-
Fixed Assets - Entered PeriodSummary Is the "Entered Period" available in any of the Fixed Asset subject areas?Content I have been searching through the various asset-related subject areas for a fie…ndryden 360 views 9 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP