Search Results create_job

Overview

ICX_POR_TRACK_VALIDATE_JOB_S is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. It supports the supplier item catalog and price validation workflow, a component of the Oracle iProcurement and Oracle Purchasing supplier content ingestion infrastructure. The package manages the lifecycle of validation jobs submitted through the procurement "Punchout" and catalog upload interfaces. These jobs process supplier-provided item and price files, reconcile them against hosted catalog content, and record success and failure statistics at the job, item, price, and header level.

The package is classified as OTHER in the ETRM repository, meaning it is not a published open interface API but an internal supporting module invoked by higher-level catalog loading processes. Its source header (ICXVALJB.pls, version 115.33) indicates it has been maintained across multiple release cycles and carries debugging instrumentation through a global error message buffer.

Key Procedures and Functions

The package exposes six documented procedures and functions:

• CREATE_JOB — Creates a new batch validation job record. It consumes parameters identifying the supplier, the supplier file, the exchange file, host IP address, exchange operator, job type, maximum failed lines threshold, user, and timezone. It allocates the next job number from the ICX_POR_BATCH_JOBS_S sequence and returns that number to the caller.
• UPDATE_JOB_STATUS — Updates the job record with a new status and cumulative counters for loaded and failed items, prices, and headers. It conditionally stamps the start datetime when the status transitions to RUNNING. This procedure was modified to add header-level counters alongside the existing item and price counters.
• DELETE_JOB — Removes a job record, typically used for cleanup of stale or abandoned validation runs.
• SET_DEBUG_CHANNEL — Configures the debug output channel used by the package's instrumentation.
• INIT_FND_DEBUG — Initializes Oracle Application Object Library (FND) debug logging for the session.
• LOG — Writes diagnostic messages, appending into the internal error buffer capped at 1000 characters.

Tables Accessed

The package reads and writes the following tables via APPS synonyms:

• ICX_POR_BATCH_JOBS — The primary job tracking table; CREATE_JOB inserts here and UPDATE_JOB_STATUS updates status and counter columns.
• ICX_POR_BATCH_JOBS_S — The sequence source supplying job numbers via .NEXTVAL.
• ICX_POR_FAILED_LINES — Stores individual lines that failed validation, supporting the maximum failed lines threshold logic.
• ICX_POR_FAILED_LINE_MESSAGES — Holds error messages associated with each failed line for downstream reporting.

Usage Notes

Because no other documented packages reference this package in the ETRM index, it is most likely invoked directly by concurrent programs and internal catalog processing routines rather than by a broad API chain. Typical invocation paths include the supplier catalog upload concurrent program, which calls CREATE_JOB to register a job before processing begins, periodically calls UPDATE_JOB_STATUS as files are parsed, and relies on the failed-line tables to surface validation feedback. The Debug procedure and its 1000-character buffer support troubleshooting in development and test environments. Customizations should not bind directly to this package; instead, integrators should call the supported catalog loading concurrent programs, which manage job creation and status updates internally on the caller's behalf.