Oracle Apps ERP R12

 (For Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL), Fixed Assets (FA), and Cash Management (CM) ) 1. General Questions Q1: What is Oracle Financials in EBS? A: Oracle Financials is a suite of applications in Oracle EBS that includes modules like GL, AP, AR, FA, and CM , helping organizations manage financial transactions, reporting, and compliance. Q2: What are the key modules in Oracle Financials? A: General Ledger (GL): Manages accounting journals and financial reports. Accounts Payable (AP): Manages supplier invoices and payments. Accounts Receivable (AR): Handles customer invoices and receipts. Fixed Assets (FA): Tracks company assets and depreciation. Cash Management (CM): Manages bank reconciliations and cash flow. Q3: How does Oracle Financials integrate with other modules? A: AP integrates with PO and GL (Invoice creation, payment processing). AR integrates with OM and GL (Customer billing, receipt processing). FA integrates with AP and GL (...

  1. Basic Questions Q1: What is Oracle Accounts Payable? A: Oracle Accounts Payable (AP) is a subledger module in Oracle EBS that manages supplier invoices, payments, and liabilities. It integrates with General Ledger (GL), Purchasing (PO), and Cash Management (CE). Q2: What are the different types of invoices in Oracle Payables? A: Standard Invoice – Normal supplier invoice Credit Memo – Reduces the invoice amount Debit Memo – Increases liability to the supplier Prepayment – Advance payments to suppliers Expense Report – Employee reimbursements Mixed Invoice – Combination of debit and credit Q3: What is a Payables Open Interface? A: The Payables Open Interface (AP Interface) allows users to import invoices from external sources into Oracle Payables using the AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE tables. 2. Intermediate Questions Q4: What is the difference between Hold and Prepayment in AP? A: Hold: Prevents invoice payment due to validation failures (e....

Setting up Accounts Payable (AP) in Oracle E-Business Suite (EBS) involves configuring various components to manage supplier invoices, payments, and financial transactions efficiently. Below is a step-by-step guide on setting up Accounts Payable (AP) in Oracle EBS : 1. Define System Options Navigate to: Payables Manager → Setup → Options → Payables Options Configure: Invoice and Payment processing options Default currency , calendar , and accounting periods Tolerance levels for matching invoices to purchase orders (POs) 2. Define Financials Options Navigate to: Payables Manager → Setup → Options → Financials Options Configure: Set up legal entity and operating unit Define liability accounts , prepayment accounts , and other financial controls 3. Define Payment Terms Navigate to: Payables Manager → Setup → Invoice → Payment Terms Examples of payment terms: Net 30 (Payment due in 30 days) 2/10 Net 30 (2% discount if paid within 10 days, otherwise due in 30 days) 4. Define Supplier ...

 The Accounts Receivable (AR) module in Oracle R12 involves several tables that store data related to customer transactions, invoices, receipts, and more. Here's an overview of some key tables in the Oracle R12 Accounts Receivable module: Key Tables in Oracle R12 Accounts Receivable: RA_CUSTOMERS Purpose: Stores customer information. Key Columns: CUSTOMER_ID , CUSTOMER_NAME , STATUS , CUSTOMER_NUMBER RA_CUSTOMER_TRX_ALL Purpose: Stores invoice headers for all transactions such as invoices, credit memos, debit memos, etc. Key Columns: CUSTOMER_TRX_ID , TRX_NUMBER , TRX_DATE , BILL_TO_CUSTOMER_ID , STATUS RA_CUSTOMER_TRX_LINES_ALL Purpose: Stores the line-level details of transactions recorded in RA_CUSTOMER_TRX_ALL . Key Columns: CUSTOMER_TRX_LINE_ID , CUSTOMER_TRX_ID , LINE_NUMBER , DESCRIPTION , LINE_TYPE AR_RECEIVABLE_APPLICATIONS_ALL Purpose: Stores information about the application of receipts to invoices and other transactions. Key Columns: APPLICATION_ID , CASH_RECEIP...

In Oracle R12, the Accounts Payable (AP) module involves various tables that store data related to supplier invoices, payments, liabilities, and other financial transactions. Below is a table with the key Oracle R12 Accounts Payable tables, including a brief description of each: Table Name Description AP_INVOICES_ALL Stores information about supplier invoices. Each row includes details such as invoice number, invoice date, supplier information, and payment terms. AP_INVOICE_LINES_ALL Contains individual invoice line details, including descriptions, amounts, distributions, and accounting information for each line of an invoice. AP_INVOICE_DISTRIBUTIONS_ALL Stores distribution information for supplier invoices, such as accounting flexfields, line amounts, and GL accounts. AP_PAYMENT_SCHEDULES_ALL Holds information about payment schedules for invoices, inclu...

 The Order-to-Cash (O2C) cycle in Oracle R12 involves various transactions that generate accounting entries as goods or services are sold, shipped, invoiced, and payment is collected. Below is a detailed breakdown of the typical accounting entries generated during each step of the O2C cycle: 1. Sales Order Creation When a Sales Order (SO) is created, no accounting entries are generated. The order creation is a commitment from the customer and does not affect the financials until the goods or services are delivered or invoiced. 2. Shipping of Goods (Shipping Transaction) When goods are shipped to the customer, accounting entries are generated to reflect the reduction in inventory and the recognition of the Cost of Goods Sold (COGS). Dr. Cost of Goods Sold (COGS) Reflects the cost of the goods that are shipped to the customer. Cr. Inventory (Asset) Reduces the inventory account to reflect the goods leaving the inventory. 3. Invoicing the Customer (Invoice Creation) When an invoice is...

 The Procure-to-Pay (P2P) cycle in Oracle R12 involves various transactions that generate accounting entries as goods and services are purchased, received, and paid for. Below is a detailed breakdown of the typical accounting entries generated during each step of the P2P cycle: 1. Purchase Order Creation When a Purchase Order (PO) is created, there are no accounting entries recorded immediately. The creation of a PO is a commitment to purchase and does not impact the financials until the goods or services are received. 2. Receipt of Goods or Services (Receiving Transaction) When goods or services are received, accounting entries are generated to reflect the receipt in inventory or as an expense. The entries depend on whether the receipt is for inventory or direct charge (expense) items. a. Inventory Receipt (Accrual-Based) Dr. Inventory Material (Asset) Reflects the increase in inventory. Cr. Accrual (Receiving Inventory or Purchase Price Variance Account) Represents the liability...