Hello Gurus
I have a process in FDMEE which is working but I've came across an error importing data from a certain month from EBS.
In this month there is a value with the following amount loaded in the PERIOD_NET_DR column from GL_BALANCES: 1607142857142865803571.43
When importing data the process gives an error: "ORA-01438: value larger than specified precision allows for this column". Looking in the Operator (in ODI) I see the problem is inserting in TDATASEG_T table because AMOUNT column definition is number(29,12) and cannot accommodate the value being loaded from EBS
My question now is, can I change the definition of these table in the FDMEE database to number(32,5) for instance?
Thanks guys!!!
Regards,
Eduardo Almeida