2 Replies Latest reply: Apr 2, 2009 1:36 PM by martinley RSS

    Context ORIGINAL_ENTRY_ID needs to be set

    martinley
      Hi,

      I have created a query, that uses the pay_balance_pkg.get_value. When I am running this I am getting the below error:

      ORA-20001: Dynamic SQL for DB item failed : ORA-20001: Database item requires context ORIGINAL_ENTRY_ID to be set
      ORA-06512: at "APPS.HR_UTILITY", line 939
      ORA-06512: at "APPS.PAY_BALANCE_PKG", line 1612
      ORA-06512: at "APPS.PAY_BALANCE_PKG", line 2735
      ORA-06512: at "APPS.PAY_BALANCE_PKG", line 2908
      ORA-06512: at "APPS.PAY_BALANCE_PKG", line 4451
      ORA-06512: at "APPS.PAY_BALANCE_PKG", line 5404
      ORA-06512: at "APPS.PAY_BALANCE_PKG", line 5266
      ORA-06512: at "APPS.PAY_BALANCE_PKG", line 5251

      I have looked at Metalink Document 74315.1, section 2.5.2. (step 2 should say latest_balance_id not defined_balance_id in the where clause I think).

      Can anyone help me to determine what I need to do get this working?

      Many thanks

      Martin