Financial Reporting
Discussion List
-
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 -
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…
-
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 -
Translation_Incremental JournalsSummary: Translation_Incremental Journals Content (please ensure you mask any confidential information): Step 1: Submit the job “Translate General Ledger Account Balance… -
Turkey E-ledger requirementSummary: Hello Team, Our customer requires Turkey E-Ledger report to be developed as part of Turkey Localization. Please check and let us know if we have any out of box …Narayanan M S-Oracle 2 views 0 comments 0 points Started by Narayanan M S-Oracle General Ledger & Intercompany
-
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…
-
"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 11 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany -
Conversion rate account wise for specific period and ledgerHi Experts, We need your assistance to know more about the below details, Please do share whatever information available in terms of Doc ID, Reference Portal etc. In Gen…YogeshTiwari-Oracle 1 view 0 comments 1 point Started by YogeshTiwari-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.
-
inquire on detail balance doesn't workSummary: inquire on detail balance doesn't work Content (please ensure you mask any confidential information): knowing that the user already has access to all ledgers an…Abdelrhman Samy 11 views 1 comment 0 points Most recent by Kamakshi Mohan-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 113 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 24 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 12 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 1 view 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 21 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 2 views 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 11 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 3 views 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 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
FRS Webstudio Workspace HangingI'm not able to open Workspace for Financial Reports ( Tools > Financial Reporting Centre > Task Pane > Open Workspace for Financial Reports). Only thing it shows is a w…Mig_ph 1 view 3 comments 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany
-
General Ledger Report - Cash BasisSummary: Hi Team, I would like to extract or build a custom report for General Ledger in oracle fusion with the below columns data. Required columns are: GL Date Transac…Sesha Sailini 11 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
how can we migrate the GL journal attachments from legacy (EBS R12) to Oracle cloudWe have requirement to Migrate the Journal entries from legacy (EBS R12) to Oracle cloud fusion, we are using FBDI file to load the journal entries in oracle cloud, how …Basant Parihar 13 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany