Prod_seq_num of Reports in Cmn_reg_reports is Updating After Deletion and Addition of New Product (Doc ID 2735068.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

Prod_seq_num of reports in cmn_reg_reports table is updating after deletion and addition of new product.

Steps to repeat:

1. Create a case with 2 products A & B

2. Lock the case

3. Schedule initial and report will schedule with following prod_seq_num in cmn_reg_reports table

Example:
Product A = 1
Product B = 101956

4. Unlock the case and delete product A (by delete option) and add new product C by selecting new product tab and save the case.

5. Update Product C to Product A in product tab

6. Save the case

7. Check the prod_seq_num in cmn_reg_reports table. It is updated from 1 to the new value

Example:
Product A = 101957
Product B = 101956

Cause

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