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

Last updated on JUNE 07, 2021

Applies to:

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

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