Numeric Column Rounding-off To 6 Decimals After T2T Insert
(Doc ID 2489206.1)
Last updated on MARCH 04, 2019
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.3 and later
Information in this document applies to any platform.
While running T2T to insert the generated value of an expression for example ((STG_FX_CONTRACTS.N_SELL_AMT (NUMBER(22,3)) / STG_FX_CONTRACT.N_BUY_AMT(NUMBER(22,3)))) to a target column named N_EXCHANGE_RATE_QRM ( number(15,9)) resulting values are getting rounded off to 6 digits.
Note :Insert query from T2T Log is giving proper result in DB.
With T2t :
Direct Insert :
Executed T2T with batch mode
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document