Can Not Save the Shipment Ship Unit Remark Qualifier the First Time for Non Count Splittable Orders (Doc ID 2033745.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version 6.3.1 to 6.4.1 [Release 6.3 to 6.4]
Information in this document applies to any platform.

Symptoms

A remark qualifier that is marked as 'Qual Type' date and added as afield on a custom shipment ship unit manager layout, cannot be saved to the UI and DB when updated on the shipment ship unit screen without saving it twice.

When users open the shipment ship unit screen, and change the default date value to something other than what is populated, and hit finished button, system will not save the change, they have to open the screen again and change the value and hit finished to save it to the system.

 

EXAMPLE

------------

1. Create a Order Release (Count Splittable N) > Plan a shipment

2. Go to Configuration and Administration > Power Data >Qualifiers > Remark Qualifiers

Create a Remark Qualifier ID, for example 'TRAN ID DATE'

Qual Type: Date

3. Copy the SSHIP_UNIT manager layout

Added a new field
Label: TRAN-ID-DATE
Field: REMARK TEXT (P)
Remark Qual ID: TRAN ID DATE

4. Copy the SSHIP_UNIT screenset

5. Create an agent that automatically insert date into the Remark Qualifier ID

Agent Type
SHIPMENT SHIP UNIT

SHIPMENT SHIP UNIT - CREATED: INTERNAL or USER

DIRECT SQL UPDATE

INSERT INTO s_ship_unit_remark(S_SHIP_UNIT_GID,REMARK_SEQUENCE,REMARK_QUAL_GID,REMARK_TEXT,DOMAIN_NAME) VALUES ($gid,'1','xxx.TRAN ID DATE',(SELECT TO_CHAR(START_TIME, 'YYYY-MM-DD') FROM SHIPMENT WHERE SHIPMENT_GID =(SELECT SHIPMENT_GID FROM SHIPMENT_STOP_D WHERE s_ship_unit_gid=$gid AND ROWNUM=1)),'xxx')

NOTE: XXX is the domain name

The agent takes the shipment start time, and converting it into the date format YYYY-MM-DD and populating that value as a remark on the shipment ship unit.

The agent inserts 2015-03-12 for example to the shipment ship unit.

6. Open the custom screen set Custom SSHIP_UNIT > search for shipment ship unit (Count Splittable is Y by default, even if you make it N and save the record)

edit
fill in the TRAN ID DATE field with 2015-03-13
saved
re-edit, the TRAN ID DATE field still showing 2015-03-12

change the TRAN ID DATE field with 2015-03-13
saved
re-edit
the field got updated correctly with 2015-03-13

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms