OBIA 11.1.1.10.1 - Universal Adapter SDE GL Balances Rounding Balance $'s To Nearest $ (Doc ID 2099917.1)

Last updated on FEBRUARY 01, 2016

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 and later
Information in this document applies to any platform.

Symptoms

Using OBIA 11.1.1.10.1 The balance figures (BALANCE_ACCT_AMT, BALANCE_LOC_AMT, ACTIVITY_ACCT_AMT, ACTIVITY_LOC_AMT) in the file have 2 decimal places. ODI Mapping SDE_UNIVERSAL_GLBALANCEFACT rounds and loads the dollar amount to the nearest dollar. The decimals are removed.

Universal Adapter SDE Mapping --> SDE_UNIVERSAL_GLBALANCEFACT

Source file --> file_gl_balance_fs.csv

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms