Financial Reporting
Discussion List
-
Have one reporting currency to one ledger setSummary: I would like to use one same reporting currency to several ledgers, and prefer to group all the ledgers I need to one ledger set so that I can run reports in on…Luna Chen 59 views 3 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Design for management entities ?Summary: Where do we map the management entities (Line of business) in chart of accounts ? Content (required): Each Legal entity has 2-3 Line of business or management e…Gaurav Paul 7 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Impact of setting up label for COA segmentSummary: We're rolling out some changes with SLA & for that, we need to add label for project segment (COA structure). We would like to understand the impact of adding t…Sujatha Kumari 42 views 1 comment 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany -
Currency rates should allow DeletionSummary: The setup of MANAGE DAILY RATES should have an option to delete daily rates. Content (required): Currency rates Version (include the version you are using, if a…Anthony Dsouza 31 views 2 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
What member selection function to use to always get a month of a previous yearSummary: I am required to produce a financial report in Financial reporting web studio. in my Grid, I have account dimension selected for rows, company selected for page…User_2025-07-18-06-16-52-703 77 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
GL Budget upload - BudgetName exceed the maximum length allowedSummary: Content (required): Hi, I'm trying to upload budget to GL cubes. I have created a scenario by the name "MPL Capex Opex Monthly 2023" which is the same as my con…Sheneli98 49 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
What Job Role is required to run Z4 Report for GermanySummary: What Job Role is required to run Z4 Report for Germany Z4 report for Germany is localization report. Need to know what job role or privelege is required to run …Jakeeagarwal 74 views 10 comments 0 points Most recent by Jakeeagarwal General Ledger & Intercompany -
Defaulting Units and Unit Rate from IC Transactions in ARSummary: Hello! When creating IC Invoices and transferring them to the AR Module, we want to have the Units and Unit Prices reflected in the AR Invoice screen. Typically… -
New Values in the Scenario Drop Down ListSummary: Our DEV environments are including New Values in the Scenario Drop Down List in the Inquire on Detailed Balance Screen and others. Content (required): Our DEV e…Adrian Townsend 36 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Points to be considered when adding a new GL accountSummary: Need to add a new GL account in new fiscal year to report some community donations. Content (required): We have been alive for two years and have three BUs. Cur…Sharon Li 106 views 3 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
How to schedule an ESS job with a dynamic parameter?Summary: Scheduling Account Analysis Report job on monthly basis with 'To Accounting Period' as current month Content (required): We want to auto schedule an ESS job for…Imogen B 509 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Difference in the budget between Budgetary Control and General Accounting DashboardSummary: What is the difference between functions in the budget between Budgetary Control and General Account Content (required): What is the difference between "Enter B…Dian Minshan 45 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
How to add Cost Center to report where it also should be in POV in FRS report. Kindly suggest me.Summary: How to add Cost Center to report where it also should be in POV in FRS report. Kindly suggest me. Content (required): Version (include the version you are using…Lakshmi Prasanna Bandaru 103 views 8 comments 0 points Most recent by Baidehi Nanda–Support-Oracle General Ledger & Intercompany -
Smart View v 23.1Summary: Will the new features in Smartview v 23.1 be available for ERP users? Content (required): The new Smart View features in version 23.1 show as applicable only fo… -
How to connect/download data from Fusion Applications General Ledger Essbase Cube to our databaseSummary: Can we gain access to Financial data cube to develop our internal reports? The current custom report built in FRS needs to be used by users that do not have acc… -
Translation Not working as EBS: Primary Ledger to Reporting Currency - Urgent Help neededSummary: Translation Not working as EBS: Primary Ledger to Reporting Currency - Urgent Help needed Content (required): We have entities in across the world and all needs…Kumar 57 47 views 2 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
Account is added to FRS Report which was already existing.But we get #ERROR or 0 errorHi Team, Account (new account) is added to FRS Report which was already existing.But we get #ERROR or 0 error. Please let me know how to solve this error. Attached the e…Lakshmi Prasanna Bandaru 50 views 1 comment 0 points Most recent by Hussian Sharief M-Oracle General Ledger & Intercompany -
How to display only child accounts(of detail level or last level) in FRS reportSummary: Hi All, Creating a FRS report to show account in most detail level (only child values). I am using Function 'BottomOfHierarchy' for the same. But here I should …Lakshmi Prasanna Bandaru 152 views 5 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
How to sum using rounded #s in Financial Reporting Studio grid report?Summary: We are having issues with the way that rounded #s are being summed in FRS (our statutory reports are all set to not use any decimal places), and we'd like to kn…John Landers 117 views 2 comments 0 points Most recent by John Landers General Ledger & Intercompany -
Can we get FR web studio reports through API?Summary: We need to extract FR studio reports through API usage. Content (required): We need to extract FR studio reports through API usage. Version (include the version…Asadullah Memon 38 views 1 comment 0 points Most recent by Haripriya-Oracle General Ledger & Intercompany -
Consolidation -- Trial Balance QuerySummary: Consolidation -- Trial Balance Query Content (required): Business created Primary ledger, Secondary ledger in different currency, reporting currency ledger, Con…Kumar 57 57 views 2 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
Spain SAF-T chart of accounts mapping requirements. ?Summary: Spain SAF-T chart of accounts mapping requirements. ? Content (required): Hello Will you please let me know the mapping and report requierements ? If you can sh…martingabriel Kinovisques 48 views 1 comment 0 points Most recent by Anca A-Oracle General Ledger & Intercompany -
Restrict user access to application UI and seeded reports only to the particular LE / Ledger / BUSummary: Restrict user access to application UI and seeded reports only to the particular LE / Ledger / BU Content (required): In our existing setup of 6 LE / Ledgers, t…Clyde 67 views 3 comments 0 points Most recent by Baidehi Nanda–Support-Oracle General Ledger & Intercompany -
Consolidation - Historical Rates QuerySummary: Consolidation - Historical Rates Query Content (required): Business case: Ledger 1: GBP Ledger - Transactions in GBP. Ledger 2: Created Reporting Currency Ledge…Kumar 57 27 views 1 comment 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
GL Hierarchy Using Ranges-FRS reports do not ExpandSummary: I have created a new CoA, hence a GL Cube. The two key value sets (Account and Cost Centre) hierarchies are range based. - When I write FRS report, I can see th…Maneesh De Silva 86 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Essbase error 1260046. Unkown member values used in query in FRSSummary: Anymore encountered this error while running FRS report in the cloned instance? In prod, source for clone, is working fine Content (required): Essbase error 126…Giri Venkatesan 38 views 8 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Unable to Transfer Historic Journal/Balances to Newly Created Reporting CurrencySummary: Unable to Transfer Historic Journal/Balances to Newly Created Reporting Currency Content (required): We are doing Consolidation in Oracle Fusion ERP GL. As a re…Prakash_Khanchandani 58 views 3 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
How to convert a FRS report output from PDF to Excel?Summary: How to convert an FRS report output from PDF to Excel? Content (required): How to convert an FRS report output from PDF to Excel? I tried to change preferences …User_2025-07-18-06-50-46-162 47 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany -
Is there any Oracle seeded report which shows reconciliation status as one of its column?Summary: Oracle seeded report showing "Reconciliation status" (Reconciled/Unreconciled) as output. Content (required): Oracle seeded report showing "Reconciliation statu…User_2025-03-10-17-00-26-818 59 views 1 comment 0 points Most recent by Hussian Sharief M-Oracle General Ledger & Intercompany -
Exporting FRC reports to Excel - formula columns and cell formattingSummary: Is there a way to get an excel export from a FRS report that retains column and row formulas and doesn't use Custom as cell formatting? Content (required): Idea…Damir Antunović 119 views 6 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany