PAY_PAYROLL_ACTIONS.ACTION_STATUS Not Set To 'C' For Tax Balance Adjustments

(Doc ID 2121873.1)

Last updated on AUGUST 18, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, US Payroll Tax Issues

ACTUAL BEHAVIOR
---------------
pay_payroll_actions.action_status is no longer being updated to "C" (complete) after the pay run results completes.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Running API as following:
pay_us_tax_bals_adj_api.create_tax_balance_adjustment
  ( p_validate => FALSE
  , p_adjustment_date => p_effective_date
  , p_business_group_name => l_business_name
  , p_assignment_number => p_assignment_number
  , p_tax_unit_id => l_tax_unit_id
  , p_consolidation_set => l_conset
  , p_earning_element_type => p_earning_element_type
  , p_gross_amount => NVL(p_gross_amount,0)
  , p_net_amount => NVL(p_net_amount,0)
  , p_fit => NVL(p_fit,0)
  , p_ss => NVL(p_ss,0)
  , p_medicare => NVL(p_medicare,0)
  , p_balance_adj_costing_flag => p_balance_adj_costing_flag
  , p_balance_adj_prepay_flag => p_balance_adj_prepay_flag
  , p_city_name => l_location.work_city
  , p_state_abbrev => l_location.wrk_state
  , p_county_name => l_location.work_county
  , p_zip_code => l_location.work_zip
  , p_fit_third => p_fit_third
  , p_sit => NVL(p_sit,0)
  , p_sui => NVL(p_sui,0)
  , p_sdi => NVL(p_sdi,0)
  , p_county => NVL(p_county,0)
  , p_city => NVL(p_city,0)
  , p_futa_er => NVL(p_futa_er,0)
  , p_sui_er => NVL(p_sui_er,0)
  , p_sdi_er => NVL(p_sdi_er,0)
  , p_sch_dist_wh_ee => NVL(p_sch_dist_wh_ee,0)
  , p_sch_dist_jur => NVL(l_school_code,0)
  , p_payroll_action_id => l_payroll_action_id
  , p_create_warning => l_create_warning
  );



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