UN Number Is Not Correctly Identified During Requisition

(Doc ID 2124226.1)

Last updated on APRIL 05, 2016

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.


Actual Behavior
UN number 156900 is used across 2 different hazard classes.

25 81 156900 NMFC for Freight Class 55
37 83 156900 NMFC for Freight Class 60

The item id 8408 on a requisition has only one of the above combinations assigned to it.

25 83

When user creates a requisition for the item, user gets the pop up to select the UN number out of the 2 entries 156900.

Expected Behavior
When the UN number is defaulted the UN_number_id 25 should be selected as this is what is on the item.

Steps to Reproduce

  1. Find item that has a UN Number that is not unique in the po_un_numbers table, but which has an unique UN_NUMBER_ID assigned in the MTL_SYTEM_ITEMS.
  2. Create requisition for that item, the pop up appears upon saving.


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