My Oracle Support Banner

Asset Reconciliations Dashboard Shows Error ORA-20100 Under Available Refinements For Asset Major Category (Doc ID 2761708.1)

Last updated on MARCH 22, 2021

Applies to:

Oracle Assets - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

When using the Asset Reconciliations Dashboard within Enterprise Command Center, it shows error under Available Refinements for Asset Major Category:

 Error: ORA-20100: process_kff_comination_1 (AssetCategory, OFA, CAT#, 101, 101, BASED_CATEGORY, N, FULL_DESCRIPTION) raised exception.



Steps to replicate:

1)  Enter the Asset Command Center

2)  Choose the Account Reconciliations Dashboard

3)  Choose the Asset Major Category refinement

This selection will error with:  Error: ORA-20100: process_kff_comination_1 (AssetCategory, OFA, CAT#, 101, 101, BASED_CATEGORY, N, FULL_DESCRIPTION) raised exception.

Expected behavior:  User should be able to use the Asset Category Flexfield (a key flexfield) as a refinement of dashboard data without error.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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