BAC030 APP ENGINE FAILED WITH SQL SERVER ERROR AND OTHER AUDITS (Doc ID 2124090.1)

Last updated on MAY 11, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ACA Final Processing BAC030 errors:


ERROR
-----------------------
SQL error. Function: SQLExec

 Error Position: 0

 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Error converting data type varchar to numeric. (SQLSTATE 37000) 8114

 Statement: SELECT TOP 1 'Y' FROM PS_ACA_ALE_MEM_SUB WHERE ACA_ALE_MEMBER = :1 AND ACA_CALENDAR_YEAR = :2 AND ACA_1094_SUBID <> ' '

 Original Statement: Select 'Y' from PS_ACA_ALE_MEM_SUB where ACA_ALE_MEMBER = :1 and ACA_CALENDAR_YEAR = :2 and ACA_1094_SUBID <> ' '

SQL error in Exec. (2,280) BAC030.MAIN.GBL.default.1900-01-01.Step01.OnExecute PCPC:4887 Statement:19

Process 1336184 ABENDED at Step BAC030.MAIN.Step01 (PeopleCode) -- RC = 24 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 10.05.25 2016-03-02



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ACA Final Processing
2. BAC030 errors out


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