My Oracle Support Banner

EPY: Balance Adjustment for the New Additional CPP Tax Class in the New Year Fails With ‘SQL Error in Exec. (2, 280)’ (Doc ID 2992747.1)

Last updated on APRIL 15, 2024

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

 When doing a Balance Adjustment for the New Additional CPP Tax Class fails upon saving.

A Pop-up Window appears on the page with the following messages
'A fatal PeopleCode SQL error occurred.  Please consult your system log for details. 
 OK'


'SQL error in Exec. (2, 280) ADJ_CN_TAX_BAL.EMPLID.FieldDefault  Name: adjust_balance  PCPC:14831 Statement: 207
Called from:ADJ_CN_TX_BAL.EMPLID.SavePostChange  Statement: 11

During the execution of SQL, an error occurred in the Exec.subroutine.  The preceding message should have described the SQL being executed.
              OK'


Steps to Reproduce

NOTE: In the examples below, user details/company name/address/email/ telephone number all represent a fictitious sample from the Oracle Demo Vision Database.  Any similarity to actual companies or actual persons, living or dead, is purely coincidental and is in no way intentional on the part of Oracle.

 

1.  Navigate to Payroll for North America > Periodic Payroll Events CAN > Balance Adjustments > Taxes
      - Search for EMPLID: KC0002 
2.  In DEMO Enter the following on Tab Adjust Tax Balance 1:
          a) Company ID: GBI
          b) Balance ID: CY
          c) Year: 2024 (or the next year from current processing)
          d) Period: 10 (or any period in the new year)
          e) Wage Loss Plan: KRG
          f)  Province: AB
          g) Tax Class: 'CPP Second Additional Employee'
          h) Reason for Adjustment: <Anything can go here>
          i)  Click Save
3.  Enter the following on Tab Adjust Tax Balance 2 - where no current balance exists:
          a) Under heading Tax/PA  - Adjustment to Month-To-Date: $5.00
          b) Under heading Taxable Gross - Adjustment to Month-To-Date: $50.00
          c) Under heading No Limit Gross - Adjustment to Month-To-Date: $50.00
          d) Click Save
          e) See a Pop Up Window with the message 'A fatal PeopleCode SQL error occurred.  Please consult your system log for details.  OK'
          f) Click OK
          g) See  a Pop Up Window with the message:
               'SQL error in Exec. (2, 280) ADJ_CN_TAX_BAL.EMPLID.FieldDefault  Name: adjust_balance  PCPC:14831 Statement: 207
               Called from:ADJ_CN_TX_BAL.EMPLID.SavePostChange  Statement: 11

              During the execution of SQL, an error occurred in the Exec.subroutine.  The preceding message should have described the SQL being executed.
              OK'

  Note: Similar error message(s) may occur for a U.S. Payroll scenario with a U.S. Tax Class.

 

Changes

 New CPP Enhancement had been delivered with the 2023 Legislative Tax PRP.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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