Oracle DBA & Oracle Fusion Cloud

   Understanding the Chart of Accounts (COA): The Financial Backbone of Every Organization  Introduction In every organization, whether it’s a small business or a global enterprise, accounting forms the heart of financial management . To keep that heart beating in rhythm, companies rely on a well-defined Chart of Accounts (COA) a structured framework that organises  financial data into meaningful segments. A Chart of Accounts is more than just a list of accounts; it’s the foundation of all accounting activities , determining how each transaction is identified, recorded, and reported.  What is a Chart of Accounts? The Chart of Accounts (COA) represents the complete accounting structure of an organization. It defines how transactions are classified into different accounts, departments, and business dimensions. In simple terms, think of the COA as a blueprint that tells your accounting system where to record every rupee spent or earned. Each organization...

                                                     Currency Creation 1. What is Currency? Currency represents the monetary unit used to measure and record financial transactions. Every country has its own official currency , such as: 🇮🇳 INR — Indian Rupee 🇺🇸 USD — US Dollar 🇬🇧 GBP — British Pound In Oracle Financials, currencies play a key role in recording, reporting, and converting business transactions across different countries.   2. Types of Currency in Oracle Oracle classifies currency into two main categories: Monetary Currency Non-Monetary Currency   2.1 Monetary Currency Monetary currency is used to record the actual monetary value of day-to-day business transactions. Examples: INR , USD , GBP , EUR , etc. There are two subtypes of Monetary Currenc...

                                     Fusion General Ledger Introduction 1. What is GL in Oracle Fusion Cloud Finance ? GL = General Ledger The General Ledger (GL) is the central accounting hub of Oracle Fusion Cloud Financials. It is where all financial transactions from different modules (such as Payables , Receivables , Assets , and Cash Management ) are recorded, summarised, and reported. Key Functions of GL Record Transactions All journal entries from sub- ledgers (AP, AR, FA, etc.) flow into the GL. You can also create manual journals directly in GL. Financial Reporting GL provides real-time financial data for generating trial balances , balance sheets , profit and loss statements, and other statutory reports . Chart of Accounts (CoA) GL uses a structured Chart of Accounts to classify and record transacti...

   Database Credentials in Oracle Wallet When managing Oracle Databases, storing user credentials in plain text inside scripts is a major security risk. Oracle provides a secure solution with Oracle Wallet , which allows you to store database credentials in an encrypted location. Once configured, applications and utilities like Data Pump or JDBC can connect without requiring a clear-text password. This blog walks through the step-by-step procedure to store database credentials in Oracle Wallet and use it securely. Overview The Oracle Wallet securely stores database credentials, eliminating the need to expose passwords in scripts. Multiple credentials can be stored in a single wallet. Supports auto-login , meaning applications don’t need a password to access it. OS file permissions ensure security. In this example, a non-Oracle binary owner OS user ( bidhan ) is used to create the wallet. Example usage: Data Pump with Wallet nohup expdp /@BSA1EP directory=...

  Oracle 19c Active Data Guard Switchover Procedure Oracle Active Data Guard provides high availability and disaster recovery by allowing seamless role transitions between the primary and standby databases. A switchover is a planned role reversal where the primary database becomes the standby, and the standby takes over as the new primary without data loss. This guide covers the step-by-step procedure for switchover in Oracle 19c Active Data Guard . 1. Pre-Checks Before initiating a switchover, ensure both databases are synchronized and healthy. On both primary and standby : SELECT DATABASE_ROLE, OPEN_MODE FROM V$DATABASE; Primary should show: PRIMARY , READ WRITE Standby should show: PHYSICAL STANDBY , READ ONLY WITH APPLY or MOUNTED Also, confirm there are no active sessions or long-running transactions on the primary. 2. Verify Log Transport and Apply Ensure redo logs are being shipped and applied correctly. On Primary : SELECT DEST_ID, STATUS, ERRO...