Financial Reporting
Discussion List
-
Wrong time zone on report?Hi, I have my time zone set at the user preference level. When I run Create Accounting Report, the output has the report date in the correct time zone. However when I ru… -
Outbound extract of GL BalancesSummary Outbound extract of GL BalancesContent Hi, Could someone suggest the best approach to extract GL balances on daily basis(incremental) and send it to third party …Vinod Mohan Raj 112 views 4 comments 4 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Delete Translation Balance job not visibleSummary: Delete Translation Balance job not visible Content (please ensure you mask any confidential information): Delete Translation Balance job not visible for user. w…Kumar 57 2 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
How to stop using historical rateSummary: How to stop using historical rate Content (please ensure you mask any confidential information): Business is closing the one entity and they used to use histori…Kumar 57 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Issue with the FRC Reports. It appears that the entity is not displayed as expected.When we try to open the FRC Report an issue where an entity appears in our search results for the BSF report but it not showing in the list.Ayush Baiswara 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Translation_Incremental JournalsSummary: Translation_Incremental Journals Content (please ensure you mask any confidential information): Step 1: Submit the job “Translate General Ledger Account Balance… -
How to exclude adjustment periods from a period over period analysis report in FRS?Summary: I've seen discussion regarding suppression of the adjustment period from a report but for company analytics we do month over month analysis. I'm looking for a w…Mike Scott 25 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany -
What is the impact of changing the legal entity at Assign Business Unit Business Function setupSummary: What is the impact of changing the legal entity at Assign Business Unit Business Function setup in oracle fusion as we have assigned a legal entity wrongly so w…Chirag_Ambwani 416 views 3 comments 0 points Most recent by Yogita Phadke-Oracle General Ledger & Intercompany -
Server UTC time zone causes the transaction not to post in current period.Summary: Server UTC time zone causes the transaction not to post in current period. Issue Description:Business noticed that: all the transactions (Material, GL, AP, AR, …Shivanagowda Sannagowdar 1 view 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle General Ledger & Intercompany -
SQL Query for Journal entries details and APInvoice table joinSummary: Need help on SQL query for the Journal entry details and Invoice details Join together. In the below screen shot we need highlighted information. I have written… -
How do I add location and brand segments to a Cost Summary report for fixed assets in Oracle Fusion?Summary: I would like to customize a seeded report found in Oracle Fusion by adding brand and location segments by updating the data model. Content (required): Version (… -
how to define combination sets in bulk in oracle fusion?Summary: We have a requirement to restrict a few GL code combinations, leading us to consider the use of combination sets. Currently, we need to define 300 combination s…MOHIT_GUPTA 41 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany -
Reporting Only Consolidation Method QuerySummary: Reporting Only Consolidation Method Query Content (required): I have gone through document provided in oracle : Reporting Only Consolidation Method Query. I am … -
How can I link a manually created financial category to the Prepare Reconciliation toolSummary: How can I link a manually created financial category to the "Prepare Payables to General Ledger Reconciliation" and "Prepare Receivables to General Ledger Recon… -
What is the cumulative translation adjustment account of the Specify ledger options UI used for?Summary: Is translation reserve calculated in Oracle Fusion during balance translation? Content (please ensure you mask any confidential information): We are trying to f… -
Why is the create accounting report date not the run date?If I run a Create Accounting Report last week, and Republish and download it today, the Report Date at the top states as today. How can we have this as the run date? -
Create FRS Planning database connectionSummary: I am building an FRS report in ERP and would like to create a database connection to the Planning application to include budget data. I can easily create the Es… -
sql query to find link between Intercompany Accounting and GLI want to know the tables and link between intercompany accounting and general ledger. I want to pick intercompany data in query. -
Fusion Consolidation_Challenges_need suggestionSummary: Fusion Consolidation_Challenges_need suggestion Content (please ensure you mask any confidential information): Business operates across the world and created 20…Kumar 57 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Is the expand all functionality in Financial Reporting Studio being removed in the future?Summary: We have setup the Expand all feature for our client as they wanted to see the entirety of the account rollups on the Balance Sheet and P&L statement in Financia…Grant S 64 views 3 comments 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany -
Account Segment value missing in Enterprise Structure Setup ReportSummary: Content (please ensure you mask any confidential information): We created few new accounts segment values, but they are missing from the Enterprise Structure Se… -
Combo graph (bar and line) values are showing inverted for Expense Account TypeThe actual data stored in the application is in negative because Expense Accounts normal balance are credit and credit has negative sign in the system. How can I configu… -
Is it possible to control or consult transactions that have suffered an "override account "?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
How to set 2 grids in FRS report such that they appear one after other horizontally in excel output?I want to set 2 grids one after other to compare them, In HTML output I'm able to view them correctly, But in excel output one grid is coming below the other.v How can I…Navya_Kamatam 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Same Localization to be applied in different currencyHi Team, can we apply same localization in different currency ? Currently it is for EHPV (USD).NikitaDDD 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Column arrangement in FRS ReportSummary: We are facing certain issues in developing FRS Report. Issue : There is a requirement to add columns like Beginning Balance, Period Activity Dr, Period Activity…Omega Consultant 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
BIP report can cater to how many linesSummary: Hi, I would like to check customized BIP report output can cater up to how many lines and size. Thanks! Content (please ensure you mask any confidential informa… -
How to use the same dimension in both the row and prompt level in Oracle Fusion's FRS?Summary: How to use the same dimension in both the row and prompt level in Oracle Fusion's Financial Reporting Studio? We need to create report where we can put dimensio…Andika Kurniawan 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Urgent Request: Account Hierarchy ConfigurationSummary: Content (please ensure you mask any confidential information): Problem: We're facing a critical issue in configuring account hierarchies for our production setu…Patrick Chrabieh 1 view 1 comment 0 points Most recent by James McBride General Ledger & Intercompany -
"Expand All" data limits in Financial Reporting Studio reportsHello, We have a trial balance report in fusion GL that has recently stopped working when you try to expand all on accounts and entities. The first time this happened (l…K McMillan 1 view 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany