R12: AP: Invalid Invoice Distribution ID in Fa_asset_invoices After Running Datafix : Ap_upg_fix.sql
(Doc ID 2185206.1)
Last updated on MARCH 18, 2019
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!