Financial Reporting
Discussion List
-
Trial Balance Report is Fetching No Data for Consolidated EntitySummary: Hello, Is it possible to run the Trial Balance Report for a Consolidated Entity. For us it fetches no data, and for individual segment values(entities) it fetch…SuniChacko 4 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany -
Allocation rules guide for multiple scenariosSummary: Allocation rules guide for multiple scenarios. I am facing many issues related to member selection, i am not able to select multiple member in source and target…Versha Sharma 14 views 3 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Account Analysis Report - The report columns are shuffled in CSV format outputIn Standard Account Analysis Report - The report columns are not in a proper order in CSV format output. for every different parameter the some columns are shuffled. Ple…Thanigainathan R 9 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
sanbox changes publish no to yesit is possible to change a status publish in yes when sandbox is create with no?Francesca1 15 views 2 comments 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany -
Newly Created Business Unit not available to select in existing FRS reports.Summary: Hi Experts, Recently we have configured a new business unit in our existing environment and realized that same has not available to select in the existing FRS r…Kalana Prasad 13 views 2 comments 0 points Most recent by Kalana Prasad General Ledger & Intercompany -
data retention and purgingSummary: What is the standard policy being followed by oracle across module with respect to data retention and purging. Content (please ensure you mask any confidential … -
Hello All : Are there any other Packages in GL similar to gl_flexfields_pkg ??Summary: Hello All I am looking for fetching GL date of AP and AR Transactions. Please advise if we have any other Packages in GL similar to gl_flexfields_pkg ?? Content…AnandChoudhary 14 views 3 comments 0 points Most recent by AnandChoudhary General Ledger & Intercompany -
Restrict the hierarchies in FRS report promptSummary: We have about 10 account hierarchies defined for one of the COA segments. We are developing an FRS report, which requests a prompt for accounting period and thi… -
Can Historical Rate be used as the workaround to import translated historical balanceSummary: We are implementing the cloud transformation project from Oracle EBS to Oracle Fusion. Summary journals as of the cut-off period will be used to convert the GL …CS Yuen-Oracle 26 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany -
Does a legal entity need to be assigned to a ledger for it to work FRS ReportSummary: We have one FRS report which is working properly for all the ledgers except one ledger which is not assigned to any legal entity and No BSV assigned to LE. The …KiranChittoor 15 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany -
How to switch to a new hierarch tree version in FRS report automatically without editing the report?we end dated our old chart of account hierarchy tree version, and created a new tree version with start date of today. We published both hierarchies. However, when we ru…Shannon Tse 14 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany -
How to disable Financial Reporting Center Icon from Other tabSummary: We have Financial Reporting Center icon enabled on Others tab that gives access to users to run FRS reports which contain sensitive financial information. We ar…Anil Bathula 14 views 1 comment 0 points Most recent by Hemalata-Oracle General Ledger & Intercompany -
GL_RUN_JOURNALS_REPORT_PRIV Report IssueSummary: I have assigned Privilege GL_RUN_JOURNALS_REPORT_PRIV to an custom role to run "Journals Report" from GL Module. But user is not able to find the ESS job. Do we… -
Getting error pop up while saving existing FRS Reports without any message.Getting error pop up while saving existing FRS Reports without any message. Anyone have faced this issue? -
Need syntax for deeplink to invoke FRS reports from dashboardSummary: Need syntax for deeplink to invoke FRS reports from dashboard Content (please ensure you mask any confidential information): Please share any samples of deep li…Madhavj 35 views 3 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Impact on system performance when audit trail is enabledSummary: Client needs to enable audit trial for multiple attributes across GL and FA. Content (please ensure you mask any confidential information): Client needs to enab…Dian Minshan 35 views 2 comments 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany -
We are unable to see the Financial Reporting Studio option on my instance. How can I enable it?Summary: We are unable to see the Financial Reporting Studio option on my instance. How can I enable it? Do we need to assign a specific role or opt for a particular off…bhushan_sarode 23 views 3 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Ability to define unit as FRS report promptUsers have a requirement to run same FRS report, but in different units ( $ and million), does FRS support unit as report prompt? If no, does it means we need to define …CS Yuen-Oracle 16 views 2 comments 0 points Most recent by CS Yuen-Oracle General Ledger & Intercompany -
Can you select All Ledgers when running Account Analysis Report?Summary: Would like to select multiple or all ledgers when running the account analysis report. Is possible to do so? Content (please ensure you mask any confidential in… -
Query to retrieve entity code and gl account code from oracle fusionI need to develop a query to retrieve both entity code and gl account code from oracle fusion tables. But unable to link both the tables. Can anyone please help in devel… -
Unable to view the new Entity in FRS reportsSummary: we recently created new entity but after Publishing hierarchies, Row and column flattening Unable to view the new Entity in FRS reports. Also its not getting ro… -
how to delete primary ledger which is just created by mistakenly in productionSummary: By mistake I have created Legal Entity and Primary ledger only those 2 steps in production. How can I delete both of them and the DOC no. shared is not opening … -
Does Oracle Fusion Cloud Smartview support Maxl or EPM AutomateSummary: Can user use Maxl or EPM Automate to import/export data from GL essbase cube when they are using smartview of Oracle Fusion ERP Cloud, and no subscription to EP…CS Yuen-Oracle 29 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Custom ESS job is running long for one particular userWe have custom ESS job which is running long for one particular user. For other users it is completed in 3-5 mins for the same parameters.(Both users are having same set…Thanigainathan R 10 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany -
Table to get Natural Account segment hierarchy in Oracle FusionSummary: Looking for Table to get Natural Account segment hierarchy in Oracle Fusion Content (required): I am trying to retrieve GL balances using SQL query in data mode… -
account inspector tableSummary: Content (please ensure you mask any confidential information): Account inspector which table are used? Version (include the version you are using, if applicable…Francesca1 5 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany -
Baseline version for All (segment) Values listSummary: For each segment there is list of all the values in the GL balance reporting tools which use Essbase. Sometimes the unique names have the prefix "[All Account V…Andrew Carlson 3 views 2 comments 0 points Most recent by Andrew Carlson General Ledger & Intercompany -
Period End Accrual - Paid Invoice is reflecting in this accountWe noticed that some of our invoices are were but those appear in the Period End Accrual. We expected the system to exclude invoices from the Accrual Account if the invo…Wilson Chelakadan 7 views 1 comment 0 points Most recent by MiaM-Oracle Subledger Accounting & Accounting Hub -
R13 How to generate a Trial Balance from OTBISummary R13 How to generate a Trial Balance from OTBIContent Hello : I was wondering if you can share with me any document how to create a trial Balance from OTBI . As f…gabriel kinovisques-163562 142 views 3 comments 3 points Most recent by TBIRD1 General Ledger & Intercompany -
Listing of Natural Accounts used by System ProcessesSummary: Summary: We would like to know and see if there is a listing of every GL Natural account that is referenced by Oracle as a system used account. Content (please …Trixia Shane 16 views 3 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany