Unable to load double delimited file to a oracle table in ODI 12C

Hi Team,

In ODI12c (12.2.1.4) , while we are trying to load the file [ which is having || (double pipe) as a field separator ] to table, the table is getting loaded with pipe ( | ) wherevr we havng null values for the column from file.Below is the Case expalined,

Input file format:

ABC||BCD||CDE||DEF||EFG||FGH||GHI||HIJ||IJK

716691||716691||20220302||20220302||||||716690.66||||EGP

Knowledge Modules we used:

LKM: LKM SQL to File

IKM: IKM SQL control append

CKM: default

Field separator used in field Datastore: others [ || ] - \u007c\u007c

Result after loading into the table :

ABC - 716691, BCD- 716691, CDE - 20220302, DEF - 20220302, EFG - | ,FGH- |, GHI- |716690.66, HIJ - null, IJK- |EGP