EEX9.2: Credit Card Overdue Report Process Fails with Single-Row Subquery Returns More Than One Row (Doc ID 2227962.1)

Last updated on JANUARY 29, 2017

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Credit Card Overdue Report process fails. It occurs when the Expense Type has two different Descriptions.


Steps:
-----------
1) Ensure that an Employee has an overdue Credit Card Transaction.
2) Add an Effdt date row for one of the Expense Type of the overdue transaction.
3) Run Credit Card Overdue Transaction Report process for the Emplid.


Process fails with following error:


Error when using Oracle Database:

File: e:\pt85508b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #:1723 Error Position: 46 Return: 1427 - ORA-01427: single-row subquery returns more than one row Failed SQL stmt: UPDATE PS_EX_CCOVD_TA24 SET
DESCR_EX_TYPE = ( SELECT DESCR FROM PS_EX_TYPES_TBL EX , PS_SET_CNTRL_REC CTL WHERE PS_EX_CCOVD_TA24.BUSINESS_UNIT_GL = CTL.SETCNTRLVALUE AND CTL.RECNAME = 'EX_TYPES_TBL' AND EX.SETID = CTL.SETID AND EX.EXPENSE_TYPE = PS_EX_CCOVD_TA24.EXPENSE_TYPE AND EX. EFF_STATUS = 'A' ) WHERE PROCESS_INSTANCE = 96129 AND EXISTS ( SELECT 'X' FROM PS_EX_TYPES_TBL EX , PS_SET_CNTRL_REC CTL WHERE PS_EX_CCOVD_TA24.BUSINESS_UNIT_GL = CTL.SETCNTRLVALUE AND CTL.RECNAME = ' EX_TYPES_TBL' AND EX.SETID = CTL.SETID AND EX.EXPENSE_TYPE = PS_EX_CCOVD_TA24.EXPENSE_TYPE AND EX.EF F_STATUS = 'A' )

Process 96129 ABENDED at Step EX_CCOVD_RPT.BldData.UpdExTyp (SQL) -- RC =1427

 

Error when using MS SQL Server Database:


Stmt #: 1723 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.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 11.0][SQL Failed SQL stmt: UPDATE PS_EX_CCOVD_TA25 SET DESCR_EX_TYPE = ( SELECT DESCR FROM PS_EX_TYPES_TBL EX , PS_SET_CNTRL_REC CTL WHERE PS_EX_CCOVD_TA25.BUSINESS_UNIT_GL = CTL.SETCNTRLVALUE AND CTL.RECNAME = 'EX_TYPES_TBL' AND EX.SETID = CTL.SETID AND EX.EXPENSE_TYPE = PS_EX_CCOVD_TA25.EXPENSE_TYPE AND EX.EFF_STATUS = 'A' ) WHERE PROCESS_INSTANCE = 60640 AND EXISTS ( SELECT 'X' FROM PS_EX_TYPES_TBL EX , PS_SET_CNTRL_REC CTL WHERE PS_EX_CCOVD_TA25.BUSINESS_UNIT_GL = CTL.SETCNTRLVALUE AND CTL.RECNAME = 'EX_TYPES_TBL' AND EX.SETID = CTL.SETID AND EX.EXPENSE_TYPE = PS_EX_CCOVD_TA25.EXPENSE_TYPE AND EX.EFF_STATUS = 'A' )

Process 60640 ABENDED at Step EX_CCOVD_RPT.BldData.UpdExTyp (SQL) -- RC = 8601 (108,524).

Please see replication steps document for more details.

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