PC_EXPRSS_AM Process Abended At Step PC_EXPRSS_AM.IntgTrig.ActStat (Action SQL) -- RC = 1427 (Doc ID 2087768.1)

Last updated on JANUARY 04, 2016

Applies to:

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

Symptoms

On : 9.1 version, Other

When attempting to PC_EXPRSS_AM process, the following error occurs in the provided use case

ERROR
-----------------------
File: e:\pt85414b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 131 Return: 1427 - ORA-01427: single-row subquery returns more than one row Failed SQL stmt: UPDATE PS_PC_AM_EXP_TAO4 SET UPDATE_FLAG = 'Y' WHERE PC_AM_INTG_TRIGGER = '5' AND P ROCESS_INSTANCE = 13519 AND ACTIVITY_STATUS = ( SELECT B.ACTIVITY_STATUS FROM PS_PROJ_ACT_STATUS B W HERE B.BUSINESS_UNIT = PS_PC_AM_EXP_TAO4.BUSINESS_UNIT AND B.PROJECT_ID = PS_PC_AM_EXP_TAO4.PROJECT_ ID AND B.ACTIVITY_ID = PS_PC_AM_EXP_TAO4.ACTIVITY_ID AND B.EFFDT=(SELECT MAX(EFFDT) FROM PS_PROJ_ACT _STATUS C WHERE C.BUSINESS_UNIT=B.BUSINESS_UNIT AND C.PROJECT_ID=B.PROJECT_ID AND C.ACTIVITY_ID=B.AC TIVITY_ID AND C.EFFSEQ=B.EFFSEQ AND C.EFFDT<=TO_DATE('2015-09-22','YYYY-MM-DD')) AND B.EFFSEQ = ( SE LECT MAX(EFFSEQ) FROM PS_PROJ_ACT_STATUS D WHERE D.BUSINESS_UNIT=B.BUSINESS_UNIT AND D.PROJECT_ID=B.

Process 13519 ABENDED at Step PC_EXPRSS_AM.IntgTrig.ActStat (SQL) -- RC = 1427

-- 09.31.33 Process 4338263 ABENDED at Step PC_EXPRSS_AM.IntgTrig.ActStat (Action SQL) -- RC = 1427
ROLLBACK

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Project/Activity - TEST3/TEST3. Asset Integration Rules. One Asset Per Activity. Trigger is Activity Status of 'O'.
2. Create a Project/Activity - TEST2/TEST2. Asset Integration Rules. One Asset Per Activity. Trigger is Activity Status of 'O'.
3. Create Activity Status with following effective dates

PC BU Project Activity Eff DT Eff Seq Status
US004 TEST3 TEST3 19-SEP-15 0 A
US004 TEST3 TEST3 22-SEP-15 0 O
US004 TEST3 TEST3 22-SEP-15 1 O
US004 TEST2 TEST2 19-SEP-15 0 A
US004 TEST2 TEST2 19-SEP-15 1 O
US004 TEST2 TEST2 22-SEP-15 0 A

4. Create Express Asset Definition both project/Activty
5. Run PC_EXPRSS_AM process. The process abends with above error



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