Financial Reporting
Discussion List
-
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 25 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 150 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 13 views 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 34 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 13 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 162 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 26 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 13 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 17 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 81 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 140 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 75 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 13 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