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
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:
[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
The issue can be reproduced at will with the following steps:
1. Attempt to delete one task from a batch.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms