Worklist Days Remaining Shows Specific Days Immediately After Case Is Created By Copy (Doc ID 2748441.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

When an existing Case which is having Report Schedules is copied to a new case by Case Actions >> Copy menu,
the new case has a specific days value at Worklist >> New >> [Days Remaining] field immediately after the case is created by copy in spite of that the new case does not have any report schedules.

This happens when the source case had date value in CASE_MASTER.DUE_SOON.
When the case is copied, the value in CASE_MASTER.DUE_SOON is unexpectedly copied to the new case.

Steps to Repeat:

1. Find any existing case which has multiple report schedules.
2. Confirm from backend that the found case has date value in CASE_MASTER.DUE_SOON. (e.g.:select case_num, due_soon from case_master where case_num = '<case#>';)
3. Copy the case by Case Actions >> Copy. Case Form becomes to show the copied new case.
4. Go to Case Form >> Regulatory Reports. No report schedules exist. Keep Case Form open for the copied new case.
5. Go to Worklist >> New, then search the copied new case. ---> [Days Remaining] field shows a specific days value. This is incorrect.
6. Check from backend CASE_MASTER.DUE_SOON of the copied new case. (e.g.:select case_num, due_soon from case_master where case_num = '<newcase#>';) ---> CASE_MASTER.DUE_SOON has the same value as source case.

Cause

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