My Oracle Support Banner

R11i/12: Master Note For Oracle EBS Procurement Suite - Encumbrance And Accrual Accounting (Doc ID 1138043.1)

Last updated on MARCH 05, 2018

Applies to:

Oracle Purchasing - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Details

This document is a master note matrix for Oracle EBS Procurement - Accounting (Encumbrance and Accrual) functional area. The note lists some of the high volume technical problem categories in the  Encumbrance and Accrual Accounting functional area.

Technical problem categories in Encumbrance and Accrual Accounting
ENCUMBRANCE
Encumbrance - Setup and usage
Funds check / Reserve issues for Purchasing documents
Incorrect Active encumbrance, Encumbered amount / Encumbrance not relieved for purchasing documents
Funds Inquiry Form - Incorrect Budget/Actual/Encumbrance values
Encumbrance Detailed report and Encumbrance account balance Reconciliation Discrepancies
Invalid/Draft events on Subledger Period Close Exceptions Report in SLA for the source Purchasing
 
ACCRUALS
Online Accrual issues - Accrue at receipt
Period end Accruals - Accrue at period end and Uninvoiced Receipts Report (URR)
11i - Accrual Reconciliation process and reports
R12 - Accrual Reconciliation process and reports
 
OTHERS
Account Generator issues
SLA Account Derivation Rules for Encumbrance and Accrual Accounting
Center-Led or Global Procurement Accounting
Landed Cost Management Accounting
GL Transfer and Posting issues Receiving/Purchases/Requisitions category
GL Drilldown issues for Receiving/Purchases/Requisitions category



Each of the problem categories will have the following sections based on the scope of the problem category in a tabular format for easy navigation.

Depending on the issue, Customers should choose the relevant problem category and use the documents specified in the category by matching the issue with the technical problem categories listed and use it for issue resolution.

It is highly recommended that customers are familiar with the knowledge content in the white paper section and FAQ section for the problem category relevant to the issue at hand before the troubleshooting notes can be used for issue resolution.

Actions

If you do not find a solution for your issue from the documents specified under the relevant problem category for your issue here, please log a Service request with Oracle Support.

Functional Area wise Problem Categories and the relevant documentations:

Encumbrance - Setup and usage

Technical Problem CategoryWhitepaper (Feature specific)FAQ (Scenario based explanations)Troubleshooting Content

Code Fixes
Encumbrance - Setup and usage <Note.121858.1> - Purchasing Encumbrance Accounting Concepts and Process Model

<Note.389485.1> -Encumbrance and Funds Inquiry - Setup and Usage

<Note.386807.1> - Accounting Flow For Purchase Orders, Receipts and Matched Invoices in an Encumbrance Environment

<Note.429105.1> - Impact of R12 Design in Procure To Pay Accounting Flow

<Note.1086669.1> - FAQ Encumbrance Accounting - Setup And Usage <Note 1483743.1> - R12: Diagnostic Script to help troubleshoot Purchasing Encumbrance Issues <Note.1198703.1> - Encumbrance - Setup And Usage - List Of Code Fixes

 

Funds check/ Reserve issues for Purchasing documents

Technical Problem CategoryWhitepaper (Feature specific)FAQ (Scenario based explanations)Troubleshooting Content

Master Note for Code Fixes
Budgetary control exception and incorrect funds check behavior:

  • PR/PO goes to Pre-approved status/fails funds check with Error - This detail transaction fails funds check/causes a summary account to fail funds check/Procedure Psa_bc_xla_pub.Budgetary_control Returns An Error
  • PR/PO fails funds check inspite of using override limit
  • PR/PO gets approved inspite of insufficient funds
Not relevant Not relevant <Note.603057.1> - R12: Purchasing Documents Fail Funds Check Or Going To Pre-approved Status Due To Budgetary Control Exceptions - Troubleshooting

<Note. 1121356.1> - R11i: Purchasing Documents Fail Funds Check Or Going To Pre-approved Status Due To Budgetary Control Exceptions - Troubleshooting



<Note.1176943.1> - Budgetary Control Exceptions And Incorrect Funds Check Behavior - List Of Code Fixes
Issues with Budgetary Control Results page which gets opened on clicking the 'View results' when funds check is done or RESERVE action is done for PR/PO Not relevant Not relevant
Not relevant




<Note.1175415.1> - Issues With Budgetary Control Results Page - List Of Code Fixes
Unable to unreserve purchasing documents
  • Error occurs while rejecting/cancel/final close/unreserve Purchase Order
  • Error occurs while returning/cancel/final close/unreserve Purchase Requisitions
Not relevant Not relevant <Note.352096.1> - Cannot Unreserve or Cancel Autocreated Purchase Order <Note.1268719.1> - Unable To Unreserve/Cancel/Final Close Purchasing Documents - List Of Code Fixes

 

Incorrect encumbered amount, active encumbrance / Encumbrance not relieved for purchasing documents

 

Technical Problem CategoryWhitepaper (Feature specific)FAQ (Scenario based explanations)Troubleshooting ContentMaster Note for Code Fixes
Active Encumbrance exists/ Encumbrance not relieved for purchasing documents / Incorrect encumbered amount for purchase orders Not relevant Not relevant <Note.742621.1> - 11i: Active Encumbrance Exists Or Incorrect Encumbered Amount Exists For Purchase Order - Troubleshooting

<Note.1208403.1> - Active Encumbrance Exists/ Incorrect encumbered amount In PO Distributions - List Of Code Fixes
 

Fund Inquiry Form - Incorrect Budget/Actual/Encumbrance/Funds available values

 

Technical Problem CategoryWhitepaper (Feature specific)FAQ (Scenario based explanations)Troubleshooting Content

Master Note for Code Fixes
Negative encumbrance Not relevant Not relevant <Note.949876.1> - Under What Circumstances Negative Encumbrance Occur In Funds Inquiry Screen Not relevant
Negative Funds Not relevant Not relevant <Note.1284260.1> -Negative Funds Shown In GL Funds Inquiry Form Not relevant
Outstanding commitment /obligation or Commitment /Obligation not reversed Not relevant Not relevant <Note.742621.1> - 11i: Active Encumbrance Exists Or Incorrect Encumbered Amount Exists For Purchase Order - Troubleshooting <Note.1208403.1> - Active Encumbrance Exists/ Incorrect encumbered amount In PO Distributions - List Of Code Fixes
Encumbrance not converted to Actuals Not relevant Not relevant <Note.728064.1> - R12 Encumbrance Not Getting Converted To Actuals For Purchase Orders Not relevant
Encumbrance Reversal and Actuals hitting the Funds Inquiry at two different times Not relevant Not relevant <Note.728064.1> - R12 Encumbrance Not Getting Converted To Actuals For Purchase Orders Not relevant

 

Encumbrance Detailed report &Encumbrance account balance Reconciliation Discrepancies

Technical Problem CategoryWhitepaper (Feature specific)FAQ (Scenario based explanations)Troubleshooting ContentMaster Note for Code Fixes
Encumbrance Detailed report - Discrepancies Not relevant Not relevant Yet to create content <Note.1269845.1> Encumbrance Detail Report - List Of Code Fixes
Encumbrance account Reconciliation Not relevant Not relevant Yet to create content Not relevant

 

Invalid/Draft events on Subledger Period Close Exceptions Report in SLA for the source Purchasing

Technical Problem CategoryWhitepaper (Feature specific)FAQ (Scenario based explanations)Troubleshooting ContentMaster Note for Code Fixes
R12 Subledger Period Close Exceptions Report showing Invalid/Draft events in SLA for the source Purchasing Datafix at Behive datafix page Datafix at Behive datafix page Not relevant Not relevant

 

Online Accrual issues - Accrue at receipt

Technical Problem CategoryWhitepaper (Feature specific)FAQ (Scenario based explanations)Troubleshooting ContentMaster Note for Code Fixes
Accrual Accounting - Online Accruals <Note.386807.1> - Accounting Flow For Purchase Orders, Receipts and Matched Invoices in an Encumbrance Environment

<Note.429105.1> - Impact of R12 Design in Procure To Pay Accounting Flow

<Note.1107966.1> - FAQ: Accrual Accounting - Online Accruals &Period end Accruals in R11.5.10


<Note.824388.1> - R12 Account Requirements For Inventory Accrual Reconciliation

Not relevant Not relevant
R12 - Issues related to Online Accruals (Pos set to accrue at receipt) and Create Accounting Process errors Not relevant Not relevant <Note.558421.1> - How To Diagnose Issues With Create Accounting Process For Procure To Pay Cycle In R12 <Note.1179643.1> - Issues related to R12 Create Accounting Process - List Of Code Fixes
11i - Missing/Incorrect Accounting entries for Online Accruals in Receiving subledger/gl_interface/GL Not relevant Not relevant <Note.364575.1> - Purchasing Receiving Accrual Records Missing in GL_INTERFACE/GL Tables <Note.1174420.1> - Missing Accounting Entries Or Incorrect Accounting Entries In Procure To Pay Flow - List Of Code Fixes
R12 - Missing/Incorrect Accounting entries for Online Accruals in Receiving subledger/SLA/GL Not relevant Not relevant Yet to create content <Note.1174420.1> - Missing Accounting Entries Or Incorrect Accounting Entries In Procure To Pay Flow - List Of Code Fixes

 

