ECM task to insert data to FCC_ACCOUNTDLY_LOOKUP was failing (Doc ID 2891692.1)

Last updated on NOVEMBER 28, 2022

Applies to:

Symptoms

Version:8.1.1

ECM task to insert data to FCC_ACCOUNTDLY_LOOKUP was failing

OFSAA BD_ECM_20220819 failed to run
[August 22, 2022 at 1:19:52 PM GMT PM +0000][INFO][BACKEND][OFSAA][DTCPP] Exe Name : ./FCCDATAMOVEMENT.sh
[August 22, 2022 at 1:19:52 PM GMT PM +0000][INFO][BACKEND][OFSAA][DTCPP] Parameters : "$RUNID=1589892748698","$PHID=BD_Load_From_LA_To_CA","$EXEID=1589895316239","$RUNSK=4","SOURCENAME=LUAT_OFSAAFCCM","DATAMOVEMENTCODE=BD_ACCOUNTDLY_LOOKUP","LOADTYPE=","DATAMOVEMENTOPERATION=IS"
[Mon Aug 22 13:19:52 2022 PM +0000][INFO][BACKEND][OFSAA][DTCPP] child pid : 9089
[Mon Aug 22 13:20:02 2022 PM +0000][INFO][BACKEND][OFSAA][DTCPP] Exited pid : 9089, status : 256
[Mon Aug 22 13:20:02 2022 PM +0000][INFO][BACKEND][OFSAA][DTCPP] exit status : 1
[Mon Aug 22 13:20:02 2022 PM +0000][INFO][BACKEND][OFSAA][DTCPP] Step Failure : A109A979950E9857E05400144FFB2ABE
[Mon Aug 22 13:20:02 2022 PM +0000][INFO][BACKEND][OFSAA][DTCPP] taskStatus - in isRunnableChildPresent : 1
[Mon Aug 22 13:20:02 2022 PM +0000][INFO][BACKEND][OFSAA][DTCPP] All the steps/jobs have been executed
[Mon Aug 22 13:20:02 2022 PM +0000][INFO][BACKEND][OFSAA][DTCPP] Jobs over.
[Mon Aug 22 13:20:02 2022 PM +0000][INFO][BACKEND][OFSAA][DTCPP] tasksatus inside executesteps - 1
[Mon Aug 22 13:20:02 2022 PM +0000][INFO][BACKEND][OFSAA][DTCPP] Returned from executeSteps : 1
[Mon Aug 22 13:20:02 2022 PM +0000][INFO][BACKEND][OFSAA][DTCPP] Stmt : update AAI_DMT_PLC_EXECUTE set v_status='F' where v_Infodom_Code='FCCMINFO' and v_obj_id='A109A979950E9857E05400144FFB2ABE'
[Mon Aug 22 13:20:02 2022 PM +0000][INFO][BACKEND][OFSAA][DTCPP] Task status : 1
[Mon Aug 22 13:20:02 2022 PM +0000][INFO][BACKEND][OFSAA][DTCPP] Task Failure

Cause

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