My Oracle Support Banner

E1: 43: Encumbrance Purge / Rebuild / Repost Process (Doc ID 625633.1)

Last updated on MARCH 20, 2023

Applies to:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version XE to 9.2 [Release XE to 9.2]
Information in this document applies to any platform.

Purpose

Overview

The purpose of this process is to correct variances in the Account Balances (F0902) and P.O. Detail Ledger (F43199) Purchase Amount (PA) ledger records. This process will delete and rewrite the Purchase Amount (PA) ledger records to the P.O. Detail Ledger (F43199) file and repost the amounts to the Account Balances (F0902) table based on the Purchase Order Detail (F4311) and Purchase Order Receiver (F43121) records.

Encumbrances are a key piece of Budgetary Reporting and Government Finance. The commitment audit trail is a history of commitment balances. Encumbrance accounting is subject to data integrity issues if certain processes are not followed correctly. The Purge/Rebuild/Repost process can assist in correcting data integrity issues in the Account Balances (F0902) and the P.O. Detail Ledger (F43199) files. The process consists of running three batch applications: F43199 Ledger Purge (R43199P), Create F43199 Commitment Audit Trail (R00993), and Repost Committed Costs (R00932).

Scope

 This document is intended for users who are working with the Encumbrance accounting in the Procurement Module.

Details

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
Scope
Details
 Tables Used
 Step 1: F43199 Ledger Purge (R43199P)
 Step 2: Create F43199 Commitment Audit Trail (R00993)
 Step 3: Repost Committed Costs to Jobs (R00932)
 Purge/Rebuild/Post After Multiple Rollovers
 Troubleshooting/FAQs
 Question 1 - Can the Data File Purge P. O. Detail (F43199) (R43199P) be run from the web?
 Question 2 - What are the known issues that can stop the F0902 from being updated when running the Repost Committed Costs to Jobs (R00932)?
 Question 3 - A Invalid Value error is received in the P0025 Ledger Type Master program when trying to uncheck the Prevent Direct Balance Update field per Question number 2 above.  How can this value be updated?
 
References

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