Ship-To Field Values Should be Blank When Using PO Header or PO Line Comments
(Doc ID 2737719.1)
Last updated on DECEMBER 18, 2020
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.
When creating PO Header comments or PO Line comments the Ship To field is set in the table in the DB and it should not
Steps to recreate the issue
1) Create a PO
2) Add header comments
3) Add line comments
4) query the db using this query
select a.business_unit, a.po_id, a.shipto_id, a.line_nbr, a.comment_ID, a.random_cmmt_nbr, A.status, a.comment_type, B.comments_2000
from PS_PO_COMMENTS A, PS_COMMENTS_TBL B
where a.comment_ID = B.comment_ID and a.random_cmmt_Nbr = B.random_cmmt_nbr
and a.business_Unit = '<your BU>' and A.PO_ID = '<your PO_ID>' and a.comment_Type <> 'SHP'
Note that the ship to field is filled out, even though it is not a ship to comment
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