General Ledger - EBS (MOSC)

MOSC Banner

Seems like bad data in gl_balances table

edited Nov 21, 2012 7:27PM in General Ledger - EBS (MOSC) 2 commentsAnswered
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



Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center