My Oracle Support Banner

After Applying Bundle 31, the Application Status Update for Programs Process (ADMPGPGS.SQR) Fails in SQL Server and DB2 Environments (Doc ID 1610324.1)

Last updated on JANUARY 29, 2020

Applies to:

PeopleSoft Enterprise CS Recruiting and Admissions - Version 9 and later
Information in this document applies to any platform.


After applying CS 9 bundle 31, the Application Status Update for Programs process, AADMPGPGS.sqr, fails with the following error:
Error on inserting record SAD_PROG_CAF..
SQL Status = 245, SQL Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the varchar value '1.0000000000000000000000000000000000000000000000000000' to data type smallint.

The issue can be reproduced at will with the following steps:

1. Apply Bundle #31.
2. Log in and navigate to Student Admissions > Processing Applications > Update Applications > Application Program Update.
3. Run to process ADMPGPGS.


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

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