Print Invoice Fails When Multiple Residency Records Are Found

(Doc ID 1491781.1)

Last updated on JULY 11, 2016

Applies to:

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

Symptoms

On CS 9 in Production the SSF_PRNT_INV process returns an error.

ERROR
-----------------------
Program: 'SSF_PRNT_INV' starting. (14846,31)

File: e:\pt85117c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1617 Error Position: 0 Return: 8601 - [Microsoft][SQL Native Client][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.
[Microsoft][SQL Native Client][SQL Server]The statement has
Failed SQL stmt:UPDATE PS_SSF_INXTPC_TMP SET TUITION_RES = ( SELECT A.TUITION_RES FROM PS_STDNT_RESID_VW A WHERE A.INSTITUTION = 'SALIS' AND A.EMPLID = PS_SSF_INXTPC_TMP.CONTRACT_EMPLID AND A.TUITION_RES <> ' '), DESCR = ( SELECT R.DESCR FROM PS_RESIDENCY_TBL R WHERE R.RESIDENCY = ( SELECT A1.TUITION_RES FROM PS_STDNT_RESID_VW A1 WHERE A1.INSTITUTION = 'SALIS' AND A1.EMPLID = PS_SSF_INXTPC_TMP.CONTRACT_EMPLID AND A1.TUITION_RES <> ' ') AND R.EFFDT = ( SELECT MAX(R1.EFFDT) FROM PS_RESIDENCY_TBL R1 WHERE R1.RESIDENCY = R.RESIDENCY AND R1.EFFDT
Process 1280872 ABENDED at Step SSF_PRNT_INV.INSTPC.Step04 (SQL) -- RC = 8601 (108,524)

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



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run the print invoice process

BUSINESS IMPACT
-----------------------
Cannot print Bills

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