Active Employee Adjust Tax Balance Getting Error APP-PAY- 07276 Dynamic SQL for DB item failed, ORA-20001 TAX_UNIT_ID When GRE is Part of Tax Group

(Doc ID 1941848.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle HRMS (US) - Version 12.1.3 and later
Information in this document applies to any platform.


When attempting to adjust tax balances on active employees the following error occurs.

APP-PAY-07276 dynamic sql for db item failed: ora-20001
database item requires context TAX_UNIT_ID to be set

The issue can be reproduced at will with the following steps:
1. Ran adjustments without problem earlier
2. Applied the following patches:

3. Entering a adjust tax balance adjustment, gives the error


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms