R12 Generic Data Fix (GDF) Patch for ORPHAN RECORDS IN AP_PREPAY_APP_DISTS
(Doc ID 1395357.1)
Last updated on SEPTEMBER 07, 2023
Applies to:
Oracle Payables - Version 12.0.0 to 12.2.12 [Release 12.0 to 12.2]Information in this document applies to any platform.
Symptoms
Accounting events have been incorrectly accounted because of orphan records in AP_PREPAY_APP_DISTS
Steps to reproduce:
- Log into Oracle applications using a Payables responsibility.
- Open the Invoice Workbench
(N) Invoices > Entry > Invoice - Create or query an Invoice with a Prepay Apply/Unapply event
- Click on the [Actions] button
- Try to Validate the Invoice
- A Hold or other exception appears
- Address the Hold/Exception and then try to re-validate the Invoice
- When attempting to re-validate and account the invoice rows related to unprocessed, distributions get purge from the history table but not from the AP_PREPAY_APP_DISTS table
- Hence, an Orphan event exists
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
DATA-FIX |
CODE-FIX |
References |