R12: AP: The View Apps.PO_VENDOR_CONTACTS Condition Definition May Exclude Supplier Contact Data
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?
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