Upgraded From R12.1.3 To R12.2.10, Column DOCUMENT_LINE_NUMBER Became Null in PA_EXPENDITURE_ITEMS_ALL Table on Supplier Invoice Transactions (Doc ID 3004352.1)

Last updated on FEBRUARY 21, 2024

Applies to:

Symptoms

After upgraded from R12.1.3 to R12.2.10, column DOCUMENT_LINE_NUMBER became Null in PA_EXPENDITURE_ITEMS_ALL table on supplier invoice transactions.

If viewing the data in the Expenditure Inquiry form, the 'Invoice Line Number' column (corresponding to DOCUMENT_LINE_NUMBER column) is null/blank.

This only occurs on supplier invoice transactions that were created before the upgrade.

Steps
=====

1. Using a Projects responsibility

2. Navigate to: Expenditures >> Expenditure Inquiry
   Enter a project number and click FIND

-In R12.1.3 instance: the 'Invoice Line Number' column is populated:

Trans Id      Invoice Number      Invoice Line Num
------------------------------------------------------------------
11111111    APINV_1              1
22222222    APINV_1              2
33333333    APINV_1              3

-In R12.2.10 instance: the 'Invoice Line Number' is blank/null:

Trans Id      Invoice Number      Invoice Line Num
------------------------------------------------------------------
11111111    APINV_1
22222222    APINV_1
33333333    APINV_1

44444444    APINV_1              1
55555555    APINV_1              2
66666666    APINV_1              3

Note: Trans IDs 44444444 to 66666666 are the new expenditures that are created After the upgrade and they do have the 'Invoice Line Num' column populated.

Changes

 Upgraded from R12.1.3 to R12.2.10

Cause

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