Period end Accruals - Accrue at period end and Uninvoiced Receipts Report (URR)

 

Technical Problem CategoryWhitepaper (Feature specific)FAQ (Scenario based explanations)Troubleshooting ContentMaster Note for Code Fixes
Accrual Accounting - Period end Accruals <Note.467584.1> - What Are The Basic Steps Of The Purchasing Receipt Accrual Period-End Process?

<Note.386807.1> - Accounting Flow For Purchase Orders, Receipts and Matched Invoices in an Encumbrance Environment

<Note.429105.1> - Impact of R12 Design in Procure To Pay Accounting Flow
<Note.1107966.1> - FAQ: Accrual Accounting - Online Accruals and Period end Accruals in R11.5.10


Not relevant Not relevant
Issues related to Uninvoiced Receipts Report (URR) and Period end Accruals (Pos set to accrue at period end) and Create Accounting Process/Subledger Multiperiod accounting Process Not relevant Not relevant <Note.1279848.1> - R12: Discrepancies with period end accrual - Troubleshooting

<Note.1145884.1> - Errors And Discrepancies With Uninvoiced Receipts Report (URR) and Receipt Accrual Period End Process - List Of Code Fixes

11i - Missing/Incorrect Accounting entries for Period end Accruals in Receiving subledger / gl_interface/GL Not relevant Not relevant <Note.1279848.1> - R12: Discrepancies with period end accrual - Troubleshooting  <Note.1174420.1> - Missing Accounting Entries Or Incorrect Accounting Entries In Procure To Pay Flow - List Of Code Fixes
R12 - Missing/Incorrect Accounting entries for Period end Accruals in Receiving subledger/SLA/GL Not relevant Not relevant <Note.873399.1> - R12 Receipt Accrual Period end process - Duplicate accrual reversal entries created

<Note.1174420.1> - Missing Accounting Entries Or Incorrect Accounting Entries In Procure To Pay Flow - List Of Code Fixes
Accrual Reconciliation in Period end Accruals Not relevant Not relevant   Not relevant

11i - Accrual Reconciliation process and reports

Technical Problem CategoryWhitepaper (Feature specific)FAQ (Scenario based explanations)

Troubleshooting ContentMaster Note for Code Fixes
11i - Accrual reconciliation process and Write-Off process Not relevant <Note.1107966.1> - FAQ: Accrual Accounting - Online Accruals and Period end Accruals in R11.5.10 Not relevant Not relevant
11i - Accrual Rebuild report/Accrual reconciliation report (ARR) - Errors and Discrepancies Not relevant Not relevant Yet to create content <Note.427771.1> - 11.5.10 Accrual Reconciliation Report - Latest Fixes as of March 1, 2010
11i - Accrual balance shown in ARR does not match with GL accrual balance Not relevant Not relevant <Note.1136813.1> - 11i Accrual Balance Mismatch Between Accrual Reconciliation Report and GL - Troubleshooting Not relevant

R12 - Accrual Reconciliation process and reports

Technical Problem CategoryWhitepaper (Feature specific)FAQ (Scenario based explanations)Troubleshooting ContentMaster Note for Code Fixes
Accrual Reconciliation and Write off Process <Note.429105.1> - Impact of R12 Design in Procure To Pay Accounting Flow

<Note. 728871.1> - R12 How To Diagnose And Reconcile Inventory AP Accrual Transactions Using Reconciliation Reports
<Note.824388.1> - R12 Account Requirements For Inventory Accrual Reconciliation Not relevant Not relevant
Accrual load run program/AP PO Reconciliation report errors Not relevant Not relevant
<Note.429235.1> - Accrual Reconciliation Load Run Errors:The Accrual Accounts for this Operating Unit have not been selected
Yet to create content
Accrual balance shown in ARR does not match with GL accrual balance Not relevant Not relevant
<Note.1107953.1> - R12 Accrual Balance Mismatch Between Accrual Reconciliation Report and GL - Troubleshooting
Not relevant
Discrepancies with Accrual Reconciliation Report Not relevant Not relevant <Note.1117353.1> - Discrepancies with Accrual Reconciliation Report - Troubleshooting Yet to create content
Discrepancies With Accrual Reconciliation Report For Consigned Items Not relevant Not relevant
<Note.1126025.1> - R12: Discrepancies With Accrual Reconciliation Report For Consigned Items - Troubleshooting
Yet to create content
Discrepancies with Accrual write-off report and write-off transactions <Note.866733.1> - How To Diagnose Inventory Accruals And Accrual Write Off Issues Not relevant Yet to create content Yet to create content

Account Generator issues

Technical Problem CategoryWhitepaper (Feature specific)FAQ (Scenario based explanations)Troubleshooting ContentMaster Note for Code Fixes
Defaulting of accounts <Note.245096.1> - Setup and Defaulting of Accounts in a Purchasing Encumbrance Environment

<Note.293046.1> - How to Set Up and Use Category-based Account Default in Purchasing


<Note.216831.1> - FAQ: Account Generator Not relevant Not relevant
Account generator errors - e.g. &quot;Please enter a valid charge account&quot; Not relevant Not relevant Yet to create content Yet to create content

SLA Account Derivation Rules for Encumbrance and Accrual Accounting

Technical Problem CategoryWhitepaper (Feature specific)FAQ (Scenario based explanations)Troubleshooting ContentMaster Note for Code Fixes
Issues related to Account Derivation Rules <Note.797115.1> - How To Derive Accounts Using Account Derivation Rules in R12 SLA Architecture Not relevant Not relevant Not relevant

 

GL Transfer and Posting issues for Receiving/Purchases/Requisitions category

Technical Problem CategoryWhitepaper (Feature specific)FAQ (Scenario based explanations)Troubleshooting ContentMaster Note for Code Fixes
Journal import does not happen after create accounting Not relevant Not relevant <Note.782975.1> - Journal Import Does Not Happen After Create Accounting Process When Periodic Average Costing is Used <Note.1177053.1> - Issues with GL Transfer And Posting Of Accounting Entries In Procure To Pay Flow - List Of Code Fixes
R12- Posting of subledger journals in GL fails with the message &quot;Funds Reservation failure&quot;/Subledger journal requires funds check while posting in GL Not relevant Not relevant <Note.975139.1> - R12 Posting Of Actuals Requires Funds Reservation For Subledger Journals Refer to the Note mentioned above
R12 - Subledger Period Close Exceptions report showing Invalid/Draft events in SLA for the source Cost Management Not relevant  Not relevant yet to create content Not relevant
11i: Journal import program errors while importing journals from subledger Not relevant Not relevant Yet to create content <Note.1177053.1> - Issues with GL Transfer And Posting Of Accounting Entries In Procure To Pay Flow - List Of Code Fixes

 

GL Drilldown issues for Receiving/Purchases/Requisitions category

Technical Problem CategoryWhitepaper (Feature specific)FAQ (Scenario based explanations)Troubleshooting ContentMaster Note for Code Fixes

GL Drilldown issues for Receiving/Purchases/Requisitions category

<Note:1280367.1> - R12:How to find Purchase Order information from General Ledger?

Not relevant Not relevant Yet to create content

Yet to create content

 

Center-Led or Global Procurement Accounting

Technical Problem CategoryWhitepaper (Feature specific)FAQ (Scenario based explanations)Troubleshooting ContentMaster Note for Code Fixes
Issues with Accounting in Global Procurement scenario <Note.556921.1> - Global (Center-Led) Procurement Flow Accounting for Receive/Deliver Transactions <Note.1158423.1> - FAQ: Center Led Procurement Accounting Flow Not relevant Yet to create content

 

Landed Cost Management Accounting

Technical Problem CategoryWhitepaper (Feature specific)FAQ (Scenario based explanations)Troubleshooting ContentMaster Note for Code Fixes
Issue with Accounting related to Landed Cost Management <Note.782920.1> - EBS LCM : Landed Cost Management
Accounting Flow in a Procure To Pay Cycle
Not relevant Not relevant Not relevant

 

Contacts

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
Details
Actions
 Encumbrance - Setup and usage
 Funds check/ Reserve issues for Purchasing documents
 Incorrect encumbered amount, active encumbrance / Encumbrance not relieved for purchasing documents
 Fund Inquiry Form - Incorrect Budget/Actual/Encumbrance/Funds available values
 Encumbrance Detailed report &Encumbrance account balance Reconciliation Discrepancies
 Invalid/Draft events on Subledger Period Close Exceptions Report in SLA for the source Purchasing
 Online Accrual issues - Accrue at receipt
 Period end Accruals - Accrue at period end and Uninvoiced Receipts Report (URR)
 11i - Accrual Reconciliation process and reports
 R12 - Accrual Reconciliation process and reports
 Account Generator issues
 SLA Account Derivation Rules for Encumbrance and Accrual Accounting
 GL Transfer and Posting issues for Receiving/Purchases/Requisitions category
 GL Drilldown issues for Receiving/Purchases/Requisitions category
 Center-Led or Global Procurement Accounting
 Landed Cost Management Accounting
Contacts
 Still Have 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.