EAP: Data Conversion Abend At Step UPG_AP.APC40.Step18 (SQL) -- RC = 1407 (108,524)

(Doc ID 2418414.1)

Last updated on JULY 16, 2018

Applies to:

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

Symptoms

Upgrade process abends during Data Conversion at Step UPG_AP.APC40.Step18.

ERROR
File: e:\pt85608c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 21 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_PYCYCL"."OPRID") to NULL
Failed SQL stmt: UPDATE PS_PYCYCL SET OPRID = ( SELECT A.OPRID FROM PS_PYCYCL_STAT A WHERE A.PAY_CYCLE = PS_PYCYCL.PAY_CYCLE AND A.PAY_CYCLE_SEQ_NUM = ( SELECT MIN(B.PAY_CYCLE_SEQ_NUM) FROM PS_PYCYCL_STAT B WHERE B.PAY_CYCLE = A.PAY_CYCLE))
Process 19002664 ABENDED at Step UPG_AP.APC40.Step18 (SQL) -- RC = 1407 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

STEPS
1. Run PeopleSoft FSCM 9.2 upgrade
2. Run Data Conversion step

Changes

 

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