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 184.108.40.206.0 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 220.127.116.11, 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