ORA-01438 When Performing Ledger Stat Transformation

(Doc ID 282783.1)

Last updated on AUGUST 29, 2007

Applies to:

Oracle Financial Data Manager - Version: 4.5.38
Oracle Financial Services Applications (OFSA) 4.5.38

Symptoms

When attempting to transform Ledger_Stat table the following error occurs in the debug log,

Error
ORA-01438: value larger than specified precision allows for this column.

Steps
1. Navigate: Oracle Performance Analyzer --> Transformation ID -->select Ledger_Stat
2. Received Internal in the Server Status Screen, but no errors in the OFSA_PROCESS_ERRORS table
     where PROCESS_SYS_ID corresponds to the Transformation ID encountering problems.
3. Turn on the debug and found ORA-01438 in the log.


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