My Oracle Support Banner

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 DECEMBER 08, 2020

Applies to:

Oracle Argus Safety - Version 8.1.1 and later
Information in this document applies to any platform.

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

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
Symptoms
Cause
Solution
References


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