Search Results po_vendor_contacts
The PO_VENDOR_CONTACTS table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical repository for storing vendor contact information within the Purchasing (PO) module. This table serves as a central hub for maintaining contact details of individuals associated with suppliers, enabling efficient communication and transactional processing in procurement operations. Below is a detailed analysis of its structure, functionality, and integration within Oracle EBS.
Table Structure and Key Columns
The PO_VENDOR_CONTACTS table contains columns that define vendor contact attributes, including:- VENDOR_CONTACT_ID: Primary key uniquely identifying each contact record.
- VENDOR_ID: Foreign key linking to PO_VENDORS, associating the contact with a specific supplier.
- VENDOR_SITE_ID: Optional foreign key referencing PO_VENDOR_SITES_ALL to associate contacts with specific vendor locations.
- LAST_NAME, FIRST_NAME: Stores the contact person's name.
- EMAIL_ADDRESS, PHONE: Communication details for the contact.
- FAX, AREA_CODE: Additional contact metadata.
- ACTIVE_FLAG: Indicates whether the contact is active (Y/N).
- CREATION_DATE, LAST_UPDATE_DATE: Audit columns tracking record lifecycle.
Functional Role in Procurement
The table supports core purchasing processes:- Supplier Communication: Facilitates automated notifications (e.g., POs, RFQs) via contact details stored in the table.
- Approval Workflows: Contacts may be designated as approvers for procurement documents.
- Reporting: Enables vendor contact analysis through embedded relationships with other PO tables.
Integration with Oracle EBS Modules
PO_VENDOR_CONTACTS integrates with:- AP (Accounts Payable): Contacts may be referenced for invoice-related correspondence.
- iSupplier Portal: External users access vendor data, including contacts, via this interface.
- Oracle Sourcing: Contacts participate in negotiation workflows.
Technical Considerations
- Indexes: Optimized queries typically use indexes on VENDOR_ID and VENDOR_CONTACT_ID.
- APIs: Oracle provides PL/SQL APIs (e.g., PO_VENDORS_PKG) for programmatic access.
- Security: Access is controlled via Oracle's Function Security and Data Security models.
Customization and Extensions
Common extensions include:- Adding custom columns via Descriptive Flexfields (DFFs).
- Implementing triggers to synchronize contact data with external CRMs.
- Developing workflows leveraging contact attributes for approval routing.
Data Management Best Practices
- Regularly purge obsolete contacts using ACTIVE_FLAG as a filter.
- Leverage Oracle's Trading Community Architecture (TCA) for complex vendor hierarchies.
- Audit contact updates using LAST_UPDATE_DATE for compliance.
-
View: PO_VENDOR_CONTACTS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.PO_VENDOR_CONTACTS, object_name:PO_VENDOR_CONTACTS, status:VALID, product: AP - Payables , implementation_dba_data: APPS.PO_VENDOR_CONTACTS ,
-
View: PO_VENDOR_CONTACTS
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.PO_VENDOR_CONTACTS, object_name:PO_VENDOR_CONTACTS, status:VALID, product: AP - Payables , implementation_dba_data: APPS.PO_VENDOR_CONTACTS ,
-
Table: PO_VENDOR_CONTACTS
12.1.1
product: PO - Purchasing , description: Supplier contacts , implementation_dba_data: Not implemented in this database ,
-
Table: PO_VENDOR_CONTACTS
12.2.2
product: PO - Purchasing , description: Supplier contacts , implementation_dba_data: Not implemented in this database ,
-
APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.OKS_IB_UTIL_PVT dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.AP_SUPPLIER_INFO_PKG dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.PO_REQ_TEMPLATE_SV3 dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.JE_JEHUIAGE_XMLP_PKG dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.MRP_EXP_WF dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.AP_APXINAGE_XMLP_PKG dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.OZF_SD_BATCH_PVT dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.PO_CLOSEOUT_PVT dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.QA_SS_IMPORT_WF dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.IGC_CC_COMMON_UTILS_PVT dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.PO_SIGNATURE_PVT dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.JE_JEHUIAGE_XMLP_PKG dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.OKL_REQ_WF dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.AHL_OSP_ORDERS_PVT dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.PO_VENDOR_SITES_SV dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.PO_REQ_TEMPLATE_SV2 dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.POS_VENDOR_UTIL_PKG dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.JTF_RS_CONC_RES_PUB dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.JA_CN_COA_EXP_PKG dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.PO_REQ_TEMPLATE_SV2 dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.OKC_REP_QA_CHECK_PVT dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.JA_CN_COA_EXP_PKG dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.PO_SIGNATURE_PVT dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.IGC_CC_COMMON_UTILS_PVT dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.ICX_SUPP_CUSTOM dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.PO_EMAIL_GENERATE dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.PO_COMPARE_REVISIONS dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.PO_VAL_HEADERS2 dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.PO_R12_CAT_UPG_DEF_PVT dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.FUN_CONTACTUS_EMAIL dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.MRP_EXP_WF dependencies on PO_VENDOR_CONTACTS
12.1.1
-
APPS.OKS_ENTITLEMENTS_WEB dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.PO_COPYDOC_SUB dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.PO_REQ_TEMPLATE_SV3 dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.AHL_OSP_PO_PVT dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.PO_R12_CAT_UPG_DEF_PVT dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.ICX_SUPP_CUSTOM dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.ICX_REQ_TEMPLATES dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.AP_SUPPLIER_INFO_PKG dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.PO_AUTOCREATE_DOC dependencies on PO_VENDOR_CONTACTS
12.2.2
-
APPS.OKS_ENTITLEMENTS_PVT dependencies on PO_VENDOR_CONTACTS
12.2.2