My Oracle Support Banner

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.

Symptoms

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.
Example,
With T2t :
1.30886
1.30819
1.16388

Direct Insert :
1.30886
1.30819
1.16388

Changes

 Executed T2T with batch mode

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.