using line_object_id in fast formula but got the error on the performance review page
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