R12.2:JL:AP: Why GLOBAL_ATTRIBUTE_CATEGORY Field Get Null In AP_INVOICES_ALL Talble?

(Doc ID 2354290.1)

Last updated on APRIL 06, 2018

Applies to:

Oracle Financials for the Americas - Version 12.2.6 and later
Information in this document applies to any platform.

Goal

Why sometimes the GLOBAL_ATTRIBUTE_CATEGORY field get null for not cancelled documents and also having not null value in GLOBAL_ATTRIBUTE19 field?

1. Responsibility: Oracle Payables
Production and Test instances.

2. Path: Invoices -> Entry -> Invoices
3. Query an invoice

GLOBAL_ATTRIBUTE_CATEGORY field is set to null for no cancelled documents having not null value in GLOBAL_ATTRIBUTE19 field.

The issue occurs for upgraded invoices as well as manual entered invoices.
The GLOBAL_ATTRIBUTE_CATEGORY value is populated at the moment of saving a new invoice or
importing an automatic invoice, but before validating.

The issue seems to happen exactly at the moment of cancelling more than one transaction selected.

Workaround:
Update the field GLOBAL_ATTRIBUTE_CATEGORY with the value JL.CL.APXINWKB.AP_INVOICES
that is the value defined on global attribute flexfield JG_AP_INVOICES.

GLOBAL_ATTRIBUTE_CATEGORY should have JL.CL.APXINWKB.AP_INVOICES value if GLOBAL_ATTRIBUTE19 is not null.
GLOBAL_ATTRIBUTE19 may have values according to Document Type.
The user has setup this value to a value set named SCFRE_JLCL_AP_DOCUMENT_TYPE, and this value set is list of values defined as a lookup.
(lookup_type = 'SCFRE_JLCL_AP_DOCUMENT_TYPE')

Solution

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