Human Capital Management - EBS (MOSC)

MOSC Banner

using line_object_id in fast formula but got the error on the performance review page

edited Dec 7, 2019 4:03AM in Human Capital Management - EBS (MOSC) 1 commentAnswered

Dear,

first let explain my business requirement, I want to calculate the objective score base on completion percentage of each objective.

To do this, I create a function to get the objective completion percentage base on objective id, and then I used this function on fast formula by passing the objective id from "line_object_id.

it is working find when I create objective, but it got the error on performance review page after I complete all objective setup.

Below is the error detail:

java.sql.SQLException: ORA-20001: Formula AC_OBJECTIVES_WEIGHT_FORMULA: ORA-01403: no data found ORA-01403: no data found Cause: During the PL/SQL execution part, an Oracle error was detected. Action: Please refer to your system administrator. ORA-06512: at "APPS.HR_APPRAISALS_UTIL_SS", line 261 ORA-06512: at "APPS.HR_APPRAISALS_UTIL_SS", line 507 ORA-06512: at "APPS.HR_APPRAISALS_UTIL_SS", line 573 ORA-06512: at "APPS.HR_APPRAISALS_UTIL_SS", line 631

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center