ORA-24345 A Truncation or Null Fetch Error While Running FTP Process
(Doc ID 2846778.1)
Last updated on JULY 28, 2023
Applies to:
Oracle Financial Services Funds Transfer Pricing - Version 8.1.1 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Symptoms
While running FTP Process transfer rates get populated however the process fails giving error below:
Error
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Error: 24345 ORA- 24345:
A Truncation or
null fetch error occurred SQL:
select a.rowid, a.ORG_UNIT_ID, a.GL_ACCOUNT_ID, a.COMMON_COA_ID,
a.PRODUCT_ID, a.LEGAL_ENTITY_ID,
a.CUSTOMER_ID, a.id_number, a.identity_code,
a.instrument_type_cd, a.as_of_date, a.cur_net_rate,
a.ADJ_EFFECTIVE_DATE, a.org_term,
...etc
from FSI_D_LOAN_CONTRACTS_DAILY a
where a.ISO_CURRENCY_CD = :ISO_CURRENCY_CD
and a.PRODUCT_ID = :PRODUCT_ID
and (((a.ADJUSTABLE_TYPE_CD = '0')))
and as_of_date = to_date('12/ 09/ 2021', 'mm/ dd/ yyyy')
and LEGAL_ENTITY_ID = 2
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 |