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? Is it just for Court Orders I would need to set the context, if not how do I find out which elements I need to set this for?

Many thanks

Martin

Martin, an original_entry_id will apply to any balance with an _ELEMENT_ITD dimension, and I think there are some others of that nature too. Court Order balances are just one example. Essentially, the balance is being tied to a specific element entry, so that it can record the amount paid off against each one. The original_entry_id is the element entry that the balance pertains to.

Hope this helps