R12: AP: Invalid Invoice Distribution ID in Fa_asset_invoices After Running Datafix : Ap_upg_fix.sql (Doc ID 2185206.1)

Last updated on SEPTEMBER 23, 2016

Applies to:

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

Symptoms

After running the script ap_upg_fix.sql, according to note:
R12: Generic Data Fix (GDF) Patch to fix common upgrade corruptions of 11i invoices which are not yet non-modified in R12 (Doc ID 1966076.1),
there are  invoice distributions ids in FA_ASSET_INVOICES table, which not exist in AP_INVOICE_DISTRIBUTIONS_ALL table.


STEPS

The issue can be reproduced at will with the following steps:
1. Upgrade invoice from 11i.
2. Reupgrade invoice running the script ap_upg_fix.sql


Changes

 

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