Seems like bad data in gl_balances table
In our prod R12 instance, we have some columns in the gl_balances table that are quite large. By large I mean, more than 30 digits long.
The following is an example of one of the rows:
begin_balance_dr=1,597,184,105,267,821,817,795,096,460.21
begin_balance_cr=1,597,184,105,267,821,818,301,390,578.62
period_net_dr=418,690,632,907,222,612,909,724,445,428,786.40
period_net_cr=418,690,632,907,222,612,909,724,437,381,727.56
How would one go about updating this? So, the number of digits is more manageable.
Thanks,
Hiten
The following is an example of one of the rows:
begin_balance_dr=1,597,184,105,267,821,817,795,096,460.21
begin_balance_cr=1,597,184,105,267,821,818,301,390,578.62
period_net_dr=418,690,632,907,222,612,909,724,445,428,786.40
period_net_cr=418,690,632,907,222,612,909,724,437,381,727.56
How would one go about updating this? So, the number of digits is more manageable.
Thanks,
Hiten
0