Generic Datafix - Reporting Script And DataFix Script To Correct Incorrect Commitments For Closed POs/REQs
Last updated on JUNE 15, 2017
Applies to:Oracle Grants Accounting - Version 12.0.3 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
A generic datafix and reporting script are available to correct incorrect commitments for closed purchase orders and requisitions.
<PATCH 16920340> GDF:Reporting Script and DataFix script to correct incorrect commitment for the closed PO/REQ
The datafix patch addresses the following issues:
i. List out the encumbrance items which are in closed or finally closed status.
ii. It provided the list of the closed encumbrance items for which active encumbrance is present in the GMS tables.
iii. It fixes the such Purchase Order/Requisition records for which there are no active encumbrance but GMS table shows the active encumbrance.
iv. Synchronize GMS and PO tables for award where there is a mismatch between the GMS and PO encumbrance and list out the transactions which has fixed through this patch.
Patch include following scripts.
1. gms16920340r.sql : This script provides the encumbrance amount details which have been incurred by the award/project.This gives the details about the encumbrance items of the Purchase Order/Requisition, which has closed even-though the encumbrance amount is exists in the GMS tables.
2. gms16920340d.sql : This script fix the encumbrance amount details which have been incurred by the award/project.This fixes the encumbrance amount items of the Purchase Order/Requisition, which has closed even-though the encumbrance amount is exists in the GMS table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms