BIApps 7.9.6.x – Configuration for COA (Chart of Accounts)

Here we will discuss howto configure Chart of accounts and Account grouping In BI Apps Financial Analytics 7.9.6.x What is Chart of Account – The Chart of Account Structure (also known as the ‘Accounting Flexfield’) is an underlying foundation component used by Oracle Apps to track transactions that have a financial impact. The Accounting Flexfield is used in Oracle…

Oracle EBS GL (General Ledger) data flow

The General Ledger will collect and store financial activity information from the other modules, and will be the module that best reflects the overall financial condition of the company. Because of this, the General Ledger is typically heavily used for financial reporting from OBIEE, OBIA, or other tools. Many of the other Oracle Applications modules are…

Oracle EBS AR (Receivables) Data Flow

The Accounts Receivable function is responsible for managing outgoing invoices to customers who purchased goods or services, and the collection and application of all payments, including payments for invoices. Customer records are stored in the HZ_CUST_ACCOUNTS and HZ_PARTIES tables.  Each customer needs to have a site (a location/address of business) for which information is stored…

Oracle EBS AP (Payables) Data Flow

This note gives a general idea of how records are stored in and moves through the EBS Payables module. In Oracle Payables, before an AP transaction can be generated, a supplier must exist in the system.  Suppliers are created in AP_SUPPLIERS and AP_SUPPLIER_SITES.  Invoices are saved in AP_INVOICES (invoice header) and AP_INVOICE_LINES (invoice lines). Payments generate…