Financial Reporting
Discussion List
-
Additional Information required on Extreme Scale and Monitor for Accounting Hub Import Using a RESTSummary: Hi Team, We are planning an integration for loading data into the Oracle Accounting Hub but the solution is not clear regarding the optimal approach and technic…Abdulkadir-KPMG 30 views 7 comments 0 points Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub -
how to create a SERVICE ACCOUNT to be used by Integrations in Oracle ERPSummary: how to create a SERVICE ACCOUNT to be used by Integrations in Oracle ERP (oracle fusion application ) . We looked in Oracle ERP Cloud and we can only find Emplo… -
Proper Configuration for Legal Entity with 2 branches in different countriesSummary: Client is taking over accounting for IE Legal Entity with 2 branches in different countries. What is proper configuration? VAT filing requirements are held at L… -
FRS Report currency to pick automatically based on LedgerWe have custom FRS report in which Ledger is selected by User, they also have requirement to set currency automatically based on the selected ledger. Please share the st…tanya gupta1 11 views 2 comments 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany -
To fetch all the approval group details for a journal.Hi, I am working on a GL workflow BIP report where I need to fetch ApprovalGroup Details like ApprovalGroupName, Approval Sequence, Approval Comments for a journal. Plea…Chitti Damoder 7 views 0 comments 0 points Started by Chitti Damoder Reporting and Analytics for ERP -
🚨 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 159 views 3 comments 2 points Most recent by RishikaJain General Ledger & Intercompany -
Error while previewing FRS report.Summary: Error executing query: Error: Internal Essbase JAPI error: [Cannot execute report. Essbase Error(1001211): Report error. The number of Columns in the Report exc… -
Reopen Permanently Closed period in oracle fusionSummary: We would like to understand the process in case we needed to "Reopen Permanently Closed period in oracle fusion". Currently it says that this is not possible at…AhmedAbdullah 20 views 2 comments 0 points Most recent by AhmedAbdullah General Ledger & Intercompany -
upload sequence settingSummary: how can i manage GL accounting sequence rapidly,import or other possible ways,here is the function Content (please ensure you mask any confidential informatio… -
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… -
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 55 views 3 comments 0 points Most recent by SNanda Subledger Accounting & Accounting Hub -
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 3 comments 0 points Most recent by Venkatesh Padamwar General Ledger & Intercompany -
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 6 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 11 views 0 comments 0 points Started by Joyce Gutierrez Reporting and Analytics for ERP -
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… -
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… -
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 13 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… -
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 3 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 16 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…CS Yuen-Oracle 49 views 7 comments 0 points Most recent by Anuj Gaikwad General Ledger & Intercompany -
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 11 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…