Unassign Driver Deletes The NFR Stop But Not The Stop Refnum. (Doc ID 1310076.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

On : 6.1.0 version,


Unassign Driver action deletes the NFR stop but not the stop's refnums

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

1. Create an Order: NFR-SHIPMENT
2. Plan a Shipment: 01324
3. Run the Assign Driver action on the shipment.
An NFR stop gets added when a driver is assigned to the shipment.

Stop1 (NFR)
Stop2 (P)
Stop3 (D)

2- Edit the NFR stop and add a refnum:
A stop level reference number gets added to the NFR stop.

Reference Number Qualifier ID: REFNUM1
Reference Number: REFNUM1

3- Check the DB:

select * from SHIPMENT_STOP_REFNUM where SHIPMENT_GID='IBAHGAT.01324'

SHIPMENT_GID STOP_NUM SHIPMENT_STOP_REFNUM_QUAL_GID SHIPMENT_STOP_REFNUM_VALUE DOMAIN_NAME INSERT_USER INSERT_DATE UPDATE_USER UPDATE_DATEIBAHGAT.01324 1 IBAHGAT.REFNUM1 REFNUM1 IBAHGAT IBAHGAT.ADMIN 2011-01-20 12:24:56.0 null null

4- Run Unassin Driver.

Driver Successfully Unassigned From Shipment
NFR stop deleted.

5- Check the DB again:

select * from SHIPMENT_STOP_REFNUM where SHIPMENT_GID='IBAHGAT.01324'

SHIPMENT_GID STOP_NUM SHIPMENT_STOP_REFNUM_QUAL_GID SHIPMENT_STOP_REFNUM_VALUE DOMAIN_NAME INSERT_USER INSERT_DATE UPDATE_USER UPDATE_DATEIBAHGAT.01324 1 IBAHGAT.REFNUM1 REFNUM1 IBAHGAT IBAHGAT.ADMIN 2011-01-20 12:24:56.0 null null

6- Check the shipment's first stop (P) > You find the refnum of the deleted NFR stop.

Reference Number Qualifier ID: REFNUM1
Reference Number: REFNUM1

The NFR stop gets deleted from the shipment. However you find that the stop level reference number that you added still remains in the OTM Database and gets reflected in the 1st stop of the shipment. You are expecting that if the NFR stop gets deleted, the stop level reference numbers will also get deleted.

Cause

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