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

(Doc ID 2354290.1)

Last updated on JANUARY 29, 2018

Applies to:

Oracle Financials for the Americas - Version 12.2.6 and laterInformation 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 PayablesProduction and Test instances.

2. Path: Invoices -> Entry -> Invoices3. 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