12.2.4 Failing When Loading Oklfedsf.ldt (Doc ID 2065734.1)

Last updated on OCTOBER 21, 2015

Applies to:

Oracle Lease and Finance Management - Version 12.2.4 and later
Information in this document applies to any platform.


When attempting to apply 12.2.4 upgrade Patch 17919161 the following error occurs.

Uploading from the data file /apps/oracle/FLD/fs1/EBSapps/appl/okl/12.0.0/patch/115/import/US/oklfedsf.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/apps/oracle/FLD/fs1/EBSapps/appl/okl/12.0.0/patch/115/import/oklfmaeg.lct(120.5), /apps/oracle/FLD/fs1/EBSapps/appl/okl/12.0.0/patch/115/import/US/oklfedsf.ldt) to staging tables
Dumping LCT file /apps/oracle/FLD/fs1/EBSapps/appl/okl/12.0.0/patch/115/import/oklfmaeg.lct(120.5) into FND_SEED_STAGE_CONFIG
Dumping LDT file /apps/oracle/FLD/fs1/EBSapps/appl/okl/12.0.0/patch/115/import/US/oklfedsf.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (OKL_DATA_SRC_FNCTNS 257064317678449773703455314128499923069 , DO_FMLA_OPRNDS 364596694849120023167115836828683114962 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
 Error loading seed data for DO_FMLA_OPRNDS: DATA_SRC_FNCTN_ID = 364597998945775158659033627812992701443, DSF_OPERAND_ID = 364597307593812426171944832696417316148, FMLA_OPRND_ID = 364596694849120023167115836828683114962, ORA-00001: unique constraint (OKL.OKL_FOD_U3) violated
ORA-06512: at "APPS.OKL_FOD_PVT", line 2302
ORA-01403: no data found

Concurrent request completed
Current system time is Fri Aug 7 11:15:44 2015

The issue can be reproduced at will with the following steps:
1. Apply 12.2.4 patch 17919161.


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