My Oracle Support Banner

EAR9.2: DCAR24438029 Abend at Step DCAR24438029.MAIN.Step01 (Doc ID 2478040.1)

Last updated on APRIL 04, 2019

Applies to:

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

Symptoms

When attempting to apply FSCM PUM 28, data conversion the following error occurs:

ERROR
-----------------------
File: e:\pt85608x-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 355 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_CUST_CONVER_DTL"."BUSINESS_UNIT") to NULL
Failed SQL stmt: UPDATE PS_CUST_CONVER_DTL SET CONVR_QUAL_BU = ( SELECT DISTINCT BUSINESS_UNIT FROM PS_CUST_CONVER_DTL B WHERE PS_CUST_CONVER_DTL.SETID = B.SETID AND PS_CUST_CONVER_DTL.CUST_ID = B.CUST_ID AND PS_CUST_CONVER_DTL.CONVER_DTTM_INIT = B.CONVER_DTTM_INIT AND PS_CUST_CONVER_DTL.CONVER_DT = B.CONVER_DT AND PS_CUST_CONVER_DTL.CONVER_SEQ_NUM = B.CONVER_SEQ_NUM), BUSINESS_UNIT = ( SELECT DISTINCT BUSINESS_UNIT FROM PS_CUST_CONVER_HDR C WHERE PS_CUST_CONVER_DTL.SETID = C.SETID AND PS_CUST_CONVER_DTL.CUST_ID = C.CUST_ID AND PS_CUST_CONVER_DTL.CONVER_DTTM_INIT = C.CONVER_DTTM_INIT)

Message Set Number: 200
Message Number: 0
Message Reason: File: e:\pt85608x-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 355 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_CUST_CONVER_DTL"."BUSINESS_UNIT") to NULL
Failed SQL stmt: UPDATE PS_CUST_CONVER_DTL SET CONVR_QUAL_BU = ( SELECT DISTINCT BUSINESS_UNIT FROM PS_CUST_CONVER_DTL B WHERE PS_CUST_CONVER_DTL.SETID = B.SETID AND PS_CUST_CONVER_DTL.CUST_ID = B.CUST_ID AND PS_CUST_CONVER_DTL.CONVER_DTTM_INIT = B.CONVER_DTTM_INIT AND PS_CUST_CONVER_DTL.CONVER_D (200,0)
Process 7751811 ABENDED at Step DCAR24438029.MAIN.Step01 (SQL) -- RC = 1407 (108,524)
Message Set Number: 108
Message Number: 524
Message Reason: Process 7751811 ABENDED at Step DCAR24438029.MAIN.Step01 (SQL) -- RC = 1407 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run data conversion Application Engine

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.