Posts

Accrual reconciliation when using Accrue Expense Items at Receipt in Oracle EBS R12 or Oracle Fusion.

 1. SLA Accounting Rules (Subledger Accounting Setup) When you’re using Accrue at Receipt , Oracle needs to know which accounts to use during different steps of the P2P process. SLA handles this through Journal Line Definitions (JLD) and Account Derivation Rules (ADR) .  A. Typical Accounting Setup in SLA for Expense Items at Receipt Event Debit Credit Description Receiving (Expense Destination) Charge Account (from PO) Accrual Account Accrual created immediately at receipt Invoice Matching Accrual Account AP Liability Reverses accrual and creates liability Payment AP Liability Cash/Bank Standard AP payment Optional Enhancements via SLA : Add cost center segments from PO distribution. Use item category to change accounts. Override based on supplier site or BU .B. Example Account Derivation Rule Let’s say you want the credit accrual account to vary by item category. Your rule tree can look like: java IF Item Category = 'IT_HARDWARE' THEN use Accrual A...
Post a Comment
Read more

AP Accrual at Receipt in Oracle R12

 what really happens in Oracle E-Business Suite/Oracle Fusion Procurement & Payables when you set Accrue Expense Items = “At Receipt” (sometimes called Perpetual Accrual ). I’ve broken it into the three moments you actually care about— Receipt, Invoice, and Period Close/Reconciliation —plus the key setup switches that drive it. 1. Key setup you need to double-check Module Form / Task Field / Profile What it must be Why it matters Purchasing Purchasing Options Accrue Expense Items At Receipt (not Period End ) Tells the Receiving Transaction Processor (RTP) to book an accrual the instant you do the receipt. Receiving Receiving Options (supplier & org) Expense AP Accrual Account A suspense / clearing account Credited at receipt and debited when the invoice posts. Payables Financial Options Liability Account Your trade AP control Credited when the invoice is accounted. Sub-ledger acct. rules (SLA) (optional) Override rules Only if you need different accounts by item categ...
Post a Comment
Read more

Interview Questions for Oracle Apps Finance Functional Consultant

 (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 (...
Post a Comment
Read more

Interview Questions for AP in ORACLE APPS

  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....
Post a Comment
Read more

Accounts payable setup in oracle apps EBS

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 ...
Post a Comment
Read more

Table of Account Receivables in oracle R12

 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...
Post a Comment
Read more

Tables of Accounts Payable In Oracle R12

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...
Post a Comment
Read more