Financial Reporting
Discussion List
-
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 61 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 11 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
-
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 22 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 136 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 1 view 1 comment 0 points Most recent by Anca A-Oracle General Ledger & Intercompany
-
Consolidation of multiple Legal Entities that are sharing the same Primary Ledger and 4CsHi Experts, In our business, there are about 19 Legal Entities, but they all share and post into the same Primary Ledger and share the same currency AED. I have to conso…Dhanachandran K 31 views 5 comments 0 points Most recent by Christian Leon General Ledger & Intercompany
-
Event Class of Account Analysis Reportingwe would like to further understand the setup of these two event class. Understanding that the event class are related to the SCM setup when goods received, and this eve…
-
Change the Accounting Period from Quarterly to Semi-Annual in SmartviewHi, This is to ask from your assistance regarding this matter. Client asked us if there’s a possible way to format/have an options in Smartview from Quarterly basis (Ima…Felipe M. Ignacio II 11 views 4 comments 0 points Most recent by Felipe M. Ignacio II General Ledger & Intercompany
-
Unable to find Ending balance column in GL balance TableI am looking for a Ending balance for a particular account in gl_balances table. Is any other table contains this value ?
-
Suppress rows based on the account prefix postive or negativeSummary: Suppress rows based on the account prefix postive or negative Content (please ensure you mask any confidential information): There is a requirement to have valu…Dian Minshan 4 views 3 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Account Description in FRS ReportHi, We are facing certain issues in developing FRS Report. There is a need to show GL Account and Description in 2 separate columns in FRS Report. Can someone help us to…Omega Consultant 151 views 2 comments 0 points Most recent by Omega Consultant General Ledger & Intercompany
-
Can we restrict view access transactions of different bus within same ledgerSummary: Our business have 3 different business units under 3LE and all records transactions are under same ledger, now a part of business one business unit is sold out …Lokesh Koppera 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Is it possible to fetch ledger id in OTBI?Summary: Hi, I want to add a column that shows the Ledger ID in OTBI for reporting. I have checked in all the Subject areas as shown in the image below but I have not go…Gautam Buragohain 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Journals for Mexico report (XML) is failing while uploading into SAT PortalJournals for Mexico report is missing regional information hence showing errors while uploading to SAT portal. We have entered the regional information at header level a…Vinod Reddy A 1 view 1 comment 0 points Most recent by Daniela Petria-Oracle General Ledger & Intercompany
-
Financial Reporting Studio Report for Ledgers in Different CubesSummary: Hi, We tried to include 2 GL balances cubes (1 Primary Ledger - 2 Secondary Ledgers: Primary and Sec ledgers share common CoA and currency but Calendar is diffe…Omega Consultant 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany