My Oracle Support Banner

Failing Data Stratification With ORA-01438 (Doc ID 3047354.1)

Last updated on SEPTEMBER 20, 2024

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.7.4.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.7.4.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Funds Transfer Pricing (FTP)

Symptoms

On ALM 8.0.7.4.35, when running Data Stratification, the process failed with below error:


Error:

FSI_MESSAGE_LOG shows:

Error Occured: ORA-01438: value larger than specified precision allowed for this column


$FTPSHARE/logs/<MISDATE>/<INFODOM>/TRANSFORM DATA/TRANSFORM_DATA/TRANSFORM DATA_<INFODOM>_292430_STRAT_20231231_1_Task1_RUNPROCEDURE.log

[24-03-24 05:03:20 GMT AM][INFO][BACKEND][OFSAA][RUNPROCEDURE] Database Type : ORACLE
[24-03-24 05:03:20 GMT AM][INFO][BACKEND][OFSAA][RUNPROCEDURE] NLS Value : AMERICAN_AMERICA.UTF8
[24-03-24 05:03:21 GMT AM][INFO][BACKEND][OFSAA][RUNPROCEDURE] Login Information Successfully Set
[24-03-24 05:03:21 GMT AM][INFO][BACKEND][OFSAA][RUNPROCEDURE] Parameters : fn_insert_into_data_strat_tab,'<INFODOM>_292430_STRAT_20231231_1','20231231',292430,'105545'
[24-03-24 05:03:21 GMT AM][INFO][BACKEND][OFSAA][RUNPROCEDURE] Statement to execute : BEGIN :D := fn_insert_into_data_strat_tab('<INFODOM>_292430_STRAT_20231231_1','20231231',292430,'105545'); END;
[24-03-24 05:03:54 GMT AM][INFO][BACKEND][OFSAA][RUNPROCEDURE] Fetching the return status.
[24-03-24 05:03:54 GMT AM][INFO][BACKEND][OFSAA][RUNPROCEDURE] Return value From the Stored Procedure : 0
[24-03-24 05:03:54 GMT AM][SEVERE][BACKEND][OFSAA][RUNPROCEDURE] Error code returned : 513383911
[24-03-24 05:03:54 GMT AM][INFO][BACKEND][OFSAA][RUNPROCEDURE] execPackage : return val : 0
[24-03-24 05:03:54 GMT AM][INFO][BACKEND][OFSAA][RUNPROCEDURE] After Calling execProc
[24-03-24 05:03:54 GMT AM][SEVERE][BACKEND][OFSAA][RUNPROCEDURE] Stored procedure execution failed


Steps To Replicate:
1. Navigate to Common Objects > Data Stratification > Run
2. Process failed.
3. Checked below logs but no specific error.

    FTPSHARE/logs/20240323/<INFODOM>/TRANSFORM DATA

    Transform data logs
    RUNPROCEDURE.log
    DTCPP.log
    DT.log

4. FSI_MESSAGE_LOG shows ORA-01438.

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
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.