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:
Oracle Project Costing - Version 12.2.10 and laterInformation in this document applies to any platform.
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
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 |
References |