Financial Management - PSFT (MOSC)

MOSC Banner

Need to round account balances containing 3 decimal places

Hi Team,

We have several accounts where the balances run to the thousandths of a dollar (three decimal places). We wish to correct all these so they are rounded to the hundredths of a dollar (two decimal places) so they appear properly on all produced reports and queries.

We have identified all accounts where these three decimal place balances exist. We were considering running a mass SQL query on the ledger table to round all these numbers, but were concerned if it may have adverse side-effects, especially considering if we do not correct the original underlying journal entries containing these balances.

Tagged:

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