Forms Hanging And Payroll Not Completing After AU.18 (Doc ID 1469628.1)

Last updated on FEBRUARY 08, 2023

Applies to:

Symptoms

Accrual, absence and SOE forms hanging and payroll is not completing after applying AU.18.

Problem sql identified is:
 
  SELECT /*+ RULE*/
  fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.
  result_value) * FEED.scale),0)) FROM /* $Header: payauupdroute.sql-115.1
  2012/05/28 17:55:56 xxxxxxx noship $ */
       pay_assignment_actions         bal_assact
  ,      pay_payroll_actions            bact
  ,      pay_assignment_actions         assact
  ,      pay_payroll_actions            pact
  ,      per_time_periods               ptp
  ,      pay_run_results                rr
  ,      pay_run_result_values          target
  ,      pay_balance_feeds_f            feed
  where  bal_assact.assignment_action_id  = :ASSIGNMENT_ACTION_ID
  and    bal_assact.payroll_action_id     = bact.payroll_action_id
  and    feed.balance_type_id             = :U1
  and    feed.input_value_id              = target.input_value_id
  and    target.run_result_id             = rr.run_result_id
  and    nvl(target.result_value,'0')   <> '0'
  and    rr.assignment_action_id          = assact.assignment_action_id
  and    assact.payroll_action_id         = pact.payroll_action_id
  and    assact.action_sequence           <= bal_assact.action_sequence
  and    assact.assignment_id             = bal_assact.assignment_id
  and    pact.effective_date              between feed.effective_start_date
  and feed.effective_end_date
  and    rr.status                        in ('P','PA')
  and    bact.date_earned between ptp.start_date and ptp.end_date
  and    ptp.payroll_id  = bact.payroll_id
  and    pact.payroll_id = ptp.payroll_id
  and    pact.date_earned >=  ptp.start_date
  and    pact.date_earned <=  ptp.end_date
  and    assact.tax_unit_id = :TAX_UNIT_ID
 
 

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.