R12 Generic Data Fix (GDF) patch to delete Payment Adjusted events with out corresponding distributions. (Doc ID 970956.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

Payment adjustment records in ap_payment_history_all table are stamped with an invoice_adjustment_event_id that does not exist in accounting_event_id column in ap_invoice_distributions_all table. These are orphan payment adjustment event records.
This causes the Create Accounting program to error out with:

Steps to reproduce:

1. Log into Oracle applications using a Payables responsibility.
2. Open the Invoice Workbench
   (N) Invoices > Entry > Invoice
3. Create invoice
   
4. Validate and Pay it
   
5. Create accounting for the Invoice and for the Payment
6. Go back to the respective Invoice and create self assessed tax distributions and then re-validate the invoice
   
7. This action will create corresponding payment adjustment.
   
8. Create accounting for the invoice and payment
9. Run concurrent program 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.