Search Results supplier sites table in ebs




The AP_SUP_SITE_CONTACT_INT table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical interface table used in the Accounts Payable (AP) module to facilitate the staging and validation of supplier site contact information before it is processed into the core system tables. This table plays a pivotal role in supplier management, particularly when importing or integrating contact details for supplier sites from external systems or during data migration.

Purpose and Functionality

The primary purpose of AP_SUP_SITE_CONTACT_INT is to serve as an intermediary storage area for supplier site contact data before it is validated and transferred to the base tables, such as AP_SUPPLIER_SITES and AP_SUPPLIER_CONTACTS. This ensures data integrity and compliance with Oracle EBS validation rules. The table is commonly used in scenarios involving bulk data imports, supplier onboarding, or system integrations where manual entry is impractical.

Key Columns and Structure

The table includes columns that capture essential supplier site contact attributes, such as:
  • VENDOR_SITE_CODE: Identifies the supplier site associated with the contact.
  • VENDOR_CONTACT_CODE: A unique identifier for the contact record.
  • FIRST_NAME, LAST_NAME: Stores the contact person's name details.
  • EMAIL_ADDRESS, PHONE_NUMBER: Captures communication details.
  • STATUS_FLAG: Indicates the processing status (e.g., 'P' for pending, 'E' for error).
  • INTERFACE_LINE_ID: A unique identifier for each record in the interface table.

Integration and Data Flow

Data flows into AP_SUP_SITE_CONTACT_INT through manual inserts, SQL*Loader scripts, or integration tools like Oracle Integration Cloud (OIC). Once populated, the AP_SUPPLIER_INT_PKG PL/SQL package processes the records, validating them against business rules (e.g., mandatory fields, format checks). Successful records are transferred to base tables, while failed records remain in the interface table with error details logged in AP_INTERFACE_REJECTIONS.

Common Use Cases

  1. Supplier Data Migration: During EBS implementations, historical supplier contact data is loaded into this table before validation.
  2. Third-Party Integrations: External systems (e.g., CRM or procurement tools) push contact updates to this interface table.
  3. Bulk Updates Administrators use scripts to update multiple supplier contacts efficiently.

Best Practices

  • Always validate data programmatically before loading to minimize errors.
  • Monitor the STATUS_FLAG and AP_INTERFACE_REJECTIONS to address processing failures promptly.
  • Schedule regular purges of processed records to maintain performance.

Conclusion

The AP_SUP_SITE_CONTACT_INT table is a cornerstone of Oracle EBS's supplier management framework, enabling efficient and error-resistant handling of supplier site contact data. Its design supports high-volume data operations while ensuring adherence to system validations, making it indispensable for organizations leveraging Oracle EBS for accounts payable and supplier lifecycle management.

  • Lookup Type: LABELS SITES 12.2.2

    product: AP - Payables ,  meaning: Labels Sites ,  description: Sites, e.g. non-pay, to be included in mailing labels , 

  • Lookup Type: LABELS SITES 12.1.1

    product: AP - Payables ,  meaning: Labels Sites ,  description: Sites, e.g. non-pay, to be included in mailing labels , 

  • Concurrent Program: APXSSIMP 12.2.2

    execution_filename: APXSSIMP ,  product: AP - Payables ,  user_name: Supplier Sites Open Interface Import ,  description: Supplier Sites Open Interface Import ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: APXSSIMP 12.1.1

    execution_filename: APXSSIMP ,  product: AP - Payables ,  user_name: Supplier Sites Open Interface Import ,  description: Supplier Sites Open Interface Import ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Lookup Type: NEW VENDOR OR NEW SITE 12.1.1

    product: AP - Payables ,  meaning: New Vendor Or New Site ,  description: New vendor or new vendor site report , 

  • Lookup Type: NEW VENDOR OR NEW SITE 12.2.2

    product: AP - Payables ,  meaning: New Vendor Or New Site ,  description: New vendor or new vendor site report , 

  • Concurrent Program: APXSSIMP_XML 12.2.2

    product: AP - Payables ,  user_name: Supplier Sites Open Interface Import (XML) - Not Supported: Reserved For Future Use ,  description: Supplier Sites Open Interface Import ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: APXSSIMP_XML 12.1.1

    product: AP - Payables ,  user_name: Supplier Sites Open Interface Import (XML) - Not Supported: Reserved For Future Use ,  description: Supplier Sites Open Interface Import ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Lookup Type: INVOICE IMPORT REJECTION 12.1.1

    product: AP - Payables ,  meaning: Invoice Import Rejection ,  description: Reason for the rejection of an imported invoice , 

  • Lookup Type: INVOICE IMPORT REJECTION 12.2.2

    product: AP - Payables ,  meaning: Invoice Import Rejection ,  description: Reason for the rejection of an imported invoice , 

  • Lookup Type: CARD TYPE 12.2.2

    product: AP - Payables ,  meaning: Card Type ,  description: Credit card type , 

  • Lookup Type: CARD TYPE 12.1.1

    product: AP - Payables ,  meaning: Card Type ,  description: Credit card type , 

  • Table: AP_SUP_SITE_CONTACT_INT 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_SUP_SITE_CONTACT_INT,  object_name:AP_SUP_SITE_CONTACT_INT,  status:VALID,  product: AP - Payables ,  description: AP_SUP_SITE_CONTACT_INT holds Supplier contact data. The columns in the table map to corresponding columns in PO_VENDOR_CONTACTS table. The Oracle Payables application uses this information to create a new Supplier Contact record when th ,  implementation_dba_data: AP.AP_SUP_SITE_CONTACT_INT , 

  • Table: AP_SUP_SITE_CONTACT_INT 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_SUP_SITE_CONTACT_INT,  object_name:AP_SUP_SITE_CONTACT_INT,  status:VALID,  product: AP - Payables ,  description: AP_SUP_SITE_CONTACT_INT holds Supplier contact data. The columns in the table map to corresponding columns in PO_VENDOR_CONTACTS table. The Oracle Payables application uses this information to create a new Supplier Contact record when th ,  implementation_dba_data: AP.AP_SUP_SITE_CONTACT_INT , 

  • Table: AP_SUPPLIER_INT_REJECTIONS 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_SUPPLIER_INT_REJECTIONS,  object_name:AP_SUPPLIER_INT_REJECTIONS,  status:VALID,  product: AP - Payables ,  description: Contains suppliers, sites, contacts rejections information. ,  implementation_dba_data: AP.AP_SUPPLIER_INT_REJECTIONS , 

  • Table: AP_SUPPLIER_INT_REJECTIONS 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_SUPPLIER_INT_REJECTIONS,  object_name:AP_SUPPLIER_INT_REJECTIONS,  status:VALID,  product: AP - Payables ,  description: Contains suppliers, sites, contacts rejections information. ,  implementation_dba_data: AP.AP_SUPPLIER_INT_REJECTIONS , 

  • Table: AP_CARD_SUPPLIERS_ALL 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_CARD_SUPPLIERS_ALL,  object_name:AP_CARD_SUPPLIERS_ALL,  status:VALID,  product: AP - Payables ,  description: This table contains all of the information relating to the supplier, supplier site, and credit card. ,  implementation_dba_data: AP.AP_CARD_SUPPLIERS_ALL , 

  • Table: AP_SUPPLIERS_INT 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_SUPPLIERS_INT,  object_name:AP_SUPPLIERS_INT,  status:VALID,  product: AP - Payables ,  description: AP_SUPPLIERS_INT holds Supplier information which is loaded by the user for import. The columns in the table map to corresponding columns in the PO_VENDORS table. The Oracle Payables application uses this information to create a new Supp ,  implementation_dba_data: AP.AP_SUPPLIERS_INT , 

  • Table: AP_SUPPLIERS_INT 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_SUPPLIERS_INT,  object_name:AP_SUPPLIERS_INT,  status:VALID,  product: AP - Payables ,  description: AP_SUPPLIERS_INT holds Supplier information which is loaded by the user for import. The columns in the table map to corresponding columns in the PO_VENDORS table. The Oracle Payables application uses this information to create a new Supp ,  implementation_dba_data: AP.AP_SUPPLIERS_INT , 

  • Table: AP_DUPLICATE_VENDORS_ALL 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_DUPLICATE_VENDORS_ALL,  object_name:AP_DUPLICATE_VENDORS_ALL,  status:VALID,  product: AP - Payables ,  description: Supplier information used by Supplier Merge ,  implementation_dba_data: AP.AP_DUPLICATE_VENDORS_ALL , 

  • Table: AP_DUPLICATE_VENDORS_ALL 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_DUPLICATE_VENDORS_ALL,  object_name:AP_DUPLICATE_VENDORS_ALL,  status:VALID,  product: AP - Payables ,  description: Supplier information used by Supplier Merge ,  implementation_dba_data: AP.AP_DUPLICATE_VENDORS_ALL , 

  • Table: AP_SUPPLIER_SITES_INT 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_SUPPLIER_SITES_INT,  object_name:AP_SUPPLIER_SITES_INT,  status:VALID,  product: AP - Payables ,  description: AP_SUPPLIER_SITES_INT_ALL holds Supplier Site information which is loadedby the user for import. The columns in the table map to corresponding columnsin PO_VENDOR_SITES_ALL table. The Oracle Payables application uses this information to ,  implementation_dba_data: AP.AP_SUPPLIER_SITES_INT , 

  • Table: AP_SUPPLIER_SITES_INT 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_SUPPLIER_SITES_INT,  object_name:AP_SUPPLIER_SITES_INT,  status:VALID,  product: AP - Payables ,  description: AP_SUPPLIER_SITES_INT_ALL holds Supplier Site information which is loadedby the user for import. The columns in the table map to corresponding columnsin PO_VENDOR_SITES_ALL table. The Oracle Payables application uses this information to ,  implementation_dba_data: AP.AP_SUPPLIER_SITES_INT , 

  • Table: AP_CARD_SUPPLIERS_ALL 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_CARD_SUPPLIERS_ALL,  object_name:AP_CARD_SUPPLIERS_ALL,  status:VALID,  product: AP - Payables ,  description: This table contains all of the information relating to the supplier, supplier site, and credit card. ,  implementation_dba_data: AP.AP_CARD_SUPPLIERS_ALL , 

  • Table: AP_VENDOR_AUDIT_TMP 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_VENDOR_AUDIT_TMP,  object_name:AP_VENDOR_AUDIT_TMP,  status:VALID,  product: AP - Payables ,  description: Temporary table for duplicate supplier candidates during Supplier Merge ,  implementation_dba_data: AP.AP_VENDOR_AUDIT_TMP , 

  • Table: AP_VENDOR_AUDIT_TMP 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_VENDOR_AUDIT_TMP,  object_name:AP_VENDOR_AUDIT_TMP,  status:VALID,  product: AP - Payables ,  description: Temporary table for duplicate supplier candidates during Supplier Merge ,  implementation_dba_data: AP.AP_VENDOR_AUDIT_TMP , 

  • Table: AP_MC_CHECKS 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_MC_CHECKS,  object_name:AP_MC_CHECKS,  status:VALID,  product: AP - Payables ,  description: Supplier payment data in MRC defined reporting currency ,  implementation_dba_data: AP.AP_MC_CHECKS , 

  • Table: AP_MC_CHECKS 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_MC_CHECKS,  object_name:AP_MC_CHECKS,  status:VALID,  product: AP - Payables ,  description: Supplier payment data in MRC defined reporting currency ,  implementation_dba_data: AP.AP_MC_CHECKS , 

  • Table: AP_1099_TAPE_DATA_ALL 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_1099_TAPE_DATA_ALL,  object_name:AP_1099_TAPE_DATA_ALL,  status:VALID,  product: AP - Payables ,  description: Supplier payment amounts by MISC type for 1099 reports on magnetic media ,  implementation_dba_data: AP.AP_1099_TAPE_DATA_ALL , 

  • Table: AP_1099_TAPE_DATA_ALL 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_1099_TAPE_DATA_ALL,  object_name:AP_1099_TAPE_DATA_ALL,  status:VALID,  product: AP - Payables ,  description: Supplier payment amounts by MISC type for 1099 reports on magnetic media ,  implementation_dba_data: AP.AP_1099_TAPE_DATA_ALL , 

  • Table: AP_AWT_BUCKETS_ALL 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_AWT_BUCKETS_ALL,  object_name:AP_AWT_BUCKETS_ALL,  status:VALID,  product: AP - Payables ,  description: Summary amount of tax withheld to date for a particular supplier site ,  implementation_dba_data: AP.AP_AWT_BUCKETS_ALL , 

  • Table: AP_AWT_BUCKETS_ALL 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_AWT_BUCKETS_ALL,  object_name:AP_AWT_BUCKETS_ALL,  status:VALID,  product: AP - Payables ,  description: Summary amount of tax withheld to date for a particular supplier site ,  implementation_dba_data: AP.AP_AWT_BUCKETS_ALL , 

  • Table: AP_INCOME_TAX_REGIONS 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_INCOME_TAX_REGIONS,  object_name:AP_INCOME_TAX_REGIONS,  status:VALID,  product: AP - Payables ,  description: Income tax region information for supplier tax reporting purposes ,  implementation_dba_data: AP.AP_INCOME_TAX_REGIONS , 

  • Table: AP_INCOME_TAX_REGIONS 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_INCOME_TAX_REGIONS,  object_name:AP_INCOME_TAX_REGIONS,  status:VALID,  product: AP - Payables ,  description: Income tax region information for supplier tax reporting purposes ,  implementation_dba_data: AP.AP_INCOME_TAX_REGIONS , 

  • Table: AP_SUPPLIER_SITES_ALL 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_SUPPLIER_SITES_ALL,  object_name:AP_SUPPLIER_SITES_ALL,  status:VALID,  product: AP - Payables ,  description: AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes. ,  implementation_dba_data: AP.AP_SUPPLIER_SITES_ALL , 

  • Table: AP_SUPPLIER_SITES_ALL 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_SUPPLIER_SITES_ALL,  object_name:AP_SUPPLIER_SITES_ALL,  status:VALID,  product: AP - Payables ,  description: AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes. ,  implementation_dba_data: AP.AP_SUPPLIER_SITES_ALL , 

  • Table: AP_INCOME_TAX_TYPES 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_INCOME_TAX_TYPES,  object_name:AP_INCOME_TAX_TYPES,  status:VALID,  product: AP - Payables ,  description: 1099 supplier types ,  implementation_dba_data: AP.AP_INCOME_TAX_TYPES , 

  • Table: AP_INCOME_TAX_TYPES 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_INCOME_TAX_TYPES,  object_name:AP_INCOME_TAX_TYPES,  status:VALID,  product: AP - Payables ,  description: 1099 supplier types ,  implementation_dba_data: AP.AP_INCOME_TAX_TYPES , 

  • Lookup Type: 1099 VENDOR EXCEPTION 12.1.1

    product: AP - Payables ,  meaning: 1099 Supplier Exception ,  description: Valid 1099 Supplier Exceptions , 

  • Table: AP_SUPPLIER_BALANCE_ITF 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_SUPPLIER_BALANCE_ITF,  object_name:AP_SUPPLIER_BALANCE_ITF,  status:VALID,  product: AP - Payables ,  description: Stores records for the AP Supplier Open Balance Letter report ,  implementation_dba_data: AP.AP_SUPPLIER_BALANCE_ITF , 

  • Lookup Type: 1099 VENDOR EXCEPTION 12.2.2

    product: AP - Payables ,  meaning: 1099 Supplier Exception ,  description: Valid 1099 Supplier Exceptions , 

  • Table: AP_SUPPLIER_BALANCE_ITF 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_SUPPLIER_BALANCE_ITF,  object_name:AP_SUPPLIER_BALANCE_ITF,  status:VALID,  product: AP - Payables ,  description: Stores records for the AP Supplier Open Balance Letter report ,  implementation_dba_data: AP.AP_SUPPLIER_BALANCE_ITF , 

  • Table: AP_VENDOR_KEY_IND_ALL 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_VENDOR_KEY_IND_ALL,  object_name:AP_VENDOR_KEY_IND_ALL,  status:VALID,  product: AP - Payables ,  description: Compiled supplier information for the Key Indicators Report ,  implementation_dba_data: AP.AP_VENDOR_KEY_IND_ALL , 

  • Table: AP_SUPPLIERS 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_SUPPLIERS,  object_name:AP_SUPPLIERS,  status:VALID,  product: AP - Payables ,  description: AP_SUPPLIERS stores information about your supplier level attributes. ,  implementation_dba_data: AP.AP_SUPPLIERS , 

  • Table: AP_VENDOR_KEY_IND_ALL 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_VENDOR_KEY_IND_ALL,  object_name:AP_VENDOR_KEY_IND_ALL,  status:VALID,  product: AP - Payables ,  description: Compiled supplier information for the Key Indicators Report ,  implementation_dba_data: AP.AP_VENDOR_KEY_IND_ALL , 

  • Table: AP_SUPPLIERS 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_SUPPLIERS,  object_name:AP_SUPPLIERS,  status:VALID,  product: AP - Payables ,  description: AP_SUPPLIERS stores information about your supplier level attributes. ,  implementation_dba_data: AP.AP_SUPPLIERS , 

  • Lookup Type: VIEW INVOICES SEARCH 12.2.2

    product: AP - Payables ,  meaning: View Invoices Search ,  description: Search option for selection criteria zone of view invoices , 

  • Lookup Type: VIEW INVOICES SEARCH 12.1.1

    product: AP - Payables ,  meaning: View Invoices Search ,  description: Search option for selection criteria zone of view invoices , 

  • Lookup Type: XML TOKEN NAME 12.1.1

    product: AP - Payables ,  meaning: XML Token Name ,  description: Stores contextual information for Rejected Invoices in Invoice Interface tables , 

  • Lookup Type: XML TOKEN NAME 12.2.2

    product: AP - Payables ,  meaning: XML Token Name ,  description: Stores contextual information for Rejected Invoices in Invoice Interface tables ,