Receive ORA-01455 on OFSA_IDENTITY_SEQ When Running Allocation ID

(Doc ID 233742.1)

Last updated on AUGUST 13, 2008

Applies to:

This problem can occur on any platform.
Oracle Financial Services Applications (OFSA) 4.5
Oracle Performance Analyzer - Version: 4.5
Allocation ID

Symptoms

In Oracle Performance Analyzer (PA) 4.5, you cannot run an Allocation ID on the client or server.  You receive the following error:

ORA-01455: converting column overflows integer datatype

Error on SQL statement:
SELECT OFSA_IDENTITY_SEQ.NEXTVAL FROM DUAL;

The error occurs running any Allocation.  The Allocations ran successfully in the past.

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