Process Failed with ORA- 01455 Converting Column Overflow (Doc ID 1420473.1)

Last updated on FEBRUARY 10, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 5.5 and later
Oracle Financial Services Profitability Management - Version 5.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)


Symptoms

When attempting to run Funds Transfer Pricing (FTP) process, the following error occurs.

Error
SELECT Oracle Error: ORA- 01455: converting column overflows integer datatype Driver Function: drv_oci::FetchNext() SQL Statement:

Steps
1. Defined Funds Transfer Pricing Rule.
2. Ran FTP process and the above error occurs.

Changes

IDENTITY_CODE column size has been changed.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms