Cannot Delete Tasks From OFSAAI Batches - ORA-02430 and ORA-00604 Errors (Doc ID 1507485.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.12 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x

Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) 7.2.12, deleting a task included in a batch gives errors. In Batch maintenance when the user selects a task, clicks delete, clicks OK to confirm, the task is still there.  The following errors are thrown in the SMSService.log:

ERROR
[UMMLOG] Nov 19,12 12:14:50 : [SMSSERVICES]Error in executing BatchError while executing Batch :Failed Executing Batch: error occurred during batching: ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 148
ORA-02430: cannot enable constraint (FK_BATCH_TASK_PRECEDENCE_MASTE) - no such constraint

STEPS
The issue can be reproduced at will with the following steps:

1. Attempt to delete one task from a batch.

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