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.

Symptoms

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

Specifics
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:

FAX
GEN
MOBILE

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.

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