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

    grant select on HRMS fast formulas

    dvvnreddy

      Hi,

       

      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