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.
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.
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
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
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)
fill in the TRAN ID DATE field with 2015-03-13
re-edit, the TRAN ID DATE field still showing 2015-03-12
change the TRAN ID DATE field with 2015-03-13
the field got updated correctly with 2015-03-13
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms