Fusion: Error: An application error has occurred while using 'Best Fit Person' from Person Profile (Doc ID 1606806.1)

Last updated on SEPTEMBER 26, 2014

Applies to:

Oracle Fusion Performance Management Cloud Service - Version and later
Oracle Fusion Performance Management - Version and later
Information in this document applies to any platform.


On : version, Manage Worker Profiles - Best Fit Person

Error while using Best Fit person from Person Portrait pages

Incident Error appears while using Best Fit Person from person portrait. This error occurs only while using the following criteria while filtering the results:
Number of Profiles - Numeric value - Lowest matches

An application error occurred. See the incident log for more information.
An application error has occurred. Your help desk can use the following information to obtain a more detailed description of this incident: 214, Server Domain: HCMDomain, Server Instance: CoreProcessesServer_1, Application Name: HcmCoreApp.
An application error occurred. See the incident log for more information.

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

1. Login as Employee/ HR Specialist
2. Click on the My Portrait Tab
3. Click on "Find Best Fit Persons"
4. In the "Find Best Fit Person" UI, click on the Find Best Fit button
5. In the search results region, use the following criteria and click on the -> button Number of Profiles - Numeric value - Lowest matches
6. Get an incident error


The logs retrieved from the customer's environment show the following error:

Caused by: oracle.jbo.DMLException: JBO-26044: Error while getting estimated
row count for view object ProfileBestFitAscOrderVO, statement SELECT count(1)

The issue has the following business impact:
Due to this issue, users are unable to use the lowest matches filtering criteria.


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