Search Results import




The OKS_CON_ERRORS_INT_ALL table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical repository for storing error information related to contract integration processes. This table is part of the Oracle Contracts Core module, specifically designed to log and manage errors that occur during the integration of contract data between Oracle Contracts and other EBS modules or external systems. Below is a detailed analysis of its structure, purpose, and usage in Oracle EBS.

Table Overview

The OKS_CON_ERRORS_INT_ALL table serves as an error logging mechanism for integration processes involving Oracle Contracts. It captures errors that arise during data synchronization, validation failures, or processing issues when contracts are created, modified, or interfaced with other modules like Oracle Order Management, Oracle Receivables, or Oracle Service Contracts. The table is designed to store detailed error messages, timestamps, and contextual data to facilitate troubleshooting and resolution.

Key Columns and Their Significance

  • ERROR_ID: A unique identifier for each error record, typically generated via a sequence.
  • CONTRACT_ID: References the contract (from OKS_K_HEADERS_ALL) associated with the error.
  • ERROR_MESSAGE: Contains the detailed error description or exception message.
  • ERROR_TYPE: Classifies the error (e.g., "VALIDATION," "PROCESSING," or "SYSTEM").
  • STATUS: Indicates whether the error is "NEW," "PROCESSED," or "RESOLVED."
  • CREATION_DATE and LAST_UPDATE_DATE: Track when the error was logged and last modified.
  • SOURCE_SYSTEM: Identifies the originating system (e.g., "ORDER_MANAGEMENT" or "RECEIVABLES").
  • INTERFACE_ID: Links to the integration batch or transaction (e.g., from OKS_CON_INTERFACE_ALL).

Functional Context

In Oracle EBS 12.1.1 and 12.2.2, contract integration involves complex data flows between modules. For example:
  • When a sales order triggers contract creation, validation errors (e.g., missing terms) are logged in OKS_CON_ERRORS_INT_ALL.
  • During renewal or amendment processes, synchronization failures with Oracle Service Contracts may populate this table.
  • External system integrations (e.g., CRM) use this table to capture API or middleware-related errors.

Technical Implementation

The table is typically accessed via:
  • PL/SQL APIs: Oracle-provided packages like OKS_CONTRACT_PUB may write to this table during exception handling.
  • Concurrent Programs: Integration jobs (e.g., "Contract Interface Worker") query this table to reprocess failed records.
  • User Interfaces: The "Contract Administrator" responsibility may include screens to view and resolve errors.

Common Use Cases

  1. Error Resolution: Administrators filter by STATUS='NEW' to address pending errors.
  2. Audit Trails: Historical error data helps identify recurring integration issues.
  3. Custom Extensions: Developers may join this table with OKS_K_HEADERS_ALL for custom reporting.

Version-Specific Considerations

  • EBS 12.2.2: Enhanced error handling with additional columns for cloud integrations.
  • EBS 12.1.1: Limited to on-premises integrations with fewer status flags.

Best Practices

  • Regularly archive resolved errors to maintain performance.
  • Leverage ERROR_TYPE for prioritized troubleshooting.
  • Monitor CREATION_DATE spikes to detect integration bottlenecks.
