My Oracle Support Banner

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)

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.