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 laterInformation in this document applies to any platform.
Symptoms
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
Changes
GDF Patch 18818008 applied.
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 |
| References |