ALM 8.0.7 T2T_MM_CONTRACTS Fails with "ORA-01722: Invalid Number" Error
(Doc ID 2584008.1)
Last updated on SEPTEMBER 10, 2019
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Table-to-Table Transformation (T2T)
On 8.0.7 version, T2T_MM_CONTRACTS fails with ORA-01722: invalid number error.
This is believed to be due to wrong T2T mapping.
Below query should help you identify the issue:
select * from fsi_d_mm_contracts$
where ora_err_tag$ like '%OFSALMINFO_T2T_ALL_INSTRUMENTS_ALM_20180330_15_Task8%';
ORA-01722: invalid number
STEPS TO REPRODUCE
The issue can be reproduced by executing T2T_MM_CONTRACTS.
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