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