R12: View Apps.PO_VENDOR_CONTACTS Condition Definition May Extract Wrong Supplier Contact Data (Doc ID 2113157.1)

Last updated on MARCH 03, 2016

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

In Oracle eBusiness Suite (EBS) release 12.2.3, the view apps.PO_VENDOR_CONTACTS contains conditions that might extract wrong supplier contact data.

Specifics:
The view apps.PO_VENDOR_CONTACTS is defined with below conditions to get ALT_AREA_CODE and ALT_PHONE:

,(SELECT HCP4.PHONE_AREA_CODE
FROM HZ_CONTACT_POINTS HCP4
WHERE HCP4. OWNER_TABLE_NAME = 'HZ_PARTIES'
AND PVC.REL_PARTY_ID = HCP4.OWNER_TABLE_ID
AND HCP4.CONTACT_POINT_TYPE = 'PHONE'
AND HCP4.PHONE_LINE_TYPE = 'GEN'
AND HCP4.PRIMARY_FLAG = 'N'
AND ROWNUM < 2) ALT_AREA_CODE

,(SELECT HCP7.PHONE_NUMBER
FROM HZ_CONTACT_POINTS HCP7
WHERE HCP7. OWNER_TABLE_NAME = 'HZ_PARTIES'
AND PVC.REL_PARTY_ID = HCP7.OWNER_TABLE_ID
AND HCP7.CONTACT_POINT_TYPE = 'PHONE'
AND HCP7.PHONE_LINE_TYPE = 'GEN'
AND HCP7.PRIMARY_FLAG = 'N'
AND ROWNUM < 2) ALT_PHONE

where hcp# refers to table ar.HZ_CONTACT_POINTS.
There are data with PRIMARY_FLAG = 'N' and STATUS = 'A' or 'I'.
As the condition to check Active status like HCP7.STATUS = 'A' is not included so that wrong data may extracted.

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