R12.2:JL:AP: Why GLOBAL_ATTRIBUTE_CATEGORY Field Get Null In AP_INVOICES_ALL Talble?
Last updated on JANUARY 29, 2018
Applies to:Oracle Financials for the Americas - Version 12.2.6 and later
Information in this document applies to any platform.
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.
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')
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