Financial Reporting
Discussion List
-
Translate General Ledger Account Balances ParametersSummary: We use scheduling tool to submit programs in oracle cloud. Program 'Translate General Ledger Account Balances' has parameters as below when submitting from ESS.… -
Delete Translation Balances parametersSummary: Hello experts, we use scheduling tool to submit programs in Oracle cloud space. Delete Translation Balances program has below parameters to submit by user but p… -
Showing unbalanced intracompany journalSummary: I am interfacing journals directly to GL through OIC (From other Application). The journals involve multiple LEs under the same Ledger. Sequencing by LE is enab…Subrat Kumar Dash 5 views 0 comments 0 points Started by Subrat Kumar Dash General Ledger & Intercompany -
Where can I configure the Reporting Context parameter?The user is about to generate the "Receivables Aging by General Ledger Account Report" and in the process details there are no values to be selected in "Reporting Contex…Joyce Gutierrez 3 views 0 comments 0 points Started by Joyce Gutierrez Reporting and Analytics for ERP -
do we can restrict the user with out giving to access to the particular journal sourceSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Ramkrishna Maramreddy 1 view 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
How to print prompted value as a header text in FRS report?I am creating a balance sheet report in oracle using FRS. Business has a requirement keep accounting period, entity, budget scenario as prompts. I have created the promp… -
General Ledger Account Groups query criteria to include Chart of AccountsSummary: We are looking for Query by example on General Ledger Account Groups to include Chart of Accounts criteria, is anyone aware if this function available with a pr…Raj Gutta 2 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
How to default open accounting period in FRS report?We are creating a Balance Sheet report using FRS. We want to pass / default open accounting period as a parameter. How to do it? -
Will the transition of FRS reports to Oracle Reports in June '25 impact ERP reports too?Since Web Reporting Studio and FR reports are going to be deprecated, will it impact existing ERP reports in FRC. Users are currently running GL Financial Reports from t… -
India-Specific Data BackupSummary: During recent amendments made by the Ministry of Corporate Affairs (MCA) in India regarding Accounts Rules. These amendments have introduced stringent complianc…Sarath Bhuma 21 views 2 comments 0 points Most recent by Sarath Bhuma Subledger Accounting & Accounting Hub -
FRS report not showing accounting calenderSummary: We have developed a GAAP Balance sheet report in TEST all looks good, but when we tried to moved to PROD, we are only able to see two periods, year 2011 and 12 …Vivek Makwana 11 views 4 comments 0 points Most recent by Vivek Makwana General Ledger & Intercompany -
Requirement to default Current Period in the FRS ReportCurrently Trial Balance Report in Financial Reporting center showing Oct 2022 as default accounting Period which is very old period and client expressed their concern to… -
GL Balance Detail on Accounts with Summary Flag EnabledSummary: Content (please ensure you mask any confidential information):We'd like to pull aggregated balance details on summary accounts using the GL_BALANCES table. We'r… -
🚨 Unknown Member error in Financial Reporting Studio Reports🚨Common issues in Financial Reporting Studio Reports🚨 💭 A) Error executing query:Error:Internal Essbase JAPI error:[Cannot perform cube view operation.Essbase Error(1260…Andreea Brem-Oracle 129 views 1 comment 1 point Most recent by Rich Merkel General Ledger & Intercompany -
How GL Trial Balance Report is designed to sort account codes?Summary: Hello community members, I am wondering if anyone know how GL Trial Balance Report is designed to sort account codes? It looks like the report is designed to so…T. Kosami-Oracle 11 views 3 comments 0 points Most recent by Venkatesh Padamwar General Ledger & Intercompany -
Need to know what all things to do across modules for company name change scinarioHi Experts, One of our customer is going to change there company name and calendar- like earlier thyey used to follow 'Jun to May' calendar but after company name change…Kalpesh Salunke-Oracle 1 view 0 comments 0 points Started by Kalpesh Salunke-Oracle General Ledger & Intercompany -
How to export FRS report definition in Excel format?Summary: User want to review the FRS report definition of FRS reports created in system They want to know is there any tables storing the definition, like Oracle EBIS do…CS Yuen-Oracle 2 views 2 comments 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany -
Seeking Advice: Best Practice for GL Secondary Ledger for Future IFRS Reporting (J-GAAP Primary)Hello everyone, I am currently planning our General Ledger setup and would greatly appreciate your advice and insights. Background We are setting up our Primary Ledger b… -
How can I run Trial Balance for multiple Primary ledgers in one runWe have 31 Primary Ledgers and as many Secondary Ledgers. The client wants to run Trial Balance for all Primary Ledgers in a single run. They do not want to run the TB 3…Rakesh Viswambharan 11 views 3 comments 0 points Most recent by A Lotfy General Ledger & Intercompany -
Ability to run FRS report in SmartviewSummary: In FRS report, there are formula rows/columns, text rows/columns, title. Can users run FRS report in SmartView? As export in query ready mode seems able to expo… -
We need to change the existing BU and LE name to new nameSummary: We need to change the existing BU and LE name to new name If we can change the Old legal entity name With new name. Content (please ensure you mask any confiden…RANJITH KUMAR S 10 views 2 comments 0 points Most recent by Urvi Shastri General Ledger & Intercompany -
Have you built an outbound GL integration to Solver Cloud?Summary: We are an Oracle Fusion ERP customer and we send data to Solver Cloud, a third-party financial planning and reporting tool. If you are a Solver Cloud customer o… -
Income Statement Not translated at Averange RateSummary: The Translation for Income Statement accounts happens at ending rate even if set up has average in the Account Dimension. Content (please ensure you mask any co… -
How to create a new version of chart of accounts without replaces old segment names in previous COA.Summary: When creating a new version of chart of accounts where existing parent codes and child codes are renamed, the old existing versions that has the old segment val…Sreenath Pachman 2 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
BI Catalog for FRS reports the last modified date not getting updated with respect report run timeIn Oracle Fusion, EPM Workspace (Others>Financial Reporting Center>Open workspace for financial reports) we have observed the following behavior: When User A has schedul…Prathyusha Mitte 41 views 3 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
GL Accounting Period Open/Close Update REST APIHi, We need to create a PAAS application to allow users to enter the period details to open and close the STAT leger periods. By using PAAS application to implement that…Praveen_Paul_raj 688 views 5 comments 0 points Most recent by User_XPVVZ General Ledger & Intercompany -
24C New BIP report Journal and Transaction Details Report Unable to Select From & To Period ParameteSummary: 24C New BIP Report: Journal and Transaction Details Report: Unable to Select From & To Period Parameters Content (please ensure you mask any confidential inform… -
Change segments in an existing chart of accounts structureSummary Change segments in an existing chart of accounts structureContent Hi All, Request your kind attention: 1.The Customer is on a live Fusion Cloud Instance with Fin…Subramanyam Tumarada-Oracle 297 views 10 comments 2 points Most recent by User_U7XJR General Ledger & Intercompany -
Best Practices During MergerWe expect that a merger with another company will be approved in the next couple of months. What are the recommended practices in case the acquisition is approved in the…Tina Valtchev 21 views 3 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
An OTBI report with mutiple subject area from ERP and HCMSummary: I want to create an OTBI report consisting of Journal header Id, batch id, Journal created by Username, Approval status , rejected by whom(if any), Department t…