R12: AP: Invalid Invoice Distribution ID in Fa_asset_invoices After Running Datafix : Ap_upg_fix.sql
Last updated on JANUARY 04, 2018
Applies to:Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms