Search Results supplier sites

The AP_SUPPLIER_INT_REJECTIONS table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical repository for tracking rejected supplier records during the supplier integration process. This table stores detailed information about supplier data that fails validation or encounters errors when being imported into the Oracle Payables module, typically through interfaces such as the Supplier Open Interface (AP_SUPPLIERS_INT). Understanding its structure, purpose, and usage is essential for troubleshooting integration issues and maintaining data integrity in Oracle EBS. ### **Purpose of AP_SUPPLIER_INT_REJECTIONS** The primary function of this table is to log rejected supplier records during the supplier import process. When data is submitted via the Supplier Open Interface (AP_SUPPLIERS_INT), Oracle validates the entries against predefined business rules. If a record fails validation (e.g., missing mandatory fields, duplicate vendor data, or invalid tax codes), it is moved to AP_SUPPLIER_INT_REJECTIONS instead of being processed into the AP_SUPPLIERS table. This ensures that erroneous data does not corrupt the master supplier tables while providing administrators with a mechanism to review and correct issues. ### **Key Columns and Structure** The table contains columns that capture both the rejected data and the reasons for rejection. Some of the critical columns include: 1. **INTERFACE_LINE_ID**: A unique identifier for the rejected record, often referencing the original AP_SUPPLIERS_INT entry. 2. **REJECTION_REASON**: A descriptive message explaining why the record was rejected (e.g., "Invalid Tax ID" or "Missing Supplier Name"). 3. **BATCH_ID**: Links the rejection to a specific import batch, aiding in bulk error resolution. 4. **CREATION_DATE**: Timestamp indicating when the rejection occurred. 5. **CREATED_BY**: The user or process responsible for the submission. 6. **ATTRIBUTE_CATEGORY/ATTRIBUTE1-15**: Flexfield columns for custom attributes, if configured. 7. **ORG_ID**: Identifies the operating unit associated with the rejected record (multi-org context). ### **Integration Workflow** 1. **Data Submission**: Supplier data is loaded into AP_SUPPLIERS_INT via APIs, spreadsheets, or third-party systems. 2. **Validation**: The "Import Suppliers" concurrent program validates the data against Oracle's rules. 3. **Rejection Handling**: Failed records are inserted into AP_SUPPLIER_INT_REJECTIONS with error details. 4. **Correction**: Administrators query this table, fix errors (e.g., via SQL updates or re-submission), and re-run the import. ### **Common Rejection Scenarios** - **Missing Mandatory Fields**: Supplier name, payment terms, or tax details. - **Duplicate Vendors**: Attempting to create a supplier with an existing TIN or name. - **Invalid Lookup Values**: Incorrect payment methods or currency codes. - **Tax or Legal Compliance Issues**: Mismatched tax registrations or inactive codes. ### **Troubleshooting and Resolution** To resolve rejections: 1. Query AP_SUPPLIER_INT_REJECTIONS using INTERFACE_LINE_ID or BATCH_ID. 2. Analyze the REJECTION_REASON and correct the source data in AP_SUPPLIERS_INT. 3. Purge or reprocess the batch after fixes. ### **Best Practices** - Regularly monitor this table to prevent backlog. - Use custom alerts or workflows to notify stakeholders of rejections. - Document common errors to streamline future data loads. In summary, AP_SUPPLIER_INT_REJECTIONS is a safeguard in Oracle EBS that ensures only valid supplier data enters the system while providing transparency into integration failures. Proper management of this table reduces operational delays and maintains clean vendor master data.

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: 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 ,
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: INVOICE SORT OPTION 12.1.1
product: AP - Payables , meaning: Invoice Sort Option , description: Sort option for invoice audit report ,
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 ,
Lookup Type: INVOICE SORT OPTION 12.2.2
product: AP - Payables , meaning: Invoice Sort Option , description: Sort option for invoice audit report ,
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 ,
Lookup Type: 1099 VENDOR EXCEPTION 12.1.1
product: AP - Payables , meaning: 1099 Supplier Exception , description: Valid 1099 Supplier Exceptions ,
Lookup Type: 1099 VENDOR EXCEPTION 12.2.2
product: AP - Payables , meaning: 1099 Supplier Exception , description: Valid 1099 Supplier Exceptions ,
Lookup Type: AP_IMPORT_OPTIONS 12.1.1
product: AP - Payables , meaning: Payables import options , description: Suppliers and Sites Open Interface Import program options ,
Lookup Type: AP_IMPORT_OPTIONS 12.2.2
product: AP - Payables , meaning: Payables import options , description: Suppliers and Sites Open Interface Import program options ,
Concurrent Program: APXVSRPT 12.1.1
execution_filename: APXVSRPT , product: AP - Payables , user_name: APXVSRPT , description: New Supplier/New Supplier Site Listing , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: APXVSRPT 12.2.2
execution_filename: APXVSRPT , product: AP - Payables , user_name: APXVSRPT , description: New Supplier/New Supplier Site Listing , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Lookup Type: ALL OR ACTIVE 12.2.2
product: AP - Payables , meaning: All Or Active , description: Vendors Report vendors, sites, contacts selection option ,
Lookup Type: ALL OR ACTIVE 12.1.1
product: AP - Payables , meaning: All Or Active , description: Vendors Report vendors, sites, contacts selection option ,
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 ,
Lookup Type: NEW VENDOR/SITE ORDER 12.2.2
product: AP - Payables , meaning: New Vendor/Site Order , description: Sort option for new vendor and new vendor site report ,
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: BANK CHARGE BEARER 12.1.1
product: AP - Payables , meaning: Bank Charge Bearer , description: Indicates who bears bank charges ,
Lookup Type: BANK CHARGE BEARER 12.2.2
product: AP - Payables , meaning: Bank Charge Bearer , description: Indicates who bears bank charges ,
Lookup Type: ACCOUNT TYPE 12.1.1
product: AP - Payables , meaning: Account Type , description: Bank Account Record Types ,
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: ACCOUNT TYPE 12.2.2
product: AP - Payables , meaning: Account Type , description: Bank Account Record Types ,
Lookup Type: DOCUMENT ORDER 12.1.1
product: AP - Payables , meaning: Document Order , description: Order of Documents in Payment Batch ,
Lookup Type: DOCUMENT ORDER 12.2.2
product: AP - Payables , meaning: Document Order , description: Order of Documents in Payment Batch ,
Lookup Type: ORDER BY 12.1.1
product: AP - Payables , meaning: Order By , description: Vendors Report vendor ordering option ,
Lookup Type: ORDER BY 12.2.2
product: AP - Payables , meaning: Order By , description: Vendors Report vendor ordering option ,
Lookup Type: AP_TAX_RECOVERY_CONDITION 12.2.2
product: AP - Payables , meaning: AP Tax Recovery Condition , description: Supplier Classification ,
Lookup Type: AP_TAX_RECOVERY_CONDITION 12.1.1
product: AP - Payables , meaning: AP Tax Recovery Condition , description: Supplier Classification ,
Concurrent Program: APXVDDUP 12.2.2
execution_filename: APXVDDUP , product: AP - Payables , user_name: APXVDDUP , description: Supplier Audit Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: MSB UPGRADE TEXT 12.1.1
product: AP - Payables , meaning: Msb Upgrade Text ,
Lookup Type: MSB UPGRADE TEXT 12.2.2
product: AP - Payables , meaning: Msb Upgrade Text ,
Concurrent Program: APXVDLBL 12.2.2
execution_filename: APXVDLBL , product: AP - Payables , user_name: APXVDLBL , description: Supplier Mailing Labels , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: APXVDLBL 12.1.1
execution_filename: APXVDLBL , product: AP - Payables , user_name: APXVDLBL , description: Supplier Mailing Labels , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: APXVDDUP 12.1.1
execution_filename: APXVDDUP , product: AP - Payables , user_name: APXVDDUP , description: Supplier Audit Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: APXINVPH 12.1.1
execution_filename: APXINVPH , product: AP - Payables , user_name: APXINVPH , description: (Old) Supplier Payment History , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: APXINVPH 12.2.2
execution_filename: APXINVPH , product: AP - Payables , user_name: APXINVPH , description: (Old) Supplier Payment History , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: APXPPHIS 12.2.2
execution_filename: APXPPHIS , product: AP - Payables , user_name: APXPPHIS , description: Payments made to a supplier over a given time period , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: PAYMENT_HISTORY_ORDER_BY 12.1.1
product: AP - Payables , meaning: Payment History Order By , description: For submissions of vendor payment history SRW ,