JGZZEASC Error FRM-41830 in ID Type Field In Business Entity Relationships Window (Doc ID 2102186.1)

Last updated on FEBRUARY 01, 2016

Applies to:

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

Symptoms

On : 12.2.4 version, Argentina Payables

When attempting to setup Business Relationships ,
the following error occurs.

FRM-41830: List of Values contains no entries.

The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables
2. Path: Argentine Localization > Company Information > Business Relationships (JGZZEASC)

ID Type:

FRM-41830: List of Values contains no entries.

3. It looks like the issue occurs because the following script does not return data:

select lookup_code, meaning
from fnd_lookups
where lookup_type = 'JGZZ_ENTITY_ASSOC_ID_TYPE'
group by lookup_code, meaning;

no rows

Customer defined the tax authority category lookup codes for lookup type 'JGZZ_ENTITY_ASSOC_ID_TYPE' as per user guide
(Oracle Financials for the Americas User Guide R12.2 Part No. E48764-04 - Page 3-26) and application as 'Latin America Localizations'.

The following query return the values..

select lookup_type,lookup_code, meaning
 from fnd_lookup_values_vl
 where lookup_type = 'JGZZ_ENTITY_ASSOC_ID_TYPE'
 and view_application_id = 200
 group by lookup_type,lookup_code, meaning;


The issue has the following business impact:
Due to this issue, users cannot finish the setup.

Cause

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