Search Results service request contact

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

Supplier Data Migration: During EBS implementations, historical supplier contact data is loaded into this table before validation.
Third-Party Integrations: External systems (e.g., CRM or procurement tools) push contact updates to this interface table.
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: REQUEST TYPE 12.1.1
product: AP - Payables , meaning: Request Type , description: Credit card request type ,
Lookup Type: REQUEST STATUS 12.1.1
product: AP - Payables , meaning: Request Status , description: Credit card request status ,
Lookup Type: REQUEST STATUS 12.2.2
product: AP - Payables , meaning: Request Status , description: Credit card request status ,
Lookup Type: REQUEST TYPE 12.2.2
product: AP - Payables , meaning: Request Type , description: Credit card request type ,
Lookup Type: BANK ACCOUNT OPTIONS 12.1.1
product: AP - Payables , meaning: Bank Account Options , description: Navigation Option in Set Up Banks Form ,
Lookup Type: BANK ACCOUNT OPTIONS 12.2.2
product: AP - Payables , meaning: Bank Account Options , description: Navigation Option in Set Up Banks Form ,
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 ,
Lookup Type: MATCH_STATUS 12.1.1
product: AP - Payables , meaning: Match Status , description: Type of Distribution Match ,
Lookup Type: MATCH_STATUS 12.2.2
product: AP - Payables , meaning: Match Status , description: Type of Distribution Match ,
Lookup Type: INVOICE TYPE 12.2.2
product: AP - Payables , meaning: Invoice Type , description: Invoice Type ,
Lookup Type: INVOICE TYPE 12.1.1
product: AP - Payables , meaning: Invoice Type , description: Invoice Type ,
Lookup Type: INVOICE LINE MATCH TYPE 12.1.1
product: AP - Payables , meaning: Invoice Line Match Type , description: Defines available match types ,
Lookup Type: INVOICE LINE MATCH TYPE 12.2.2
product: AP - Payables , meaning: Invoice Line Match Type , description: Defines available match types ,
Lookup Type: CHECK BATCH STATUS 12.1.1
product: AP - Payables , meaning: Check Batch Status , description: Payment Batch Status ,
Lookup Type: CHECK BATCH STATUS 12.2.2
product: AP - Payables , meaning: Check Batch Status , description: Payment Batch Status ,
Lookup Type: CARD_EXPENSE_TYPE 12.1.1
product: AP - Payables , meaning: Card Expense Type , description: Credit Card Expense Type ,
Lookup Type: CARD_EXPENSE_TYPE 12.2.2
product: AP - Payables , meaning: Card Expense Type , description: Credit Card Expense Type ,
Lookup Type: AP_ISP_INV_REQ_TYPE 12.2.2
product: AP - Payables , meaning: Invoice Request Type for Invoices Created in iSP ,
Lookup Type: AP_ISP_INV_REQ_TYPE 12.1.1
product: AP - Payables , meaning: Invoice Request Type for Invoices Created in iSP ,
Lookup Type: CREATE_INSTRS_FLAG 12.2.2
product: AP - Payables , meaning: Payment Instruction Creation Program Flag , description: Payment Instruction Creation Program Flag ,
Lookup Type: CREATE_INSTRS_FLAG 12.1.1
product: AP - Payables , meaning: Payment Instruction Creation Program Flag , description: Payment Instruction Creation Program Flag ,
Lookup Type: INVOICE IMPORT SOURCES 12.1.1
product: AP - Payables , meaning: Invoice Import Sources , description: Translation of the seeded invoice import sources ,
Lookup Type: INVOICE IMPORT SOURCES 12.2.2
product: AP - Payables , meaning: Invoice Import Sources , description: Translation of the seeded invoice import sources ,
Concurrent Program: APXPBFTR 12.2.2
execution_filename: APXPBFTR , product: AP - Payables , user_name: APXPBFTR , description: Format Payments (Bank Transfer Request) , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: APXPBFTR 12.1.1
execution_filename: APXPBFTR , product: AP - Payables , user_name: APXPBFTR , description: Format Payments (Bank Transfer Request) , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: APCRNOT 12.1.1
execution_filename: AP_XML_INVOICE_INBOUND_PKG.NOTIFY_RECIPIENT , product: AP - Payables , user_name: APCRNOT , description: Concurrent Request Notification , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Table: AP_CURRENCY_GROUP 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_CURRENCY_GROUP, object_name:AP_CURRENCY_GROUP, status:VALID, product: AP - Payables , description: Payment currencies for the Payment Process Request Template or the Payment Process Request. , implementation_dba_data: AP.AP_CURRENCY_GROUP ,
Concurrent Program: APCRNOT 12.2.2
execution_filename: AP_XML_INVOICE_INBOUND_PKG.NOTIFY_RECIPIENT , product: AP - Payables , user_name: APCRNOT , description: Concurrent Request Notification , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Table: AP_OU_GROUP 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_OU_GROUP, object_name:AP_OU_GROUP, status:VALID, product: AP - Payables , description: Operating units for the Payment Process Request Template or the Payment Process Request. , implementation_dba_data: AP.AP_OU_GROUP ,
Table: AP_PAY_GROUP 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PAY_GROUP, object_name:AP_PAY_GROUP, status:VALID, product: AP - Payables , description: Pay groups for the Payment Process Request Template or the Payment Process Request. , implementation_dba_data: AP.AP_PAY_GROUP ,
Lookup Type: AP_PAY_HOME_SEARCH 12.1.1
product: AP - Payables , meaning: Payment Manager Home Search , description: Payment Manager Home Search ,
Table: AP_CURRENCY_GROUP 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_CURRENCY_GROUP, object_name:AP_CURRENCY_GROUP, status:VALID, product: AP - Payables , description: Payment currencies for the Payment Process Request Template or the Payment Process Request. , implementation_dba_data: AP.AP_CURRENCY_GROUP ,
Table: AP_PAY_GROUP 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PAY_GROUP, object_name:AP_PAY_GROUP, status:VALID, product: AP - Payables , description: Pay groups for the Payment Process Request Template or the Payment Process Request. , implementation_dba_data: AP.AP_PAY_GROUP ,
Table: AP_OU_GROUP 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_OU_GROUP, object_name:AP_OU_GROUP, status:VALID, product: AP - Payables , description: Operating units for the Payment Process Request Template or the Payment Process Request. , implementation_dba_data: AP.AP_OU_GROUP ,
Table: AP_LE_GROUP 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_LE_GROUP, object_name:AP_LE_GROUP, status:VALID, product: AP - Payables , description: Legal entities for the Payment Process Request Template or the Payment Process Request. , implementation_dba_data: AP.AP_LE_GROUP ,
Lookup Type: AP_PAY_HOME_SEARCH 12.2.2
product: AP - Payables , meaning: Payment Manager Home Search , description: Payment Manager Home Search ,
Table: AP_LE_GROUP 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_LE_GROUP, object_name:AP_LE_GROUP, status:VALID, product: AP - Payables , description: Legal entities for the Payment Process Request Template or the Payment Process Request. , implementation_dba_data: AP.AP_LE_GROUP ,
Lookup Type: AP_PAY_SRV_REQ_DASHBD_STATUS 12.2.2
product: AP - Payables , meaning: Payment Manager Payment Process Request Dashboard Status , description: Payment Manager Payment Process Request Dashboard Status ,
Lookup Type: AP_PAY_SRV_REQ_DASHBD_STATUS 12.1.1
product: AP - Payables , meaning: Payment Manager Payment Process Request Dashboard Status , description: Payment Manager Payment Process Request Dashboard Status ,
Lookup Type: OIE_AUDIT_ACTIONS 12.1.1
product: AP - Payables , meaning: Expenses Audit Actions , description: Expenses Audit Actions ,
Lookup Type: OIE_AUDIT_ACTIONS 12.2.2
product: AP - Payables , meaning: Expenses Audit Actions , description: Expenses Audit Actions ,
Lookup Type: MCC_LEVEL3_PRODUCT_CODES 12.1.1
product: AP - Payables , meaning: LineItem Product Codes for level3 expense type mapping , description: LineItem Product Codes for level3 expense type mapping ,
Lookup Type: MCC_LEVEL3_PRODUCT_CODES 12.2.2
product: AP - Payables , meaning: LineItem Product Codes for level3 expense type mapping , description: LineItem Product Codes for level3 expense type mapping ,
Table: AP_WEB_SIGNING_LIMITS_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_WEB_SIGNING_LIMITS_ALL, object_name:AP_WEB_SIGNING_LIMITS_ALL, status:VALID, product: AP - Payables , description: Tracks signing limit authority for Self-Service Expenses-entered expense reports , implementation_dba_data: AP.AP_WEB_SIGNING_LIMITS_ALL ,
Table: AP_WEB_SIGNING_LIMITS_ALL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_WEB_SIGNING_LIMITS_ALL, object_name:AP_WEB_SIGNING_LIMITS_ALL, status:VALID, product: AP - Payables , description: Tracks signing limit authority for Self-Service Expenses-entered expense reports , implementation_dba_data: AP.AP_WEB_SIGNING_LIMITS_ALL ,
Lookup Type: PAYMENT_TEMPLATE_TYPE 12.2.2
product: AP - Payables , meaning: Payment Process Request Template Type , description: Defines different Types of Payment Templates ,
Lookup Type: PAYMENT_TEMPLATE_TYPE 12.1.1
product: AP - Payables , meaning: Payment Process Request Template Type , description: Defines different Types of Payment Templates ,
Table: AP_USER_EXCHANGE_RATES 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_USER_EXCHANGE_RATES, object_name:AP_USER_EXCHANGE_RATES, status:VALID, product: AP - Payables , description: User type exchange rate when submitting the payment process request for multiple currencies and even multiple functional currencies. , implementation_dba_data: AP.AP_USER_EXCHANGE_RATES ,
Concurrent Program: APXRECLC 12.2.2
execution_filename: AP_AUTOSELECT_PKG.RECALCULATE , product: AP - Payables , user_name: APXRECLC , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,