GROUND_REFNUM Primary Key does not Allow two Reference Numbers for the Same Ground Schedule to Exist with the Same Reference Number Qualifier. (Doc ID 1532965.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

On OTM version 6.2.7.

ACTUAL BEHAVIOR
---------------
The ground_refnum table has two columns that make up the Primary Key, REPETITION_SCHEDULE_GID and GROUND_REFNUM_QUAL_GID, this means that multiple reference number qualifiers with the same qualifier but different values cannot exist.


EXPECTED BEHAVIOR
-----------------------
Expect the Primary Key to be made up of, REPETITION_SCHEDULE_GID, GROUND_REFNUM_QUAL_GID and GROUND_REFNUM_VALUE, this will allow a Reference Number Qualifier to exist many times each time with a different value.

Other Reference Number Qualifiers in OTM are made up using the three colums, for example the Order Release Reference Number Qualifiers.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Open the OTM Data Dictionary.

2. For the table GROUND_REFNUM the columns with the * make up the Primary Key:
* REPETITION_SCHEDULE_GID (FK: REPETITION_SCHEDULE) VARCHAR2(101) NOT NULL
* GROUND_REFNUM_QUAL_GID (FK: GROUND_REFNUM_QUAL) VARCHAR2(101) NOT NULL
  GROUND_REFNUM_VALUE

3. For the table ORDER_RELEASE_REFNUM the columns with the * make up the Primary Key:
* ORDER_RELEASE_GID (FK: ORDER_RELEASE) VARCHAR2(101) NOT NULL
* ORDER_RELEASE_REFNUM_QUAL_GID (FK: ORDER_RELEASE_REFNUM_QUAL) VARCHAR2(101) NOT NULL
* ORDER_RELEASE_REFNUM_VALUE VARCHAR2(240) NOT NULL
  DOMAIN_NAME VARCHAR2(50) NOT NULL

Cause

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