Posts

Oracle EBS R12 Finance BR100: Complete Guide with Sample Template

  Oracle EBS R12 Finance BR100 – Business Requirements and Configuration Document If you are working as an Oracle EBS R12 Finance Functional Consultant , you have probably heard the term BR100 many times. But what exactly is a BR100? What information should be included in a BR100? How do you prepare a BR100 for an Oracle EBS Finance implementation? And what does a real consultant-level BR100 look like? In this article, we will understand Oracle EBS R12 Finance BR100 from a practical implementation perspective, including its purpose, structure, setup requirements, sample business requirements, configuration details, testing considerations, and a sample BR100 template. What is BR100 in Oracle EBS R12? A BR100 is commonly used as a functional/business requirements and configuration document in Oracle implementation projects. It documents the business requirements and translates them into the proposed Oracle EBS solution/configuration. In simple words: Business Requirement → Or...

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