My Oracle Support Banner

E1: 41: Proper Shipping Name Information for Hazardous Materials and Transport Documents (Doc ID 2422794.1)

Last updated on FEBRUARY 04, 2019

Applies to:

JD Edwards EnterpriseOne Transportation Management - Version 9.1 and later
Information in this document applies to any platform.


Department of Transport D.O.T. specifications require that the 'Basic Description' needs to be on the shipping paper work.
Basic Description (§172.202) is described as follows and comes from the Hazardous Materials Table (HTM):
1) Identification Number (UNNA)
2) Proper Shipping Name ( NOT IN JDE - here is the issue )
3) Hazard Class (HZDC)
4) Packing Group (PKGP)
- Example on BOL: UN1830,SULFURIC ACID,8,PGII

The European Agreement Concerning the International Carriage of Dangerous Goods by Road also documents in chapter 5.4 the "Documentation needed for transport of Dangerous Goods".
In you can find the required information in the transport document. (see PDF page 913).

The example of the notation needed:
"UN 1098 ALLYL ALCOHOL, 6.1 (3), I, (C/D)"

The request is to be able to see ALLYL ALCOHOL (which is the proper shipping name of UN 1098) and to be added on the transport document in JDE.

Would like for a new table to be created that would store the relationship between UN number and description. This would also mean we would need a new application that would create the relationship between the UN number
and description. Later on, the UN number would get populated in W4101D Storage/Shipping and the description would come from the new table.

This should get printed on a transport document in the examples provided by the European Agreement Concerning the International Carriage of Dangerous Goods by Road.

Since the UN Proper Shipping Name can be different based on the country using the codes,it also needs to be translated. Please provide the possibility of defining a translation in correlation with the UN code and Description.
(something similar to the F0005D related to F0005 tables)


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

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