PO_RELEASE_XML View Has Mismatched Columns (Doc ID 2187201.1)

Last updated on NOVEMBER 17, 2016

Applies to:

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

Symptoms

Problem Description
---------------------------------------------------
PO Release printing is not printing the correct data for ATTRIBUTE1 because the PO_RELEASE_XML view has mismatched columns in the column list and the query.

ATTRIBUTE1 in the column list is mapped to PVS.SUPPLIER_NOTIF_METHOD in the select statement
SUPPLIER_NOTIF_METHOD in the column list is mapped to PVS.EMAIL_ADDRESS in the select statement
VENDOR_EMAIL in the column list is mapped to PR.ATTRIBUTE1 in the select statement


STEPS
-------------------
1. Login to the E-Business Suite and choose the Purchasing Module.
2. Run for PO Output For Communication - run for PO Release

BUSINESS IMPACT
-----------------------
Cannot use attribute1 for custom PO pdf reports

Cause

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