Search Results okc_rep_imp_errors_t_n1

Overview

OKC.OKC_REP_IMP_ERRORS_T is a temporary staging table in the Oracle E-Business Suite Contracts (OKC) schema that captures error messages produced during the validation phase of the Import Contracts concurrent process. When contract data is loaded from external sources through the OKC repository import utility, each staged record is validated against business rules. Records that fail validation have their diagnostic information written to this table, which is subsequently used to generate an output CSV file containing the invalid records and their corresponding error messages. The table resides in the APPS_TS_INTERFACE tablespace and its contents are deleted after each import run, confirming its transient, run-scoped nature.

From a Data Vault modeling perspective, the heuristic classification mined from its foreign key structure is standalone. Unlike a true hub, link, or satellite, this object does not participate in a persistent integration model; it is an operational staging artifact scoped to a single concurrent request. The documented foreign key from IMP_CONTRACT_ID to OKC_REP_IMP_CONTRACTS_T indicates a soft association with the parent staging entity rather than a durable business relationship.

Key Information Stored

The eleven documented columns serve validation diagnostics and concurrent program traceability:

• IMP_ERROR_ID — Surrogate primary key sourced from the sequence OKC_REP_IMP_ERRORS_T_S. It is the single documented business-key candidate, enforced by the unique index OKC_REP_IMP_ERROR_T_U1 on APPS_TS_INTERFACE.
• IMP_CONTRACT_ID — Identifier of the import contract to which the error belongs; foreign key to OKC_REP_IMP_CONTRACTS_T.IMP_CONTRACT_ID.
• ERROR_OBJECT_TYPE — Classifies the source of the failing record as CONTRACT, PARTY, or DOCUMENT, directing the user to the correct staging table.
• ERROR_OBJECT_ID — The unique ID of the errored record, resolvable against OKC_REP_IMP_PARTIES_T.imp_party_id, OKC_REP_IMP_DOCUMENTS_T.imp_document_id, or OKC_REP_IMP_CONTRACTS_T.imp_contract_id depending on ERROR_OBJECT_TYPE.
• ERROR_MESSAGE — Free-text diagnostic up to 2000 characters describing why validation failed.
• REQUEST_ID — The concurrent request instance that produced the errors, populated from FND_GLOBAL.conc_request_id and supported by the non-unique index OKC_REP_IMP_ERRORS_T_N1.
• RUN_ID — Groups errors belonging to a specific logical import execution.
• WHO columns — CREATION_DATE, PROGRAM_ID, PROGRAM_LOGIN_ID, and PROGRAM_APPLICATION_ID provide standard audit and program context.

Common Use Cases and Queries

The primary operational use case is post-import error review: after the Import Contracts program completes with warnings, users query this table to identify rejected rows and correct the source data. A typical diagnostic query joins error rows to the parent staging contract:

• SELECT e.imp_error_id, e.imp_contract_id, e.error_object_type, e.error_object_id, e.error_message FROM okc.okc_rep_imp_errors_t e WHERE e.request_id = :p_request_id ORDER BY e.imp_contract_id, e.error_object_type;
• Filtering by ERROR_OBJECT_TYPE isolates failures at the contract, party, or document level, allowing targeted remediation of the corresponding staging table.
• Aggregating by REQUEST_ID or RUN_ID supports error-volume reporting across import runs, typically driving the CSV output that accompanies the import submission.
• Joining to OKC_REP_IMP_CONTRACTS_T on IMP_CONTRACT_ID enriches the error list with contract-level context such as the source contract number.

Related Objects

The following objects are most significant in relation to this table:

• OKC_REP_IMP_CONTRACTS_T — Parent staging table referenced through IMP_CONTRACT_ID; holds contract-level import records.
• OKC_REP_IMP_PARTIES_T — Source of party-level errored records, referenced via ERROR_OBJECT_ID when ERROR_OBJECT_TYPE is PARTY.
• OKC_REP_IMP_DOCUMENTS_T — Source of document-level errored records, referenced via ERROR_OBJECT_ID when ERROR_OBJECT_TYPE is DOCUMENT.
• OKC_REP_IMP_ERRORS_T_S — Sequence supplying IMP_ERROR_ID values.
• OKC_REP_IMP_ERROR_T_U1 / OKC_REP_IMP_ERRORS_T_N1 — Unique and non-unique indexes supporting primary key access and request-based retrieval.
• FND_GLOBAL — Source of REQUEST_ID and PROGRAM_APPLICATION_ID context for the concurrent program.