My Oracle Support Banner

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 MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.2.7 to 6.3.2 [Release 6.2 to 6.3]
Information in this document applies to any platform.

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.