ALM 8.0.7 T2T_MM_CONTRACTS Fails with "ORA-01722: Invalid Number" Error
(Doc ID 2584008.1)
Last updated on MARCH 17, 2021
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and laterInformation 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)
Symptoms
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%';
ERROR
ORA_ERR_MESG$
ORA-01722: invalid number
STEPS TO REPRODUCE
The issue can be reproduced by executing T2T_MM_CONTRACTS.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |