R12: AP: Generic Data Fix (GDF) Patch for Incorrect PREPAYMENT UNAPPLIED Events Due To PREPAY APPLIED Distributions Deleted And Recreated (Doc ID 2149693.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

Accounting issues arising for prepay application/unapplication events when the data from the tables AP_PREPAY_HISTORY_ALL and AP_PREPAY_APP_DISTS are deleted and regenerated for already accounted BC and actual events due to corruption in posted_flag.

Steps to reproduce:

1. Payables responsibility>Invoices>Entry
2. Create a prepayment invoice, validate and fully pay it.
3. Create the standard invoice and validate it.
4. Apply the prepayment and validate it.
5. Run Create Accounting.
6. Adjust the invoice by adding more distributions and validate it.
7. Run Create Accounting.

Changes

Cause

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