Payroll Reconciliation Summary, Errors: ORA-20001: Dynamic SQL for DB item failed : ORA-20001: Database item requires context TAX_UNIT_ID to be set (Doc ID 2208930.1)

Last updated on FEBRUARY 21, 2017

Applies to:

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

Symptoms

On Production: 12.1.3   version, Australian Payroll

When attempting to Run Payroll Reconciliation Summary , the following error occurs.

ORA-20001: Dynamic SQL for DB item failed : ORA-20001: Database item requires context TAX_UNIT_ID to be set




Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Login to GJ Payroll Manager and navigate to View > Submit Request
2. Submit the Payroll Rec Summary Report
3. Navigate to view > assignment process results and an error occurs

Changes

 

Cause

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