Search Results zpstr_ras sap table details

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: PREPAY DETAILS 12.2.2
product: AP - Payables , meaning: Prepay Details , description: Prepayment Entry detail regions and special functions ,
Lookup Type: PREPAY DETAILS 12.1.1
product: AP - Payables , meaning: Prepay Details , description: Prepayment Entry detail regions and special functions ,
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_DETAILS 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_CARD_DETAILS, object_name:AP_CARD_DETAILS, status:VALID, product: AP - Payables , description: New Card Details , implementation_dba_data: AP.AP_CARD_DETAILS ,
Table: AP_CARD_PROFILE_LIMITS_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_CARD_PROFILE_LIMITS_ALL, object_name:AP_CARD_PROFILE_LIMITS_ALL, status:VALID, product: AP - Payables , description: Reserved for a future feature , implementation_dba_data: AP.AP_CARD_PROFILE_LIMITS_ALL ,
Table: AP_AUD_AUTO_AUDITS 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_AUD_AUTO_AUDITS, object_name:AP_AUD_AUTO_AUDITS, status:VALID, product: AP - Payables , description: This table stores an audit list. , implementation_dba_data: AP.AP_AUD_AUTO_AUDITS ,
Table: FINANCIALS_PURGES 12.1.1
product: AP - Payables , description: Invoice purge selection criteria and purged invoice statistical data , implementation_dba_data: Not implemented in this database ,
Table: AP_BANK_CHARGE_LINES 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_BANK_CHARGE_LINES, object_name:AP_BANK_CHARGE_LINES, status:VALID, product: AP - Payables , description: Ranges for bank charges and tolerance limits , implementation_dba_data: AP.AP_BANK_CHARGE_LINES ,
Table: AP_AUD_AUDITORS 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_AUD_AUDITORS, object_name:AP_AUD_AUDITORS, status:VALID, product: AP - Payables , description: This table stores the auditor information , implementation_dba_data: AP.AP_AUD_AUDITORS ,
Table: AP_PBATCH_SET_LINES_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PBATCH_SET_LINES_ALL, object_name:AP_PBATCH_SET_LINES_ALL, status:VALID, product: AP - Payables , description: Payment batch set lines , implementation_dba_data: AP.AP_PBATCH_SET_LINES_ALL ,
Table: AP_AGING_PERIOD_LINES 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_AGING_PERIOD_LINES, object_name:AP_AGING_PERIOD_LINES, status:VALID, product: AP - Payables , description: Individual aging period information , implementation_dba_data: AP.AP_AGING_PERIOD_LINES ,
Table: FINANCIALS_PURGES_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.FINANCIALS_PURGES_ALL, object_name:FINANCIALS_PURGES_ALL, status:VALID, product: AP - Payables , description: Invoice purge selection criteria and purged invoice statistical data , implementation_dba_data: AP.FINANCIALS_PURGES_ALL ,
Table: AP_POL_SCHEDULE_OPTIONS 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_POL_SCHEDULE_OPTIONS, object_name:AP_POL_SCHEDULE_OPTIONS, status:VALID, product: AP - Payables , description: This table stores policy schedule-specific rules. , implementation_dba_data: AP.AP_POL_SCHEDULE_OPTIONS ,
Table: AP_RECON_LOCKS 12.1.1
product: AP - Payables , description: Temporary table for monitoring AutoClear processes , implementation_dba_data: Not implemented in this database ,
Table: AP_PPA_INVOICE_DISTS_GT 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PPA_INVOICE_DISTS_GT, object_name:AP_PPA_INVOICE_DISTS_GT, status:VALID, product: AP - Payables , implementation_dba_data: AP.AP_PPA_INVOICE_DISTS_GT ,
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_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_CARD_PROGRAMS_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_CARD_PROGRAMS_ALL, object_name:AP_CARD_PROGRAMS_ALL, status:VALID, product: AP - Payables , description: Information about credit card programs you have defined , implementation_dba_data: AP.AP_CARD_PROGRAMS_ALL ,
Table: OIE_CURRENT_PAGE_SETTING 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.OIE_CURRENT_PAGE_SETTING, object_name:OIE_CURRENT_PAGE_SETTING, status:VALID, product: AP - Payables , description: This table stores the current setting of a region (hide-show, table..) on a page for each user. , implementation_dba_data: AP.OIE_CURRENT_PAGE_SETTING ,
Table: AP_TEMP_APPROVAL_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_TEMP_APPROVAL_ALL, object_name:AP_TEMP_APPROVAL_ALL, status:VALID, product: AP - Payables , description: No longer used , implementation_dba_data: AP.AP_TEMP_APPROVAL_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_PERIOD_CLOSE_EXCPS_GT 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PERIOD_CLOSE_EXCPS_GT, object_name:AP_PERIOD_CLOSE_EXCPS_GT, status:VALID, product: AP - Payables , implementation_dba_data: AP.AP_PERIOD_CLOSE_EXCPS_GT ,
Table: AP_MC_PAYMENT_HISTORY 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_MC_PAYMENT_HISTORY, object_name:AP_MC_PAYMENT_HISTORY, status:VALID, product: AP - Payables , description: Payment history records in MRC defined reporting currency , implementation_dba_data: AP.AP_MC_PAYMENT_HISTORY ,
Table: AP_POL_EXRATE_OPTIONS_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_POL_EXRATE_OPTIONS_ALL, object_name:AP_POL_EXRATE_OPTIONS_ALL, status:VALID, product: AP - Payables , description: This table stores exchange rate tolerances for policy compliance validation. , implementation_dba_data: AP.AP_POL_EXRATE_OPTIONS_ALL ,
Table: AP_CHECKS_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_CHECKS_ALL, object_name:AP_CHECKS_ALL, status:VALID, product: AP - Payables , description: Supplier payment data , implementation_dba_data: AP.AP_CHECKS_ALL ,
Table: AP_CREDIT_CARD_TRXNS_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_CREDIT_CARD_TRXNS_ALL, object_name:AP_CREDIT_CARD_TRXNS_ALL, status:VALID, product: AP - Payables , description: Detailed information about the credit card transactions of your employees , implementation_dba_data: AP.AP_CREDIT_CARD_TRXNS_ALL ,
Table: FINANCIALS_SYSTEM_PARAMS_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.FINANCIALS_SYSTEM_PARAMS_ALL, object_name:FINANCIALS_SYSTEM_PARAMS_ALL, status:VALID, product: AP - Payables , description: Oracle Financials system parameters and defaults , implementation_dba_data: AP.FINANCIALS_SYSTEM_PARAMS_ALL ,
Table: AP_HISTORY_CHECKS_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_HISTORY_CHECKS_ALL, object_name:AP_HISTORY_CHECKS_ALL, status:VALID, product: AP - Payables , description: Summary information about purged invoice payments , implementation_dba_data: AP.AP_HISTORY_CHECKS_ALL ,
Table: AP_ORG_ATTRIBUTES_GT 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_ORG_ATTRIBUTES_GT, object_name:AP_ORG_ATTRIBUTES_GT, status:VALID, product: AP - Payables , implementation_dba_data: AP.AP_ORG_ATTRIBUTES_GT ,
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_AUD_QUEUES 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_AUD_QUEUES, object_name:AP_AUD_QUEUES, status:VALID, product: AP - Payables , description: This table stores a list of expense reports for auditing along with their assignments to auditors. , implementation_dba_data: AP.AP_AUD_QUEUES ,
Table: AP_HISTORY_INV_PAYMENTS_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_HISTORY_INV_PAYMENTS_ALL, object_name:AP_HISTORY_INV_PAYMENTS_ALL, status:VALID, product: AP - Payables , description: Relationships between purged invoices and invoice payments , implementation_dba_data: AP.AP_HISTORY_INV_PAYMENTS_ALL ,
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_RECURRING_PAYMENTS_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_RECURRING_PAYMENTS_ALL, object_name:AP_RECURRING_PAYMENTS_ALL, status:VALID, product: AP - Payables , description: Recurring invoice parameters , implementation_dba_data: AP.AP_RECURRING_PAYMENTS_ALL ,
Table: OIE_DATA_CAPTURE_RULES 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.OIE_DATA_CAPTURE_RULES, object_name:OIE_DATA_CAPTURE_RULES, status:VALID, product: AP - Payables , description: Stores the expense type data capture rules. , implementation_dba_data: AP.OIE_DATA_CAPTURE_RULES ,
Table: OIE_SET_DISTRIBUTIONS 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.OIE_SET_DISTRIBUTIONS, object_name:OIE_SET_DISTRIBUTIONS, status:VALID, product: AP - Payables , description: Set Distribution Table. , implementation_dba_data: AP.OIE_SET_DISTRIBUTIONS ,
Table: AP_EXPENSE_PARAMS_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_EXPENSE_PARAMS_ALL, object_name:AP_EXPENSE_PARAMS_ALL, status:VALID, product: AP - Payables , description: This table stores the Internet Expenses parameters for organizations. , implementation_dba_data: AP.AP_EXPENSE_PARAMS_ALL ,
Table: AP_CARD_REQUESTS_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_CARD_REQUESTS_ALL, object_name:AP_CARD_REQUESTS_ALL, status:VALID, product: AP - Payables , description: Reserved for a future feature , implementation_dba_data: AP.AP_CARD_REQUESTS_ALL ,
Table: AP_WEB_DISC_LINES_GT 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_WEB_DISC_LINES_GT, object_name:AP_WEB_DISC_LINES_GT, status:VALID, product: AP - Payables , implementation_dba_data: AP.AP_WEB_DISC_LINES_GT ,
Table: AP_ORG_COUNTRY_GT 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_ORG_COUNTRY_GT, object_name:AP_ORG_COUNTRY_GT, status:VALID, product: AP - Payables , implementation_dba_data: AP.AP_ORG_COUNTRY_GT ,
Table: AP_PPA_INVOICE_LINES_GT 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PPA_INVOICE_LINES_GT, object_name:AP_PPA_INVOICE_LINES_GT, status:VALID, product: AP - Payables , implementation_dba_data: AP.AP_PPA_INVOICE_LINES_GT ,
Table: AP_AUD_RULE_SETS 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_AUD_RULE_SETS, object_name:AP_AUD_RULE_SETS, status:VALID, product: AP - Payables , description: This table stores the audit rule set information. , implementation_dba_data: AP.AP_AUD_RULE_SETS ,
Table: OIE_DATA_CAPTURE_FIELDS 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.OIE_DATA_CAPTURE_FIELDS, object_name:OIE_DATA_CAPTURE_FIELDS, status:VALID, product: AP - Payables , description: Stores the field behavior for the data capture rules. , implementation_dba_data: AP.OIE_DATA_CAPTURE_FIELDS ,
Table: AP_EXPENSE_REPORT_LINES_ARC 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_EXPENSE_REPORT_LINES_ARC, object_name:AP_EXPENSE_REPORT_LINES_ARC, status:VALID, product: AP - Payables , description: OIE Archive Table for Expense Report Lines , implementation_dba_data: AP.AP_EXPENSE_REPORT_LINES_ARC ,
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 ,
Table: AP_OTHER_PERIOD_TYPES 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_OTHER_PERIOD_TYPES, object_name:AP_OTHER_PERIOD_TYPES, status:VALID, product: AP - Payables , description: Recurring invoice, key indicator, and withholding tax period type definitions , implementation_dba_data: AP.AP_OTHER_PERIOD_TYPES ,
Table: AP_CARD_GL_ACCTS_ALL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_CARD_GL_ACCTS_ALL, object_name:AP_CARD_GL_ACCTS_ALL, status:VALID, product: AP - Payables , description: Information about the GL accounts and descriptions for credit card GL account sets , implementation_dba_data: AP.AP_CARD_GL_ACCTS_ALL ,
Table: AP_CC_ACCEPTORS 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_CC_ACCEPTORS, object_name:AP_CC_ACCEPTORS, status:VALID, product: AP - Payables , description: This table stores information about credit card acceptors who provide detail-level transaction information. , implementation_dba_data: AP.AP_CC_ACCEPTORS ,
Table: AP_AE_LINES_ALL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_AE_LINES_ALL, object_name:AP_AE_LINES_ALL, status:VALID, product: AP - Payables , description: Accounting entry lines table , implementation_dba_data: AP.AP_AE_LINES_ALL ,
Table: AP_PBATCH_SET_LINES_ALL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PBATCH_SET_LINES_ALL, object_name:AP_PBATCH_SET_LINES_ALL, status:VALID, product: AP - Payables , description: Payment batch set lines , implementation_dba_data: AP.AP_PBATCH_SET_LINES_ALL ,