R12: View Apps.PO_VENDOR_CONTACTS Condition Definition May Extract Wrong Supplier Contact Data
Last updated on MARCH 03, 2016
Applies to:Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
In Oracle eBusiness Suite (EBS) release 12.2.3, the view apps.PO_VENDOR_CONTACTS contains conditions that might extract wrong supplier contact data.
The view apps.PO_VENDOR_CONTACTS is defined with below conditions to get ALT_AREA_CODE and ALT_PHONE:
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
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.
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