Search Results morgate center ltd.,part. thailand : contact number

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: VENDOR NUMBER ENTRY 12.2.2
product: AP - Payables , meaning: Vendor Number Entry , description: Vendor number entry methods ,
Lookup Type: MANUAL VENDOR NUMBER 12.2.2
product: AP - Payables , meaning: Manual Vendor Number , description: Type of vendor number for manual number entry ,
Lookup Type: MANUAL VENDOR NUMBER 12.1.1
product: AP - Payables , meaning: Manual Vendor Number , description: Type of vendor number for manual number entry ,
Lookup Type: VENDOR NUMBER ENTRY 12.1.1
product: AP - Payables , meaning: Vendor Number Entry , description: Vendor number entry methods ,
Lookup Type: OIE_ENABLE_COST_CENTER 12.2.2
product: AP - Payables , meaning: OIE:Enable Cost Center , description: Contains the allowable values for the OIE:Enable Cost Center profile option. ,
Lookup Type: OIE_ENABLE_COST_CENTER 12.1.1
product: AP - Payables , meaning: OIE:Enable Cost Center , description: Contains the allowable values for the OIE:Enable Cost Center profile option. ,
Lookup Type: NLS TRANSLATION 12.1.1
product: AP - Payables , meaning: Nls Translation , description: Words/phrases that need to be NLS ,
Lookup Type: NLS TRANSLATION 12.2.2
product: AP - Payables , meaning: Nls Translation , description: Words/phrases that need to be NLS ,
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 ,
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_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: PREPAY 12.2.2
product: AP - Payables , meaning: Prepay , description: Apply Complete or Partial prepay. ,
Lookup Type: PREPAY 12.1.1
product: AP - Payables , meaning: Prepay , description: Apply Complete or Partial prepay. ,
Lookup Type: MATCH OPTIONS 12.2.2
product: AP - Payables , meaning: Match Options , description: Options available when matching a Purchase Order to an Invoice ,
Lookup Type: MATCH OPTIONS 12.1.1
product: AP - Payables , meaning: Match Options , description: Options available when matching a Purchase Order to an Invoice ,
Lookup Type: CHECKRUN CANCEL ACTIONS 12.1.1
product: AP - Payables , meaning: Checkrun Cancel Actions , description: Cancel part or all of a checkrun if the status permits ,
Lookup Type: CHECKRUN CANCEL ACTIONS 12.2.2
product: AP - Payables , meaning: Checkrun Cancel Actions , description: Cancel part or all of a checkrun if the status permits ,
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 ,
Lookup Type: OIEDETAILINFO 12.2.2
product: AP - Payables , meaning: Cash And Other Detail , description: Cash And Other Details ,
Lookup Type: OIEDETAILINFO 12.1.1
product: AP - Payables , meaning: Cash And Other Detail , description: Cash And Other Details ,
Lookup Type: OIE_CAT_FIELDS_SEARCH_BY 12.1.1
product: AP - Payables , meaning: Category Options Search By , description: Category Options Search By columns ,
Lookup Type: OIE_CAT_FIELDS_SEARCH_BY 12.2.2
product: AP - Payables , meaning: Category Options Search By , description: Category Options Search By columns ,
Lookup Type: VIEW_ACCOUNTING 12.1.1
product: AP - Payables , meaning: View Accounting , description: lookup codes used for NLS translation strings ,
Lookup Type: VIEW_ACCOUNTING 12.2.2
product: AP - Payables , meaning: View Accounting , description: lookup codes used for NLS translation strings ,
Lookup Type: VOUCHER STATUS 12.1.1
product: AP - Payables , meaning: Voucher Status , description: Lists possible statuses for a voucher number ,
Lookup Type: EXCEPTIONS PRINT CHOICES 12.1.1
product: AP - Payables , meaning: Exceptions Print Choices , description: Used by check recon exceptions form to choose next action ,
Lookup Type: EXCEPTIONS PRINT CHOICES 12.2.2
product: AP - Payables , meaning: Exceptions Print Choices , description: Used by check recon exceptions form to choose next action ,
Lookup Type: VOUCHER STATUS 12.2.2
product: AP - Payables , meaning: Voucher Status , description: Lists possible statuses for a voucher number ,
Lookup Type: OIE_MERCHANT_FIELDS 12.1.1
product: AP - Payables , meaning: Merchant Fields , description: Merchant Fields used by policy compliance ,
Lookup Type: OIE_MERCHANT_FIELDS 12.2.2
product: AP - Payables , meaning: Merchant Fields , description: Merchant Fields used by policy compliance ,
Lookup Type: OIE_AUTO_AUDIT_REASONS 12.1.1
product: AP - Payables , meaning: Automatic Audit Reasons , description: Automatic Audit Reasons ,
Lookup Type: OIE_AUTO_AUDIT_REASONS 12.2.2
product: AP - Payables , meaning: Automatic Audit Reasons , description: Automatic Audit Reasons ,
Lookup Type: BANK_CHARGE_SORT_OPTION 12.1.1
product: AP - Payables , meaning: Bank Charge Sort Option , description: Bank Charge Sort Option ,
Lookup Type: ORDERING_OPTION 12.1.1
product: AP - Payables , meaning: Ordering Option , description: Allows user to choose ordering in Invoice Inquiry form ,
Lookup Type: ORDERING_OPTION 12.2.2
product: AP - Payables , meaning: Ordering Option , description: Allows user to choose ordering in Invoice Inquiry form ,
Lookup Type: BANK_CHARGE_SORT_OPTION 12.2.2
product: AP - Payables , meaning: Bank Charge Sort Option , description: Bank Charge Sort Option ,
Lookup Type: OIE_CC_VALIDATION_ERROR 12.2.2
product: AP - Payables , meaning: Validation Error Codes ,
Lookup Type: OIE_CC_VALIDATION_ERROR 12.1.1
product: AP - Payables , meaning: Validation Error Codes ,
Concurrent Program: APXPAYAD 12.1.1
execution_filename: APXPAYAD , product: AP - Payables , user_name: APXPAYAD , description: Payment Audit by Voucher Number , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: OIE_MEALS_ALLOWANCE_RULES 12.2.2
product: AP - Payables , meaning: Meals Allowance Rule Options , description: Meals Allowance Rule Options ,
Lookup Type: RECURRING PAYMENT ORDER 12.1.1
product: AP - Payables , meaning: Recurring Payment Order , description: Recurring Payments Report options ,
Lookup Type: RECURRING PAYMENT ORDER 12.2.2
product: AP - Payables , meaning: Recurring Payment Order , description: Recurring Payments Report options ,
Concurrent Program: APXINVAD 12.1.1
execution_filename: APXINVAD , product: AP - Payables , user_name: APXINVAD , description: Invoice Audit by Voucher Number , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: APXPAYAD 12.2.2
execution_filename: APXPAYAD , product: AP - Payables , user_name: APXPAYAD , description: Payment Audit by Voucher Number , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: APXINVAD 12.2.2
execution_filename: APXINVAD , product: AP - Payables , user_name: APXINVAD , description: Invoice Audit by Voucher Number , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: NEW VENDOR/SITE ORDER 12.1.1
product: AP - Payables , meaning: New Vendor/Site Order , description: Sort option for new vendor and new vendor site report ,