PAY_STATE_TAX_RULE_API.update_state_tax_rule Error on Filing Status 10 for Georgia

(Doc ID 2155994.1)

Last updated on JULY 03, 2016

Applies to:

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


When attempting to execute API, PAY_STATE_TAX_RULE_API.update_state_tax_rule, the following error occurs.

ORA-20001: Provide a valid State Tax Rule filing status code.

The issue can be reproduced at will with the following steps:
1. API call: pay_state_tax_rule_api.update_state_tax_rule
  (p_validate => TRUE,
  p_effective_date => TO_DATE(TO_CHAR(TO_DATE (rec_pre.projected_hire,'MM/DD/YYYY'),'MM/DD/YYYY'),'MM/DD/YYYY'),
  p_datetrack_update_mode => g_update_mode,
  p_emp_state_tax_rule_id => state.emp_state_tax_rule_id,
  p_object_version_number => l_state_obj_ver_num,
  p_filing_status_code => '10' --l_state_filing_status,
  p_sit_exempt => rec_pre.attribute4,
  p_secondary_wa => rec_pre.st_secondry_allowances,
  p_withholding_allowances => rec_pre.st_allowances,
  p_sit_additional_tax => rec_pre.st_additional_tax,
  p_additional_wa_amount => NVL(rec_pre.st_exemption,0 ) , p_effective_start_date => lx_st_effective_start_date,
  p_effective_end_date => lx_st_effective_end_date


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