Internal Error Occurs Executing Allocation & ORA-00001 on OFSA_JOBS_RUN_PK (Doc ID 1967336.1)

Last updated on FEBRUARY 04, 2015

Applies to:

Oracle Profitability Manager - Version 4.5 and later
Oracle Financial Data Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA)
Oracle Performance Analyzer (PA)

Symptoms

In Oracle Performance Analyzer (PA) 4.5, when you run Allocations, the processes fails with an "Internal Error".  You get this error for all Allocations.

Checking the ofspa.xxxx file in /<OFSA Home>/log, the following ORA-00001 error exists:

Running allocations with: 137323, 0, user, 03/31/2014, 0.
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:

OCI Function: [4] - oexec(), oexn()
SQL Function: [3] - INSERT
Oracle Error: ORA-00001: unique constraint (<owner>.OFSA_JOBS_RUN_PK) violated

Driver Function: drv_oci::Execute()

SQL Statement: insert into OFSA_JOBS_RUN ( JOB_NUMBER,JOB_START_TIMESTAMP,JOB_STATUS_CD,USERNAME,APPLICATION_CD,SYS_ID_NUM,ALTERNATE_JOB_NUMBER,JOB_END_TIMESTAMP) values ( :JOB_NUMBER, :JOB_START_TIMESTAMP, :JOB_STATUS_CD, :USERNAME, :APPLICATION_CD, :SYS_ID_NUM, :ALTERNATE_JOB_NUMBER, :JOB_END_TIMESTAMP )
Error(Oracle Financial Services Application error) (203055) Error
Bound Parameters:
:JOB_NUMBER = 295294
:JOB_START_TIMESTAMP = 10/01/2014 06:26:52
:JOB_STATUS_CD = 10
:USERNAME = user
:APPLICATION_CD = 0
:SYS_ID_NUM = 137323
:ALTERNATE_JOB_NUMBER = 0
:JOB_END_TIMESTAMP = 01/01/1900 00:00:00 SQL statement.
Error(Oracle Financial Services Application error) (203055) Error Executing SQL statement.


The error appears to prevent the Allocations from running successfully.

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