FTP Process Gets 'ORA- 01455: converting column overflows integer datatype' on Instrument Record
(Doc ID 2846973.1)
Last updated on MAY 22, 2023
Applies to:
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Symptoms
When running an FTP Process, an ORA-01455 error occurs when querying for data against the instrument table. The following error is in the ofstp log from $FIC_DB_HOME/log/FusionApps:
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [12] - ofetch(),
ofen() SQL Function: [4] -
SELECT Oracle Error: ORA- 01455: converting column overflows
integer datatype Driver Function: drv_oci::FetchNext() SQL
Statement:
select a.rowid, a.ORG_UNIT_ID, a.GL_ACCOUNT_ID, a.COMMON_COA_ID,
.
.
.
from FSI_D_LOAN_CONTRACTS a
etc.
As a result of the error, some products are not assigned a Transfer Rate.
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 |
| Cause |
| Solution |