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 FEBRUARY 23, 2023
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 = ‘<Atomic Schema Owner>’
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 |