My Oracle Support Banner

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:

  1. Perform upgrade from 12.1.x to 12.2.x
  2. From Payables Responsibility of the upgraded instance, Nav: Invoices > Inquiry > Invoices
  3. Query up the upgraded invoice of interest
  4. 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

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