My Oracle Support Banner

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

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

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
 Standard Patching Process
 Patch Wizard
 Have more questions?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.