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 42 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. https://us.v-cdn.net/6034893/uploads/RX3X4ZKTCUXC/sr-smartview.pdf Client asked us if there’s a possible w…Felipe M. Ignacio II 23 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 181 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 33 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 12 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 31 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 11 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 11 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 102 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 32 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 161 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 41 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 -
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 12 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…SubhasishRay 25 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 12 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…NancyR_Bravo 116 views 2 comments 0 points Most recent by NancyR_Bravo General Ledger & Intercompany -
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…