My Oracle Support Banner

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

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
Goal
Solution


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