My Oracle Support Banner

Tasks in a Sequential Simplified Batch Do Not Update If Task is Deleted From the Batch (Doc ID 2546615.1)

Last updated on MAY 20, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI / AAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)


On OFSAAI, when editing existing sequential Simplified Batch (pre-existing prior to upgrade to 8061), the rules selected do not reorder the parent tasks appropriately after deleting a task.

After deleting a rule from a sequential simplified batch, the batch_task_precedence_master table does not properly update the V_PARENT_TASK_ID column.

If updating a sequential simplified batch, expect the v_parent_task_id (precedence - parent) to be updated accordingly if a task / rule is deleted from the batch.

The issue can be reproduced at will with the following steps:
1. Edit upgraded sequential simplified batch
2. Delete a rule from the batch and Save
3. Check the BATCH_TASK_PRECEDENCE_MASTER table and find that the V_PARENT_TASK_ID is not properly update.

select * from batch_task_precedence_master where v_batch_id like '<%simplified_batch%>' ORDER BY V_TASK_ID;


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.