Oracle Cloud Fusion Financials General Ledger (Module 1/5)

Learn cloud computing fundamentals, including what cloud computing is, deployment models, and services, while exploring remote cloud servers hosting Oracle Fusion ERP and usage-based pricing.

Explore cloud deployment models—private cloud for specific organizations, public cloud, and hybrid cloud—and note that fusion erp uses a private cloud only.

Explore cloud computing services and compare SaaS, PaaS, and IaaS. See how SaaS provides ready-made Oracle Fusion ERP with vendor maintenance and limited modifications.

Explore Cloud Fusion versions and the quarterly release cycle, learn the renaming scheme up to 25 B, and verify your server version using the about this application page.

Explore how to identify and enable Oracle Fusion offerings in the cloud, verify licensed financial and HCM functions, and manage enabled statuses on the Fusion server.

Create a new user in Oracle Cloud Fusion Foundation by logging in as admin and adding a user account in the security console, then sign in to verify restricted access.

Role based access control assigns screen access and privileges through four linked roles: abstract, job, duty, and data, combined as an access rule for a user.

Learn to use the security console to manage users and roles, grant admin access with the IT security manager role, and verify new users in Oracle Cloud Fusion Foundation.

Master the functional setup manager (FSM) to configure financial and other offerings in Oracle Fusion, assign access via the application implementation consultant role, and navigate security console and setup maintenance.

Create a Tata Motors implementation project in Oracle Cloud Fusion Financials, assigning financials and procurement offerings and granting access via implementation roles, set start date, and track progress.

Assign the employee role in the security console to grant access to the schedule process and expense report screens, then verify access and learn to run processes and reports.

Assign user roles in Oracle Cloud Fusion to control access to screens like security console, schedule process, and expense reports; admin and implementation roles grant project and FSCM access.

Introduce the general ledger concepts, subledger accounting, and how subledger transactions feed the general ledger, covering currency, calendar, chart of accounts, and trial balance.

Learn how currency determines transaction amounts and exchange rates, distinguish monetary currencies (INR, USD, GBP) from non-monetary stat currencies, and view or enable currencies in the application.

Create the mandatory accounting calendar in Oracle ERP Cloud Fusion, choosing between calendar year or fiscal year, define 365 periods plus an adjustment period, and set India’s fiscal year.

Define and implement a chart of accounts in Oracle Fusion by creating value sets and a structured flexfield with company, department, account, and intercompany segments.

Learn how to create and deploy a chart of accounts in Oracle Cloud Fusion Financials General Ledger, configuring the chart of account structure, instance, and dynamic combination creation.

Define seven value attributes and seven account types in Oracle Cloud Fusion Financials General Ledger, then create four segment values (company, department, account, intercompany) with example accounts and budgeting.

Explain accrual and cash basis accounting, showing how accrual records invoices and payments for accurate financial data. Contrast with cash basis, which records transactions only when cash is involved.

Learn to configure ledgers in Oracle Fusion Financials by defining currency, calendar, chart of accounts, and accounting method, creating a primary ledger and retained earnings, and running the accounting configuration.

Learn to grant general ledger access by assigning three roles: chief financial officer, controller, and financial analyst, and configuring data access to the primary ledger in Oracle Cloud Fusion Financials.

Understand open GL periods and their statuses, from never opened to permanently closed, and how entry and posting control access. Learn to open periods in the general ledger.

Learn to create manual general journals in the Oracle Fusion General Ledger, including batches, headers, and lines with debit and credit entries, posting to periods, and verifying balances.

Generate the general ledger trial balance report in Oracle Cloud Fusion Financials, configuring the primary ledger, currency, and period to prepare the profit and loss account and balance sheet.

Explore the Oracle cloud fusion enterprise structure for general ledger, covering enterprise, division, ledger, legal entity, business unit, inventory and sub inventory, with multinational examples and implementation approaches.

Explore manual enterprise structure setups in oracle cloud fusion financials, creating legal entities, legal addresses, assigning to lecture, balancing segment values, reference data sets, locations, and business units.

Create and configure enterprise structure for Oracle Fusion Financials by setting up a business unit, assigning accounts payable, procurement management, and receivables, and linking legal entity and reference data set.

Expand your Oracle Fusion general ledger with rapid implementation, automatically create enterprise structure via a spreadsheet template, and validate and generate chart of accounts and ledgers for entities and units.

Accelerate enterprise structure creation through rapid implementation by uploading chart of accounts, ledger, legal entities, and business units, configuring calendars, values, and hierarchies in the Fusion server.

Create and post journal batches in Oracle Cloud Fusion Financials General Ledger using rapid implementation, manual creation, and category-driven lines to manage rent and miscellaneous expenses.

Use auto copy to duplicate and rename an existing general batch, then post and verify the batch status and updated balances reflect the new postings.

Learn to perform journal reversal in Oracle Fusion General Ledger using the switch debit and credit method; create a reversal journal with opposite lines to zero the original entry.

Apply the change sign method to create a reversal journal with opposite sign to the original entry, yielding zero net impact.

Create a suspense account and enable it at the ledger level, then post unbalanced journals and move the difference to the correct account; verify the suspense line after posting.

Create and manage general categories in Oracle Cloud Fusion General Ledger, defining the purpose of each entry, and add custom categories like rent and stationary while using seeded categories.

Create general ledger journals in Oracle Fusion using a spreadsheet by installing ADF Desktop Integrator, enabling macros, entering data, uploading, and running the general import to post.

Explore how general sources drive journal entries in Oracle cloud fusion general ledger, distinguishing manual, auto copy, spreadsheet, payables, receivables, and payroll sources, including custom sources for legacy-to-cloud data transfer.

Explore the FBDI journal process for Oracle Fusion General Ledger, from downloading templates to uploading zip files, loading interface, importing generals, and posting batches.

Learn how to auto post general ledger journals by scheduling an auto post process with selection criteria, then verify postings automatically.

Learn how to automatically reverse journals in Oracle Cloud Fusion General Ledger by creating auto reversal criteria, selecting rent category, and enabling reverse and post automatically, then verify results.

Enable sequential numbering in the Oracle Fusion general ledger, set a starting number like 5000, and assign it across all journals.

Learn how to create and manage conversion rate types and daily exchange rates in Oracle Fusion Financials, including corporate, user, and market rates, and verify conversions.

Create and configure a reporting ledger in Oracle Cloud Fusion Financials to translate INR transactions to USD using corporate rates, rounding, and period management.

Translate functional currency balances to foreign currencies using period average, period end, and historical rates, converting assets, liabilities, expenses, and owner's equity for USD reporting via a translated trial balance.

Revaluation of foreign currency transactions in Oracle Fusion Cloud ERP's general ledger identifies unrealized gains or losses due to exchange rate fluctuations and posts the adjustments.

This lecture explains primary and secondary literature in Oracle Cloud Fusion General Ledger, detailing data transfer to the secondary ledger, five-segment chart of accounts, currency differences, and 14 setup steps.

Configure a secondary ledger in oracle cloud fusion general ledger by creating it and mapping its chart of accounts. Post from primary to secondary, open periods, and verify in journals.

Consolidate multiple ledgers into a single consolidation ledger in Oracle Fusion Financials. If currencies differ, create secondary or reporting ledgers, map accounts, transfer balances, and verify postings.

Define security rules to restrict segment values in a value set, enabling access for selected companies, deploy the chart of accounts flexfield, and verify results with general journals.

Cross validation rules prevent unwanted chart of accounts combinations, such as company ten with department 120. Define rule at chart of accounts level and verify with a journal entry denial.

Create and assign data access set in Oracle cloud fusion general ledger to grant read or write access to full ledger or specific primary balancing segment values, then verify results.

Learn to create ledger sets that group ledgers with identical calendar and chart of accounts. Assign roles and data access, then verify results and switch between default and consolidation ledgers.

Learn to enable and deploy aliases in Oracle Cloud Fusion General Ledger, defining short names for common account combinations to speed journal entries by using aliases instead of segment values.

Understand how the ldap process synchronizes roles between Oracle Cloud Fusion general ledger users and the ldap directory, now automatic after upgrades.

Learn how to close and reopen a general ledger period in Oracle Cloud Fusion, including transitioning between open and closed statuses and the implications of permanent closure.

Discover how to set up and run a budget in Oracle Fusion Financials general ledger, from enabling budgetary control to creating budgets, importing, reviewing, and posting budgeted entries.

Learn how a descriptive flexfield adds additional fields to Oracle cloud fusion general ledger screens without coding, configure a value set, and deploy and verify the result across GL screens.

Learn to create and configure a transaction calendar in Oracle Cloud Fusion Financials, define holidays and working days, and apply the average balance concept to identify working and holiday days.

Explore the combinations window in Oracle cloud fusion general ledger, learn to disable or enable account code combinations and create new ones, including dynamic creation versus manual setup.

learn to assign a default value to the intercompany segment in oracle cloud fusion financials general ledger, enabling automatic 00 in the fourth segment and streamlined journal entries.

Learn to design and manage account hierarchies in Oracle cloud fusion general ledger by creating value sets, building a chart of accounts, configuring a ledger, and publishing hierarchies to Essbase.

Discover how to build income statements in Oracle Cloud Fusion using Financial Reporting Studio, linking revenue and expense accounts to Essbase balances for the general ledger.

Create OTBI reports in Oracle Fusion General Ledger using predefined subject areas and drag-and-drop tools to select columns, filters, and output formats, then save and export to PDF.