PC_AP_TO_PC process Abended At Step PC_AP_TO_PC MAIN.15000001S.1.GBL - ORA-01407: cannot update ("SYSADM"."PS_PC_RES_AP_TA04"."KK_AMOUNT_TYPE") to NULL

(Doc ID 2095921.1)

Last updated on JUNE 20, 2017

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, AP Integration

When attempting to PC_AP_TO_PC process
the following error occurs.

ERROR
-----------------------
Following error is logged

Abend at step PC_AP_TO_PC MAIN.15000001S

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1620 Error Position: 29 Return: 14 07 - ORA-01407: cannot update ("SYSADM"."PS_PC_RES_AP_TA04"."KK_AMOUNT_TYPE") to NULL Failed SQL stmt:UPDATE PS_PC_RES_AP_TA04 SET KK_AMOUNT_TYPE = ( SELECT A.KK_AMOUNT_TYPE FROM PS_PROJ _ANTYPE_TBL A , PS_SET_CNTRL_REC B WHERE A.ANALYSIS_TYPE = PS_PC_RES_AP_TA04.ANALYSIS_TYPE AND B.SET ID = A.SETID AND B.RECNAME = 'PROJ_ANTYPE_TBL' AND B.SETCNTRLVALUE = PS_PC_RES_AP_TA04.BUSINESS_UNIT AND A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_PROJ_ANTYPE_TBL X WHERE X.SETID = A.SETID AND X.ANALYSI S_TYPE = A.ANALYSIS_TYPE AND X.EFFDT<=TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD') AND X.EFF_ STATUS = 'A' )) WHERE KK_AMOUNT_TYPE = ' ' AND PROCESS_INSTANCE = 29009141


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

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