Receive ORA-01455 on OFSA_IDENTITY_SEQ When Running Allocation ID
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
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.
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