Oracle Cloud ERP cheat sheet

Oracle Cloud ERP Business Process Essentials

• Oracle Cloud ERP is organized into pillars: Financials (GL, AP, AR, FA, Cash Management), Procurement (Purchasing, Self-Service Procurement, Supplier Portal), Project Management, and Enterprise Performance Management (EPM).

• The subledger-to-GL flow is: subledger transaction → subledger accounting (SLA) creates journal entries → transferred to GL → posted to update balances. Create Accounting and Transfer to GL are separate sequential steps.

• Multi-org structure: Enterprise (legal entity group) → Legal Entity → Business Unit → Ledger. A primary ledger holds the chart of accounts, calendar, and currency; a secondary ledger or reporting currency handles additional accounting or statutory needs.

• Chart of Accounts is composed of value sets (key flexfield segments). Each segment has a value set with validation type (independent, dependent, table, or subset) and a value hierarchy.

• Accounting period statuses progress from Never Opened → Open → Closed → Permanently Closed. Subledger periods can be open or closed independently of the GL period, but journals cannot post into a closed GL period.

• Three-way match in procurement compares purchase order, receipt, and supplier invoice. Match tolerances (quantity, price, amount) are configured at the invoice match rule level; exceptions are held for approval.

• Procure-to-pay flow: requisition → purchase order → receipt → invoice → payment → accounting. Order-to-cash flow: order → fulfillment/shipment → invoice → receipt → accounting.

• Approval workflows use the BPM Worklist with rules based on supervisory hierarchy, job level, or approval groups; parallel and serial approvers can be combined in a single stage.

• Journal entries must balance by ledger currency; entered currency amounts convert using the daily rates defined in the currency rate manager, and conversion rate types (Spot, Corporate, User) determine which rate is applied.