R12: AP: Prepayment Event Status Code Stay in U/U Cannot Be Accounted (Doc ID 2179486.1)

Last updated on SEPTEMBER 05, 2016

Applies to:

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

Symptoms

Cannot account prepayment application line. The event status codes stay in U/U.
There is decimal number exist in AP_INVOICE_LINES table LINE_NUMBER column of the prepayment invoice.

Below data corruption is detected, but the fix script cannot fix the issue.

R12 Generic Data Fix (GDF) Patch for Bug 8966332 - Prepayment Application / Uapplication Events Fails to Account Due to Missing Records in AP_PREPAY_APP_DISTS (Doc ID 975184.1)

Data Detail:

In prepay invoice, AP_INVOICE_LINES table
LINE_NUMBER
218114.06

In standard invoice, AP_PREPAY_HISTORY_ALL table
PREPAY_LINE_NUM
218114

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms