My Oracle Support Banner

R12: AP/PO: MASTER TROUBLESHOOTING GUIDE (MTG) for Encumbrance Accounting Issues [VIDEO] (Doc ID 1578275.1)

Last updated on DECEMBER 24, 2018

Applies to:

Oracle Purchasing - Version 12.0.0 and later
Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Purpose

This Master Troubleshooting Guide (MTG) is intended to teach you about the processes involved in creating and maintaining encumbrance accounting in Oracle Purchasing and Payables (and General Ledger).  This MTG also guides you through a sequential set of steps that will help to facilitate troubleshooting encumbrance issues in Release12.

  SCROLL UP TO SEE TABLE OF CONTENTS

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Purpose
Troubleshooting Steps
 1075757.1:9 1. What is "Encumbrance" Accounting?
         Encumbrance Accounting defined
         Oracle's Budgetary Control and Online Funds Checking features
  
 1075757.1:6  2. How does Encumbrance Accounting work in Oracle's financial applications?
        Encumbrance Accounting in Oracle's PURCHASING application
        Encumbrance Accounting in Oracle's PAYABLES application
        Encumbrance Accounting process flow in Oracle's GENERAL LEDGER application
        Real-Life Examples of the Accounting Behind Encumbrance Transactions, and How to View The Accounting Online
        Transactional Data Flow from PO to GL
        Encumbrance activities in Purchasing Workflows
  
 Gold star icon  3. Best Practices (Internal only)
 
 1305001.1:007  4. Funds Reservation Statuses on Oracle Purchasing documents (Requisitions and POs)
         INCOMPLETE
         IN PROCESS
         APPROVED
         PRE-APPROVED
         RETURNED
         REJECTED
         REQUIRES REAPPROVAL
  
 1075757.1:6  5. Required Setups
        GENERAL LEDGER setups for encumbrance processing
        PURCHASING & PAYABLES setups for encumbrance processing
  
 1305001.1:015  6. Seeded Oracle Reports related to Encumbrance Accounting
        Encumbrance Detail Report (PO)
        Encumbrance Trial Balance Report (GL)
        Encumbrance - Encumbrance Account Details Report (GL)
        Encumbrance - Encumbrance Document Details Report (GL)
        Open Encumbrance Balance With Transaction Detail Report (GL)
 
 1320497.1:012  7. CRITICAL:  Rollups, Recommended Patch Collections, and Recommended Patches for Encumbrance Accounting
         Roll-up Patch (RUP) for Oracle PURCHASING
         Recommended Patch Collections (RPCs) for Oracle PAYABLES and GENERAL LEDGER
         Recommended Patch Collections (RPCs) for Oracle PUBLIC SECTOR FINANCIALS
         Minimum Patch Requirements for SUB-LEDGER ACCOUNTING
 
 1320497.1:012  8. Diagnostic Tools
         CONCURRENT PROCESS LOG FILES
         FND DEBUG LOGS/TRACE FILES
         PROCUREMENT ENCUMBRANCE ACCOUNTING ANALYZER  
         DIAGNOSTIC SCRIPTS 
         APPLICATION DIAGNOSTIC OUTPUTS - PURCHASING
         APPLICATION DIAGNOSTIC OUTPUTS - PAYABLES
         APPLICATION DIAGNOSTIC OUTPUTS - GENERAL LEDGER
  
 1305001.1:006  9. HOT TOPICS
         a.  Incorrect Encumbered Amount in PO Distributions for a Canceled/Finally Closed/Open Purchase Order
         b.  Upgrading User Defined Encumbrance Types from R11i To R12
  
 1320497.1:012  10. MORE RESOURCES FOR HELP with Encumbrance Accounting Issues
  PURCHASING (PO)
  PAYABLES (AP)
  GENERAL LEDGER (GL)
  OTHER
  
  
 Standard Patching Process
 Patch Wizard
 Have more questions?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.