Financial Reporting
Discussion List
-
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 413 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 44 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 63 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 14 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
-
How to export bulk data to Webcenter Content by using erpintegrations REST API ?Summary: How to export bulk data to Webcenter Content by using erpintegrations REST API with a security group and account in job option parameters ? Example /fscmRestApi…LaurentDup 21 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany -
Is it possible to setup multiple trial balance in Oracle Financials (ERP)?Is it possible to setup multiple trial balance in Oracle Financials (ERP)? We are planning to maintain separate balance sheets, financial and income statements.
-
What is base balance being shown when I expense a parent value in Financial Reporting Studio?When I expand a parent value in an FRS report, the first child is the parent value name - Base Balance. What is this and how does it work?
-
Limiting ledger view for Balance Sheet and Income Statement Reports for usersSummary: Hi everyone, I hope you are all doing well. I have a query regarding the FRS Balance Sheet and Income Statement reports. After creating these reports, we notice…
-
Reconciliation when setting up Auto receipt accrual clearing ruleSummary: We had a requirement to clear accruals for Finally closed POs. So, we are testing by creating an accrual clearing rule. We created accrual clearing rule for thi…
-
Impact on Application behavior if we change the FUTURE1 Segment of COA Structure to ZONESummary Impact on Application behavior if we change the FUTURE1 Segment of COA Structure to ZONEContent Hi All, Greetings. Customer is live on Cloud Applications, having…Subramanyam Tumarada-Oracle 144 views 8 comments 1 point Most recent by PratikL General Ledger & Intercompany
-
FRS Reporting at summary and detail level in same reportSummary: We have a hierarchy setup (parent + child values) and they are used in the FRS. While running, the report gives me values at the child nodes, but I also want to…Dhanachandran K 5 views 1 comment 0 points Most recent by Anca A-Oracle General Ledger & Intercompany