SAP App. Engine Process Is Ending In 'No Success' (Doc ID 2220252.1)

Last updated on JANUARY 11, 2017

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : CS 9 Production, Bundle 43

When attempting to run the Process SAP AE_SFA_SAP_BDRV application engine,
the following error occurs.

ERROR
-----------------------
13.36.13 Process 6898630 ABENDED at Step SFA_SAP_LIB.MAXATTU.Step075 (Action SQL) -- RC = 8601
ROLLBACK
/
-- 13.36.13 SQL Error: [Microsoft][SQL Server Native Client 10.0][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 Server Native Client 10.0][SQL


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

WHAT IS WORKING
------------------------
The process was run successfully previously, using the same pop select query

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot evaluate SAP for their students for the term being processed.

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