R12: PA: PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_ID Not Getting Populated In R12 Upgrade (Doc ID 2023724.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 12.2.3 and later
Information in this document applies to any platform.


After upgrading from 11i to 12.2.3 there are some records with data corruption as reported in the r13833481.sql file in patch 13833481.
This causes some records to exist with NULL values in the DOCUMENT_DISTRIBUTION_ID in the PA_EXPENDITURE_ITEMS_ALL table.

The Invoice_distribution_id should be populated in the pa_expenditure_items_all table


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