0 Replies Latest reply on Apr 7, 2014 1:01 PM by dvvnreddy

    grant select on HRMS fast formulas




      For one query we are using hrms fast formula , this query works when executed as apps user.


      we have a database schema which has select and execute privileges on some HR tables and packages.. when we try with this user  it is giving error


      ORA-20001: Formula XX_PG_PTO_ACCRUAL_IND: ORA-20001: A compiled version of the formula <Fast Formula> cannot be found. Check that it exists and has been compiled before attempting to run it.

      Cause: During the PL/SQL execution part, an Oracle error was detected.

      Action: Please refer to your system administrator.
      ORA-06512: at "APPS.PER_FORMULA_FUNCTIONS", line 608
      ORA-06512: at "APPS.PER_ACCRUAL_CALC_FUNCTIONS", line 70
      ORA-06512: at "APPS.PER_ACCRUAL_CALC_FUNCTIONS", line 129
      ORA-06512: at "APPS.PER_ACCRUAL_CALC_FUNCTIONS", line 860
      ORA-06512: at "APPS.PER_UTILITY_FUNCTIONS", line 787
      ORA-06512: at line 1

      can some one help