Financial Reporting
Discussion List
-
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 32 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 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 157 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 11 views 1 comment 0 points Most recent by Andreea Brem-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 12 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
How to read existing FRS Report DefinitionSummary: Hi Experts Can anyone advise how to read existing FRS report definition to find the current Logic/Formula's defined under this FRS report to have better underst…Satya Mothe 14 views 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany
-
Reporting Sequence Functionality in Oracle Fusion General LedgerSummary: Does reporting sequence number change after we reopen and close a GL period Content (please ensure you mask any confidential information): Hi I have a reporting…Wesraj 83 views 7 comments 0 points Most recent by Natalia Suarez Dillman General Ledger & Intercompany -
I need help setting up an account hierarchy to allow business users to view it in the cloud GLHello Support Community, I need help setting up "Account Hierarchy Management" to allow business users to view it in the cloud general ledger. Currently, they have acces…Prakash Vattapalli 31 views 3 comments 0 points Most recent by Rohan Kamat General Ledger & Intercompany
-
Changing the Hierarchy StructureSummary: Client is using around 6 parents and child for account hierarchy. However, client decided to change the hierarchy for one parent and child. So, what are the pre…
-
Ledger Name doesn't appear when creating accountHi community, When I run Create Accounting, The Ledger name that was created doesn't appear in the drop down menu, though from payroll definition ledger name is showing …Kalemba Jean-Marc Kankwenda 130 views 1 comment 0 points Most recent by Cezar M-Oracle General Ledger & Intercompany
-
What is the tablename to obtain the FRS row and column definitionSummary: We have a P&L of which the information is not part of the chart of account segment hence will required to build via BIP. However, since the P&L are having many …Alicia Ng-Oracle 33 views 2 comments 0 points Most recent by Alicia Ng-Oracle General Ledger & Intercompany
-
Missing Account Filter in Trial Balance ReportSummary: Unable to filter accounts when generating a Trial Balance Report due to missing field. Seeking assistance from the Oracle community. Content (please ensure you …Paul Younes 11 views 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany
-
We have migrated FRS reports from Test Environment to Dev Environment but it is giving errorSummary: We have migrated FRS reports from Test Environment to Dev Environment but it is giving error:- (; nested exception is: com.hyperion.ap.APException: [1113] Error…raviteja.v 77 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
24C - Service Excellence Continuing InvestmentsSummary: Hi Experts, For the new 24C feature 'Service Excellence Continuing Investments', can you help provide screenshot or copy of new BIP report 'Journal and Transact…Crystal Joy.Paule 11 views 2 comments 0 points Most recent by Crystal Joy.Paule General Ledger & Intercompany
-
In Manage Journals the column Reversal Date does not seem to get populated.The user reversed the Journal and identified the Reversal date from Manage Journals the column Reversal Date does not seem to get populated. Please Provide if there is a…Subramanyam.karamala 11 views 2 comments 0 points Most recent by Subramanyam.karamala General Ledger & Intercompany
-
GL Revaluation sources - report to show the invoices/payment (sub-ledger) transactionsSummary: Hello All, We have a requirement where business wants to verify the source transactions (AP invoices/payments) that are considered for the revaluation process d…Subhasish-OC 21 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Derive a balance sheet, profit&Loss for a COA segment not qualified as secondary balancing segHi Team Do we have any solution option to derive a balance sheet and profit & loss for a COA segment which is not qualified as secondary balancing segment? Is there any …ShrutiSood 11 views 1 comment 0 points Most recent by Baidehi Nanda–Support-Oracle General Ledger & Intercompany
-
it there way to know if values added in value set values for COA, are not defined into a hierarchy?Summary: Customer needs to know if all the nueve value set values created have been assigned to an accounting hierarchy through some task or scheduled process Content (p…Arturo Benitez-Oracle 11 views 2 comments 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
GL Journal Lines reporting for Mexico's Electronic Invoice UUIDSummary: I have a requirement to store Mexico's electronic invoice number (aka UUID) at the GL Journal Lines level. The UUID is being passed from Oracle Cloud Payables t… -
Allocating Expenses on the basis of revenueSummary: When allocating my expenses according to revenue, I gave my whole revenue hiearchy in basis. That hiearchy has balance but the system says there are no balances…
-
How do I find activity information on reports and extracts?Summary: I am trying to complete a Fusion resize SR and I am being asked about General Ledger activity for Reports and Extracts, I am unable to find any information rega…
-
In FRS Report, Balances need to calculate with Conversion rate or User Enteted rate.Summary: Customer don't have reporting currency ledgers but only have primary ledgers for all countries. He has reporting requirement that Local Reporting in INR and Glo…raviteja.v 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Ability to Select multiple dimension members in a single column/row in SmartView Ad-Hoc ReportingWhen creating a SmartView Ad-hoc report. When we choose members from a dimension right now, we are only able to push them across columns / down rows , but we want to pla…k.madaan 13 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Trying to retrieve number from AccountingPeriod to use in Formulas in Financial Reporting Web StudioSummary: We are facing a challenge where we need to calculate a specific value using the AccountingPeriod number. However, the AccountingPeriod in the GL cube is represe…Arvind_Behura 21 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany