- OracleApps Epicenter - http://www.oracleappshub.com -

Accounting fundamentals for Techies : Encumbrance

Before start of this topic you should be clear on these term;

So...What Are Commitments?
Commitments are obligations for future expenditures made , and this should be for an employee or vendor PO's. Commitments are tracked to help departments forecast their expenditures so that they do not exceed their budget available.

If you are using encumbrance you can get answer of these two question.

How much I left to spend , will be based out of these formula

Funds Available = Budget - Actual - Encumbrances.

budget is always unaltered, Encumbrances is reversed when matching to AP invoice.

Oracle Vanilla encumbrance accounting -Briefing

Oracle encumbrance accounting feature is supported by a process called funds reservation, which is implemented in the General Ledger as a user-exit or spawned program.

What is required if enabled Purchase Orders and Purchase Requisitions to first undergo a funds check when they are submitted. The system checks the line amount(s) of the requested purchase against the budget for the GL account(s) and alerts the user if that PO or Req. will exceed the funds on the account.This process of verification of available funds based on pre-defined summary templates.

Journals are then recorded in a special table called GL_BC_PACKETS, where they will sit temporarily before being converted by a concurrent process called “Program – Create journal” into permanent encumbrance journals.

The modules capable of initiating such transactions are the purchasing module for the creation of three documents, Standard Purchase Order, Requisition and Purchase Order Releases and the Accounts Payable module for the different invoices. It is possible to control the type of encumbrance created by these modules via the set-up of the applications.

The benefit of the encumbrance accounting feature is the ability to have the system control the expenditure budget from the General Ledger, reducing the risks of potential over expenditure.

This is often a legislated requirement for public organizations.

The transactional flow has funds reservation being performed through the GL_BC_PACKETS table when reserving funds for purchasing documents, and through the GL_INTERFACE table for receipt accruals which can be either On Receipt or at Period End. The funds checker process takes place whenever funds reservation and/or adjustment is made.

After transactions have taken place in Purchasing, it will become necessary to run the Create Journals program in GL. This program essentially sweeps through the GL_BC_PACKETS table and creates journals for the entries as entered.

Essentially this process allows the different manager to understand their “funds available” based on the following formula.

Funds Available = Budget – Actual – Encumbrance

The Oracle system has the ability to control this formula per fiscal period using the different balances tracked within GL_BALANCES (Essentially the General Ledger) by PTD (Period To Date), QTD (Quarter To Date), YTD (Year To Date),PJTD (Project To Date).

If you are coming from other Products like SAP or SUN , let clear these two terms in Oracle context in Project module specific.

Basic Oracle Process

The basic process flow for encumbrance accounting activity related to Oracle Purchasing typically is as follows:

  1. Create a requisition.
  2. Approve and reserve funds for the requisition.
  3. AutoCreate requisition onto a purchase order.
  4. Approve and reserve PO (which automatically reverses the requisition funds reservation)
  5. Receive against the purchase order (either period-end or online accruals) and the funds are reversed for the amount received and entered against the charge account.

Take a note, funds reversal also occur when documents are cancelled or finally closed.

Requisitions, when autocreated onto a purchase order, have their funds reversed either when the PO is approved and reserved or when the requisition line(s) are rejected or returned.

Oracle Product associated with encumbrance

Next will see Accounting Treatment in encumbrance.

2 Comments (Open | Close)

2 Comments To "Accounting fundamentals for Techies : Encumbrance"

#1 Comment By Jimi Akinola On October 26, 2010 @ 11:29 am

Dear Guru,

Kindly explain the accounting treatment of a ‘Reverse Charge’ transactions in AP Standard Invoice.


#2 Comment By Erik Krugliak On February 27, 2012 @ 4:41 am

Very useful explanation.
thank you very much for efforts to documents this.