In summary, OKS_CON_ERRORS_INT_ALL is a vital diagnostic tool for Oracle Contracts integrations, providing transparency and control over error management in Oracle EBS deployments.

  • Lookup Type: OKS_IMPORT_MODE 12.1.1

    product: OKS - Service Contracts ,  meaning: Service Contracts Import Mode ,  description: Service Contracts Import Mode , 

  • Lookup Type: OKS_IMPORT_MODE 12.2.2

    product: OKS - Service Contracts ,  meaning: Service Contracts Import Mode ,  description: Service Contracts Import Mode , 

  • Concurrent Program: OKSIMPRT 12.2.2

    execution_filename: OKS_IMPORT_CONTRACTS.Import_contracts ,  product: OKS - Service Contracts ,  user_name: Service Contracts Import ,  description: Oracle Service Contracts Import ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OKS_IMP_REPORT 12.1.1

    execution_filename: OKS_IMPORT_REPORT.Process_Error_Reporting ,  product: OKS - Service Contracts ,  user_name: Service Contracts Import Report ,  description: Service Contracts Import Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OKSIMPPURGE 12.1.1

    execution_filename: OKS_IMPORT_PURGE.Purge ,  product: OKS - Service Contracts ,  user_name: Service Contracts Import Purge ,  description: Service Contracts Import Purge ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OKSIMPPURGWRKR 12.2.2

    execution_filename: OKS_IMPORT_PURGE_WORKER.Worker_purge ,  product: OKS - Service Contracts ,  user_name: Service Contracts Import Worker Purge ,  description: Service Contracts Import Worker Purge ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OKS_IMP_REPORT 12.2.2

    execution_filename: OKS_IMPORT_REPORT.Process_Error_Reporting ,  product: OKS - Service Contracts ,  user_name: Service Contracts Import Report ,  description: Service Contracts Import Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OKSIMPRT 12.1.1

    execution_filename: OKS_IMPORT_CONTRACTS.Import_contracts ,  product: OKS - Service Contracts ,  user_name: Service Contracts Import ,  description: Oracle Service Contracts Import ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OKSIMPUT 12.2.2

    execution_filename: OKS_IMPORT_TEST_INSERT.Insert_Interface_Records ,  product: OKS - Service Contracts ,  user_name: Service Contracts Import Test program ,  description: Service Contracts Import Testing program ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OKSIMPWRKR 12.1.1

    execution_filename: OKS_IMPORT_CONTRACTS_WORKER.Worker_process ,  product: OKS - Service Contracts ,  user_name: Service Contracts Import Worker ,  description: Service Contracts Import Worker ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OKSIMPPURGE 12.2.2

    execution_filename: OKS_IMPORT_PURGE.Purge ,  product: OKS - Service Contracts ,  user_name: Service Contracts Import Purge ,  description: Service Contracts Import Purge ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OKSIMPWRKR 12.2.2

    execution_filename: OKS_IMPORT_CONTRACTS_WORKER.Worker_process ,  product: OKS - Service Contracts ,  user_name: Service Contracts Import Worker ,  description: Service Contracts Import Worker ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OKSIMPPURGWRKR 12.1.1

    execution_filename: OKS_IMPORT_PURGE_WORKER.Worker_purge ,  product: OKS - Service Contracts ,  user_name: Service Contracts Import Worker Purge ,  description: Service Contracts Import Worker Purge ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OKSIMPUT 12.1.1

    execution_filename: OKS_IMPORT_TEST_INSERT.Insert_Interface_Records ,  product: OKS - Service Contracts ,  user_name: Service Contracts Import Test program ,  description: Service Contracts Import Testing program ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Lookup Type: OKS_IMPORT_STAT_TYPE 12.2.2

    product: OKS - Service Contracts ,  meaning: Service Contracts Import Statistic Type ,  description: Service Contracts Import Statistic Type , 

  • Lookup Type: OKS_IMPORT_STAT_TYPE 12.1.1

    product: OKS - Service Contracts ,  meaning: Service Contracts Import Statistic Type ,  description: Service Contracts Import Statistic Type , 

  • Table: OKS_CON_ERRORS_INT_ALL 12.1.1

    owner:OKS,  object_type:TABLE,  fnd_design_data:OKS.OKS_CON_ERRORS_INT_ALL,  object_name:OKS_CON_ERRORS_INT_ALL,  status:VALID,  product: OKS - Service Contracts ,  description: This table would be using in logging errors during Service Contracts Import. ,  implementation_dba_data: OKS.OKS_CON_ERRORS_INT_ALL , 

  • Table: OKS_CON_ERRORS_INT_ALL 12.2.2

    owner:OKS,  object_type:TABLE,  fnd_design_data:OKS.OKS_CON_ERRORS_INT_ALL,  object_name:OKS_CON_ERRORS_INT_ALL,  status:VALID,  product: OKS - Service Contracts ,  description: This table would be using in logging errors during Service Contracts Import. ,  implementation_dba_data: OKS.OKS_CON_ERRORS_INT_ALL , 

  • Table: OKS_CON_LINES_INT_ALL 12.2.2

    owner:OKS,  object_type:TABLE,  fnd_design_data:OKS.OKS_CON_LINES_INT_ALL,  object_name:OKS_CON_LINES_INT_ALL,  status:VALID,  product: OKS - Service Contracts ,  description: This Interface table is used to import contract lines information to Oracle Contracts for Service application (OKS) as Contract Lines. ,  implementation_dba_data: OKS.OKS_CON_LINES_INT_ALL , 

  • Table: OKS_COV_BILL_RATES_INT_ALL 12.1.1

    owner:OKS,  object_type:TABLE,  fnd_design_data:OKS.OKS_COV_BILL_RATES_INT_ALL,  object_name:OKS_COV_BILL_RATES_INT_ALL,  status:VALID,  product: OKS - Service Contracts ,  description: This Interface table would be used to import Coverage Billing rates (Labor) information to OKS. ,  implementation_dba_data: OKS.OKS_COV_BILL_RATES_INT_ALL , 

  • Table: OKS_COVERAGES_INT_ALL 12.1.1

    owner:OKS,  object_type:TABLE,  fnd_design_data:OKS.OKS_COVERAGES_INT_ALL,  object_name:OKS_COVERAGES_INT_ALL,  status:VALID,  product: OKS - Service Contracts ,  description: This interface table is meant to import all the Coverage information to Oracle Contracts for Service module. ,  implementation_dba_data: OKS.OKS_COVERAGES_INT_ALL , 

  • Table: OKS_COV_BILL_RATES_INT_ALL 12.2.2

    owner:OKS,  object_type:TABLE,  fnd_design_data:OKS.OKS_COV_BILL_RATES_INT_ALL,  object_name:OKS_COV_BILL_RATES_INT_ALL,  status:VALID,  product: OKS - Service Contracts ,  description: This Interface table would be used to import Coverage Billing rates (Labor) information to OKS. ,  implementation_dba_data: OKS.OKS_COV_BILL_RATES_INT_ALL , 

  • Table: OKS_BILLING_HIST_INT_ALL 12.1.1

    owner:OKS,  object_type:TABLE,  fnd_design_data:OKS.OKS_BILLING_HIST_INT_ALL,  object_name:OKS_BILLING_HIST_INT_ALL,  status:VALID,  product: OKS - Service Contracts ,  description: This Interface table is used to import Billing History Information for the Contract lines and covered level lines. ,  implementation_dba_data: OKS.OKS_BILLING_HIST_INT_ALL , 

  • Table: OKS_CON_LINES_INT_ALL 12.1.1

    owner:OKS,  object_type:TABLE,  fnd_design_data:OKS.OKS_CON_LINES_INT_ALL,  object_name:OKS_CON_LINES_INT_ALL,  status:VALID,  product: OKS - Service Contracts ,  description: This Interface table is used to import contract lines information to Oracle Contracts for Service application (OKS) as Contract Lines. ,  implementation_dba_data: OKS.OKS_CON_LINES_INT_ALL , 

  • Table: OKS_COV_BILL_TYPES_INT_ALL 12.1.1

    owner:OKS,  object_type:TABLE,  fnd_design_data:OKS.OKS_COV_BILL_TYPES_INT_ALL,  object_name:OKS_COV_BILL_TYPES_INT_ALL,  status:VALID,  product: OKS - Service Contracts ,  description: This Interface table would be used to import Coverage Billing types for each business process to OKS. ,  implementation_dba_data: OKS.OKS_COV_BILL_TYPES_INT_ALL , 

  • Table: OKS_COVERAGES_INT_ALL 12.2.2

    owner:OKS,  object_type:TABLE,  fnd_design_data:OKS.OKS_COVERAGES_INT_ALL,  object_name:OKS_COVERAGES_INT_ALL,  status:VALID,  product: OKS - Service Contracts ,  description: This interface table is meant to import all the Coverage information to Oracle Contracts for Service module. ,  implementation_dba_data: OKS.OKS_COVERAGES_INT_ALL , 

  • Table: OKS_COV_BILL_TYPES_INT_ALL 12.2.2

    owner:OKS,  object_type:TABLE,  fnd_design_data:OKS.OKS_COV_BILL_TYPES_INT_ALL,  object_name:OKS_COV_BILL_TYPES_INT_ALL,  status:VALID,  product: OKS - Service Contracts ,  description: This Interface table would be used to import Coverage Billing types for each business process to OKS. ,  implementation_dba_data: OKS.OKS_COV_BILL_TYPES_INT_ALL , 

  • Table: OKS_CON_COV_LEVELS_INT_ALL 12.1.1

    owner:OKS,  object_type:TABLE,  fnd_design_data:OKS.OKS_CON_COV_LEVELS_INT_ALL,  object_name:OKS_CON_COV_LEVELS_INT_ALL,  status:VALID,  product: OKS - Service Contracts ,  description: This Interface table is used to import covered levels information from legacy/source system to Oracle Contracts for Service applications. ,  implementation_dba_data: OKS.OKS_CON_COV_LEVELS_INT_ALL , 

  • Table: OKS_BILLING_HIST_INT_ALL 12.2.2

    owner:OKS,  object_type:TABLE,  fnd_design_data:OKS.OKS_BILLING_HIST_INT_ALL,  object_name:OKS_BILLING_HIST_INT_ALL,  status:VALID,  product: OKS - Service Contracts ,  description: This Interface table is used to import Billing History Information for the Contract lines and covered level lines. ,  implementation_dba_data: OKS.OKS_BILLING_HIST_INT_ALL , 

  • Table: OKS_CON_COV_LEVELS_INT_ALL 12.2.2

    owner:OKS,  object_type:TABLE,  fnd_design_data:OKS.OKS_CON_COV_LEVELS_INT_ALL,  object_name:OKS_CON_COV_LEVELS_INT_ALL,  status:VALID,  product: OKS - Service Contracts ,  description: This Interface table is used to import covered levels information from legacy/source system to Oracle Contracts for Service applications. ,  implementation_dba_data: OKS.OKS_CON_COV_LEVELS_INT_ALL , 

  • Table: OKS_COV_TXN_GROUPS_INT_ALL 12.1.1

    owner:OKS,  object_type:TABLE,  fnd_design_data:OKS.OKS_COV_TXN_GROUPS_INT_ALL,  object_name:OKS_COV_TXN_GROUPS_INT_ALL,  status:VALID,  product: OKS - Service Contracts ,  description: This Interface table would be used to import Business processes , their coverage times, reaction times and resolution times attached to the coverage of the Contract line to OKS module. ,  implementation_dba_data: OKS.OKS_COV_TXN_GROUPS_INT_ALL , 

  • Table: OKS_COV_TXN_GROUPS_INT_ALL 12.2.2

    owner:OKS,  object_type:TABLE,  fnd_design_data:OKS.OKS_COV_TXN_GROUPS_INT_ALL,  object_name:OKS_COV_TXN_GROUPS_INT_ALL,  status:VALID,  product: OKS - Service Contracts ,  description: This Interface table would be used to import Business processes , their coverage times, reaction times and resolution times attached to the coverage of the Contract line to OKS module. ,  implementation_dba_data: OKS.OKS_COV_TXN_GROUPS_INT_ALL ,