My Oracle Support Banner

FTP Process With Caterpillar Method Failed With Error Message ORA- 24345: A Truncation or Null Fetch Error Occurred (Doc ID 2801645.1)

Last updated on AUGUST 30, 2021

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.7.4.0 to 8.0.7.4.0 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

After upgrade to oracle database 19 and FTP 8.0.7.4.13, FTP process with caterpillar method fails, from the FTP log file the following error message showing:

Error:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Error: 24345
ORA- 24345: A
Truncation
or null fetch error occurred SQL:
select rev_tab_columns_v.rev_data_type_cd,
rev_tab_columns_v.display_name, rev_tab_columns_v.description,
rev_tab_columns_v.property_column, rev_tab_columns_v.display_flg,
rev_tab_columns_v.data_length, rev_tab_columns_v.data_precision,
rev_tab_columns_v.data_scale, rev_tab_columns_v.column_order,
rev_tab_columns_v.table_name, rev_tab_columns_v.owner,
rev_tab_columns_v.column_name, rev_tab_columns_v.dbf_name,
rev_tab_columns_v.nullable, rev_tab_columns_v.data_type
from rev_tab_columns_v
where rev_tab_columns_v.table_name = 'FSI_M_CASA'
and rev_tab_columns_v.owner = 'APP_MI_DES'
order by rev_tab_columns_v.display_name;

 

Changes

 Upgrade the system to oracle database 19 and FTP 8.0.7.4.13 (previously are oracle database 12 and FTP 8.0.7.3)

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.