My Oracle Support Banner

R12: Output Of Generic Data Fix (GDF) Patch 18818008 Selection Script ap_x_prorate_due_to_awt_sel.sql Refers To Incorrect Existing Driver Table And Fix Script. (Doc ID 2551025.1)

Last updated on NOVEMBER 27, 2021

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.


GDF Patch 18818008 Selection Script ap_x_prorate_due_to_awt_sel.sql output shows the following text at the end

Following are the next steps to fix the issue, if any

1. Following Driver table(s) created: ap_x_prrt_due_awt_18818008_DRV,ap_undo_checks_18818008_DRV

2. If you want any transaction/transactions to be fixed then update the
process_flag column in the driver table ap_undo_checks_18818008_DRV to Y for that/those transaction(s).
IMPORTANT: Do not change any other column value(s) in the(se) table(s).

3. To fix the identified transactions run ap_x_prorate_due_to_awt_fix.sql
which is present in $AP_TOP/patch/115/sql in a New SQL*PLUS session

4. If data is not corrected, contact Oracle Support and supply the log files generated:
18818008-diag-HH24:MI:SS.html and 18818008-fix-HH24:MI:SS.html

5. Additional actions:

After running this script, table ap_x_prorate_due_to_awt will have
data records. In case the number of records selected is too huge, that
is, more than 100 distinct checks, do not run fix file and report to
development to review.

The GDF Selection Script Output refer to Non-Existing fix script ap_x_prorate_due_to_awt_fix.sql

The GDF Selection Script Output refer to Non-Existing table ap_x_prorate_due_to_awt



 GDF Patch 18818008 applied.


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

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