Skip to Main Content

increase source value column limit in FDMEE data load mapping

JanGLiNov 23 2018 — edited Nov 26 2018

Hi,

I am creating FDMEE  data load mapping but unfortunately my source value contains nearly 100 letters

E.g

PHARMA - AMBER - STANDARD BOTTLES 60 ML (25 PP) RING BROWN 73GM-FURNACE-6 MANUFACTURED

When i try to create explicit data load mapping manually it removes the extra letters and my mapping becomes like this

PHARMA - AMBER - STANDARD BOTTLES 60 ML (25 PP) RING BROWN 73GM-FURNACE-6 M

pastedImage_5.png

I tried increasing srckey limit in these tables...

TDATAMAP_STG

TDATAMAP_T

TDATAMAPSEG

TDATAMAP

but still can't enter complete value in explicit mapping.

Kindly guide if this is do-able and if yes is it recommended to change structure of standard tables without oracle knowing?

Hyperion Planning 11.1.2.4.008

FDMEE 11.1.2.4.220

Linux 6.6

Our source is custom table

Regards

Comments