Grants Accounting: R12 Upgrade - Data Correction for Upgraded Invoice Distributions (Doc ID 1300874.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Symptoms

During upgrade from 11i to R12, AP creates new Invoice distributions in ap_invoice_distributions_all.
These may be for :

• Variance distributions like IPV, ERV, TIPV etc. created out of ITEM or TAX lines. (The amounts were stored on the ITEM/TAX lines in 11i, but in R12 there are separate distributions for Variance lines)
• New distributions resulting from the split of old distributions. For e.g., one FREIGHT line might get split into multiple FREIGHT lines based on the Charge A

2. All the Project/Award related attributes, including pa_addition_flag are copied over from the original distribution on to the new distributions.

Related errors are:
-missing gms_award_distribution lines
-Running PRC: Interface Supplier Costs and getting Getting 'Can not find burden schedule revision'  because the correct gms_award_distribution lines are not created.

Changes

Upgrade from 11.5 to Release 12.

Cause

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