My Oracle Support Banner

R12: AP: The View Apps.PO_VENDOR_CONTACTS Condition Definition May Exclude Supplier Contact Data (Doc ID 2026248.1)

Last updated on SEPTEMBER 09, 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 exclude supplier contact data.

The view apps.PO_VENDOR_CONTACTS is defined with these conditions:

where hcp# refers to table ar.HZ_CONTACT_POINTS

The distinct data within ar.HZ_CONTACT_POINTS.phone_line_type is as below:


That is, the value 'PHONE' is missing. This may mean the apps.PO_VENDOR_CONTACTS view will not bring back some supplier contact data when utilising this view.

However, take note of the following assumptions/points:

1. Assumption 1 :- The table HZ_CONTACT_POINTS contains transaction data and not lookup data.

2. Assumption 2 :- the data in the HZ_CONTACT_POINTS.phone_line_type column is not free text but is based on a lookup called Phone Line Type.

3. In both the use case and the internal instance, none of the values in this lookup type include 'PHONE'.

4. So assuming the above assumptions are correct, why should the view definitions be making these references?

Business impact
Missing/misleading data.


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

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