Financial Reporting
Discussion List
-
Is there an out of the box trial balance report that can be run over multiple years?Summary: We are looking to see if there is currently a TB report within scheduled processes that could be run over multiple years. Content (please ensure you mask any co…Casey Kempel 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Excel Add-ins to export TB directly from Fusion applications to Excel directly.Summary: Excel Add-ins to export TB directly from Fusion applications to Excel directly. Content (please ensure you mask any confidential information): Business would to… -
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 1 view 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 11 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 11 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 11 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 11 views 2 comments 0 points Most recent by Kalana Prasad General Ledger & Intercompany -
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 11 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 21 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 11 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 25 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 12 views 1 comment 0 points Most recent by Hemalata-Oracle1-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… -
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 33 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 11 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 31 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 11 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 1 view 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 1 view 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 11 views 1 comment 0 points Most recent by MiaM-Oracle Subledger Accounting & Accounting Hub