My Oracle Support Banner

GTIN Not Being Used in Purchase Order (PO) Dispatch Even Though GTIN is Assigned on Item (Doc ID 2824891.1)

Last updated on APRIL 01, 2024

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When a supplier is UPN ready and if the item purchased has a GTIN associated, the PO dispatch should replace the supplier item id with the GTIN.

STEPS
---------------
1) Find a supplier and make it UPN active (Suppliers -> Supplier Information -> Add/Update -> Add/Update Supplier -> Location tab -> Procurement link -> Additional Procurement Options)
2) Add Universal Item Identifier to Item (GTIN number) (Items -> Define Items and Attributes -> Define Item -> Manufacturers Link -> Global Trade Item Number -> Universal Item Identifiers Attributes)
3) Create a PO for the supplier and item in steps 1 and 2 (Purchasing -> Purchase Orders -> Add/Update POs)
4) Dispatch the PO from the same page as listed in step #3 above.
5) Via SQL, check the ps_po_line_out_ec table and see that Item ID Vendor is blank. It should be the GTIN number entered in step #2 above.

See replication steps here.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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