Posts

Showing posts from June, 2025

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...

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...