R12: AP: Invoices Upgraded From 12.1.x to 12.2.x Do Not Have Correct PAY_GROUP_LOOKUP_CODE Values
(Doc ID 2948897.1)
Last updated on MAY 22, 2023
Applies to:Oracle Payables - Version 12.0.0 to 12.2.12 [Release 12.0 to 12.2]
Information in this document applies to any platform.
After upgrading from release 12.1.x to 12.2.x, the values for PAY_GROUP_LOOKUP_CODE for table AP_INVOICES_ALL are all NULL.
This is determined from the Invoice Workbench where these values appear as NULL (blank), and from this SQL query:
Whereas, from the 12.1.x instance, this SQL query returns various counts for various PAY_GROUP_LOOKUP_CODE values.
Steps to Reproduce:
- Perform upgrade from 12.1.x to 12.2.x
- From Payables Responsibility of the upgraded instance, Nav: Invoices > Inquiry > Invoices
- Query up the upgraded invoice of interest
- Notice that 'Pay Group' value is NULL (had a not null value in 12.1.x)
Upgrade from 12.1.x to 12.2.x
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