Fixed Assets Central Statistics Office (KSH) Report For Hungary Fails With ORA-20100 process_kff_combination_1 Exceptions (Doc ID 1642582.1)

Last updated on MARCH 22, 2016

Applies to:

Oracle Assets - Version 12.1.3 and later
EMEA Add-on Localizations - Version 12.2.3 and later
Information in this document applies to any platform.
FAWIPSTAT

Symptoms

When attempting to submit FAWIPSTAT module: FA CIP Statistics for the Central Statistical Office (KSH) (Hungary), the following errors are displayed  in xml output file :

-- Errors
ORA-20100: process_kff_combination_1(addition_type, OFA, KEY#, 101, ADDITION_TYPE, N, VALUE) raised exception.
ORA-20100: get_kff_seg_column_names(140, KEY#, 101, DISPLAYED_ONLY, ADDITION_TYPE, N) raised exception.
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 180
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 242
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 1434
ORA-20402: Invalid Qualifier: ADDITION_TYPE
ORA-20100: process_kff_combination_1(industry_code, OFA, KEY#, 101, INDUSTRY_CODE, N, VALUE) raised exception.
ORA-20100: get_kff_seg_column_names(140, KEY#, 101, DISPLAYED_ONLY, INDUSTRY_CODE, N) raised exception.
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 180
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 242
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 1434
ORA-20402: Invalid Qualifier: INDUSTRY_CODE
ORA-20100: process_kff_combination_1(statistical_code, OFA, KEY#, 101, STATISTICAL_CODE, N, VALUE) raised exception.
ORA-20100: get_kff_seg_column_names(140, KEY#, 101, DISPLAYED_ONLY, STATISTICAL_CODE, N) raised exception.
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 180
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 242
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 1434
ORA-20402: Invalid Qualifier: STATISTICAL_CODE
ORA-20100: process_kff_combination_1(tariff_num, OFA, KEY#, 101, TARIFF_NUM, N, VALUE) raised exception.
ORA-20100: get_kff_seg_column_names(140, KEY#, 101, DISPLAYED_ONLY, TARIFF_NUM, N) raised exception.
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 180
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 242
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 1434
ORA-20402: Invalid Qualifier: TARIFF_NUM
ORA-20100: process_kff_combination_1(item_number, OFA, KEY#, 101, ITEM_NUMBER, N, VALUE) raised exception.
ORA-20100: get_kff_seg_column_names(140, KEY#, 101, DISPLAYED_ONLY, ITEM_NUMBER, N) raised exception.
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 180
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 242
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 1434
ORA-20402: Invalid Qualifier: ITEM_NUMBER
ORA-20100: process_kff_combination_1(reserve, OFA, KEY#, 101, RESERVE, N, VALUE) raised exception.
ORA-20100: get_kff_seg_column_names(140, KEY#, 101, DISPLAYED_ONLY, RESERVE, N) raised exception.
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 180
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 242
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 1434
ORA-20402: Invalid Qualifier: RESERVE



 -- Steps
The issue can be reproduced at will with the following steps.

1- Implement EMEA Add-on Localizations for Hungary and Fixed Assets product
1. Submit FA CIP Statistics for the Central Statistical Office (KSH) (Hungary) report

-- Business Impact
The issue has the following business impact:
Due to this issue, users cannot review this report output which is a Hungarian requirement

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