After Creation of New Instance from Clone Status Does Not Change to Complete For FTP Process (Doc ID 1966337.1)

Last updated on JANUARY 30, 2015

Applies to:

Oracle Financial Services Asset Liability Management - Version 6.1 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.1 and later
Oracle Financial Services Profitability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On Oracle Financial Services Funds Transfer Pricing 6.1.1 after creating a new instance from a close, the Status column in the FTP Standard Process screen does not change. Errors are found in the agent logs:

ERROR
msg_trace_file.log messages:

Log Message here 1: Mon Jan 5 09:44:52 2015||SEVERE||WriteToDataBase: Error, Could not execute insert statement ...Error code ...1...Error message ...ORA-00001: unique constraint (OFSACFG.SYS_C0047863) violated

Log Message here 1: Mon Jan 5 09:44:52 2015||WARN||ThreadMessage::PopFromQ : s_pLogger->Write failed
Log Message here 1: Mon Jan 5 09:44:52 2015||INFO||Message : OFSAEPM_200706_EXEC_20141130_7: Transfer Pricing Engine: Task1: 2: OFSAA.EXEC_STARTED: OFSTP: INFORM: NOMESSAGE
Error Msg :-> ORA-00001: unique constraint (OFSACFG.SYS_C0047863) violated

The issue can be reproduced at will with the following steps:
1. Run FTP process

Changes

 New instance created from clone.

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