My Oracle Support Banner

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.

Symptoms


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

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.