Smart View and Financial Reporting Studio are two reporting tools that allow you to create and include charts such as bar graphs in your financial statements. Smart View is a multidimensional pivot analysis tool that enables you to interactively analyze your balances and define reports using a familiar spreadsheet environment. You can also insert charts and graphs to visualize your data. Financial Reporting Studio is a tool that lets you design and format financial reports using data from the Oracle General Ledger balances cube. You can also add charts and graphs to enhance your reports and display data trends. References:

• Overview of Financial Reporting Center, Oracle Cloud Applications Financials 23B, https://docs.oracle.com/en/cloud/saas/financials/23b/faiah/overview-of-financial-reporting-center.html
• Using Smart View with Oracle Financials Cloud, Oracle Cloud Applications Financials 23B, https://docs.oracle.com/en/cloud/saas/financials/23b/fasvf/using-smart-view-with-oracle-financials-cloud.html
• Creating Financial Reports, Oracle Cloud Applications Financials 23B, https://docs.oracle.com/en/cloud/saas/financials/23b/farug/creating-financial-reports.html

To keep a thin secondary ledger, you should select the balance level as the data conversion level. This means that only the ending balances of the primary ledger are copied to the secondary ledger at the end of each period. This reduces the data volume and storage requirements of the secondary ledger, as well as the processing time and resources needed to copy the data. The balance level conversion is suitable for scenarios where the accounting methods or charts of accounts are similar between the primary and secondary ledgers, and there is no need to maintain detailed journals or subledger transactions in the secondary ledger. References: Primary Ledgers, Secondary Ledgers, and Reporting Currencies, How Journals Are Copied from Primary to Secondary Ledgers When …, GL Secondary Ledger Conversion Level Change

 Here are the steps you need to follow:

• In the Setup and Maintenance work area, go to the following:
• Select the source chart of accounts (UK) and the target chart of accounts (CA) that you want to map.
• Click on the Segment Rules tab to define the segment mapping rules. Enter the following information for each segment:
• Click on the Save and Close button to save the segment mapping rules.

You have successfully created a Chart of Accounts mapping for the given scenario. For more information, you can refer to the following resources:

• Overview of the Chart of Accounts Mapping Page
• Chart of Accounts Structures and Instances
• How To Create A Chart Of Accounts Mapping For A Secondary Ledger
• How To Bulk Upload The Mapping Rules In “Manage Chart of Accounts Mapping”
• Centralized Management of Chart of Accounts Configurations