Ship-To Field Values Should be Blank When Using PO Header or PO Line Comments (Doc ID 2737719.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

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

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