Search Results journal import




The AP_INTERFACE_REJECTIONS table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical repository for tracking and managing rejected invoices during the Payables Open Interface import process. This table stores detailed information about invoices that fail validation checks when submitted through the Payables Open Interface (AP_INV_INTERFACE), enabling administrators and functional users to diagnose and rectify issues efficiently. Below is a detailed analysis of its structure, purpose, and operational significance.

Purpose and Functional Context

The Payables Open Interface is a key component of Oracle Payables, allowing batch import of invoice data from external systems (e.g., ERP integrations, legacy systems). During the import process, invoices undergo validation against business rules (e.g., duplicate checks, accounting date validity, supplier verification). If an invoice fails validation, it is logged in AP_INTERFACE_REJECTIONS with error details, while valid records proceed to the AP_INVOICES_INTERFACE table for further processing. This segregation ensures data integrity and provides a mechanism for troubleshooting.

Key Columns and Data Structure

The table includes columns that capture rejection metadata, such as:

  • INTERFACE_LINE_ID: References the original record in AP_INV_INTERFACE.
  • REJECTION_REASON: Descriptive error message (e.g., "Invalid Supplier," "Duplicate Invoice").
  • CREATION_DATE: Timestamp of rejection.
  • CREATED_BY: User or process triggering the rejection.
  • STATUS_FLAG: Indicates whether the issue is unresolved ('R') or corrected ('C').
Additional columns may include context-specific fields like INVOICE_NUM, INVOICE_DATE, and SUPPLIER_ID, linking back to the source data.

Integration with Payables Workflow

Rejected invoices remain in AP_INTERFACE_REJECTIONS until corrective action is taken. Users typically:

  1. Query the table via standard Oracle forms or custom reports to identify errors.
  2. Rectify issues in the source data (e.g., updating supplier master data).
  3. Resubmit corrected records through the Open Interface, which clears the rejection entry upon successful import.
The table integrates with Oracle's workflow notifications, enabling automated alerts for unresolved rejections.

Technical Considerations

In EBS 12.2.2, the table's behavior aligns with earlier versions but may leverage Oracle's online patching (ADOP) for maintenance. Key technical aspects include:

  • Indexing: Optimized for queries on STATUS_FLAG and INTERFACE_LINE_ID.
  • Purge Mechanisms: Rejected records should be archived or purged periodically to maintain performance.
  • Custom Extensions: Organizations often build custom screens or scripts to bulk-process rejections.

Best Practices for Management

To optimize use of this table:

  • Regularly monitor rejections to prevent backlog.
  • Leverage Oracle's Diagnostic Framework for root-cause analysis.
  • Document common rejection scenarios to streamline future imports.

In summary, AP_INTERFACE_REJECTIONS serves as a diagnostic hub for Payables Open Interface failures, ensuring data quality and operational continuity in Oracle EBS deployments. Its structured approach to error handling aligns with Oracle's modular design philosophy, providing transparency and control over the invoice import lifecycle.

  • 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 , 

  • 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 , 

  • Concurrent Program: APXJEHIS 12.2.2

    execution_filename: APXJEHIS ,  product: AP - Payables ,  user_name: APXJEHIS ,  description: Journal with GL Details Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Oracle Reports , 

  • Lookup Type: GATHER_TYPES 12.2.2

    product: AP - Payables ,  meaning: Gather Types ,  description: Transaction type to gather , 

  • Lookup Type: GATHER_TYPES 12.1.1

    product: AP - Payables ,  meaning: Gather Types ,  description: Transaction type to gather , 

  • Concurrent Program: APXJEHIS 12.1.1

    execution_filename: APXJEHIS ,  product: AP - Payables ,  user_name: APXJEHIS ,  description: Journal with GL Details Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Oracle Reports , 

  • Lookup Type: POSTING METHOD 12.1.1

    product: AP - Payables ,  meaning: Posting Method ,  description: Selects the method of posting entries , 

  • Lookup Type: POSTING METHOD 12.2.2

    product: AP - Payables ,  meaning: Posting Method ,  description: Selects the method of posting entries , 

  • Lookup Type: POSTED_INVOICE_RPT_SORT 12.2.2

    product: AP - Payables ,  meaning: Posted Invoice Rpt Sort ,  description: Sort by option for posted invocie report , 

  • Lookup Type: POSTED_PAYMENT_RPT_SORT 12.1.1

    product: AP - Payables ,  meaning: Posted Payment Rpt Sort ,  description: Sort by option for posted payment report , 

  • Lookup Type: POSTED_PAYMENT_RPT_SORT 12.2.2

    product: AP - Payables ,  meaning: Posted Payment Rpt Sort ,  description: Sort by option for posted payment report , 

  • Lookup Type: POSTED_INVOICE_RPT_SORT 12.1.1

    product: AP - Payables ,  meaning: Posted Invoice Rpt Sort ,  description: Sort by option for posted invocie report , 

  • Concurrent Program: APXXTR 12.1.1

    execution_filename: APXXTR ,  product: AP - Payables ,  user_name: APXXTR ,  description: Oracle Payables Invoice Import ,  argument_method: Database fetch ,  enabled: No ,  execution_method: Spawned , 

  • Concurrent Program: APXXTR 12.2.2

    execution_filename: APXXTR ,  product: AP - Payables ,  user_name: APXXTR ,  description: Oracle Payables Invoice Import ,  argument_method: Database fetch ,  enabled: No ,  execution_method: Spawned , 

  • Concurrent Program: APXSCIMP 12.1.1

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

  • 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: APXSUIMP 12.1.1

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

  • Concurrent Program: APXSCIMP 12.2.2

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

  • Concurrent Program: APXSUIMP 12.2.2

    execution_filename: APXSUIMP ,  product: AP - Payables ,  user_name: Supplier Open Interface Import ,  description: Supplier 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 , 

  • Concurrent Program: APXIIMPT 12.2.2

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

  • Concurrent Program: APXIIMPT 12.1.1

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

  • Concurrent Program: APXIIMPT_XML 12.2.2

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

  • Concurrent Program: APXIIMPT_XML 12.1.1

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

  • Concurrent Program: APXSUIMP_XML 12.2.2

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

  • 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: APXSUIMP_XML 12.1.1

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

  • 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: 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 , 

  • Table: AP_INTERFACE_REJECTIONS 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_INTERFACE_REJECTIONS,  object_name:AP_INTERFACE_REJECTIONS,  status:VALID,  product: AP - Payables ,  description: Information about data that could not be loaded by Payables Open Interface Import ,  implementation_dba_data: AP.AP_INTERFACE_REJECTIONS , 

  • Table: AP_INTERFACE_REJECTIONS 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_INTERFACE_REJECTIONS,  object_name:AP_INTERFACE_REJECTIONS,  status:VALID,  product: AP - Payables ,  description: Information about data that could not be loaded by Payables Open Interface Import ,  implementation_dba_data: AP.AP_INTERFACE_REJECTIONS , 

  • View: AP_INVOICE_IMPORT_REJECTION_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_INVOICE_IMPORT_REJECTION_V,  object_name:AP_INVOICE_IMPORT_REJECTION_V,  status:VALID,  product: AP - Payables ,  implementation_dba_data: APPS.AP_INVOICE_IMPORT_REJECTION_V , 

  • View: AP_INVOICE_IMPORT_SOURCES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_INVOICE_IMPORT_SOURCES_V,  object_name:AP_INVOICE_IMPORT_SOURCES_V,  status:VALID,  product: AP - Payables ,  implementation_dba_data: APPS.AP_INVOICE_IMPORT_SOURCES_V , 

  • View: AP_INVOICE_IMPORT_SOURCES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_INVOICE_IMPORT_SOURCES_V,  object_name:AP_INVOICE_IMPORT_SOURCES_V,  status:VALID,  product: AP - Payables ,  implementation_dba_data: APPS.AP_INVOICE_IMPORT_SOURCES_V , 

  • View: AP_INVOICE_IMPORT_REJECTION_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_INVOICE_IMPORT_REJECTION_V,  object_name:AP_INVOICE_IMPORT_REJECTION_V,  status:VALID,  product: AP - Payables ,  implementation_dba_data: APPS.AP_INVOICE_IMPORT_REJECTION_V , 

  • Table: AP_INVOICES_INTERFACE 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_INVOICES_INTERFACE,  object_name:AP_INVOICES_INTERFACE,  status:VALID,  product: AP - Payables ,  description: Information used to create an invoice using Payables Open Interface Import ,  implementation_dba_data: AP.AP_INVOICES_INTERFACE , 

  • Table: AP_INVOICES_INTERFACE 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_INVOICES_INTERFACE,  object_name:AP_INVOICES_INTERFACE,  status:VALID,  product: AP - Payables ,  description: Information used to create an invoice using Payables Open Interface Import ,  implementation_dba_data: AP.AP_INVOICES_INTERFACE , 

  • 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_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_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_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 , 

  • Lookup Type: LINE SOURCE 12.1.1

    product: AP - Payables ,  meaning: Line Source ,  description: Defines possible sources to capture source of creation of a line , 

  • Lookup Type: LINE SOURCE 12.2.2

    product: AP - Payables ,  meaning: Line Source ,  description: Defines possible sources to capture source of creation of a line , 

  • Lookup Type: SOURCE 12.2.2

    product: AP - Payables ,  meaning: Source ,  description: Source of invoice data to import from the Payables Open Interface , 

  • Lookup Type: SOURCE 12.1.1

    product: AP - Payables ,  meaning: Source ,  description: Source of invoice data to import from the Payables Open Interface , 

  • Lookup Type: REJECT CODE 12.1.1

    product: AP - Payables ,  meaning: Reject Code ,  description: Reject Codes for AP Open Interface , 

  • Lookup Type: REJECT CODE 12.2.2

    product: AP - Payables ,  meaning: Reject Code ,  description: Reject Codes for AP Open Interface ,