Search Results update_job_status




Overview
Explore in AI Chat

Overview

ICX_POR_JOB_TRACK_VALIDATION_S is a server-side PL/SQL package owned by the APPS schema and declared with AUTHID CURRENT_USER. It forms part of the Oracle iProcurement / Internet Procurement supplier catalog upload pipeline, specifically the job tracking and validation layer that governs the processing of supplier punchout and catalog exchange files. The package coordinates the lifecycle of a batch job: it creates jobs, dequeues the next job for processing, validates individual supplier item and price records, records validation failures, and then marks a job complete or failed. In practical terms, it is the control component responsible for determining whether a catalog load job has run successfully.

Because each job moves through an explicit status model, this package is the authoritative source for answering the question "did this job run successfully or not?" Job outcomes are persisted in the ICX_POR_BATCH_JOBS tables and can be inspected through job status values or the failed-line message records produced during validation.

Key Procedures and Functions

  • UPDATE_JOB_STATUS — Updates the status of an existing job, recording counts of loaded and failed items. This is the primary mechanism through which a running job reports incremental progress and is the key entry point for tracking job success or failure.
  • COMPLETE_JOB — Marks a job as successfully finished after all items have been processed.
  • FAIL_JOB — Terminates a job in an error state and records the associated error message.
  • VALIDATE_ITEM_PRICE — A function that validates an individual supplier item and price record against supplier, item, UOM, currency, and business-group attributes, returning a validation result. It is invoked per line during processing.
  • INSERTERROR — Inserts an error record describing a failed line, capturing the descriptor key, message name, and source line number.
  • GET_NEXT_JOB — Dequeues the next available job for processing, returning job identifiers, exchange file details, supplier information, and operator context.
  • CREATE_JOB — Creates a new job record for a supplier file and exchange file, returning the new job number.

Tables Accessed

  • ICX_POR_BATCH_JOBS — The principal job header table holding job status, supplier, and file information; read and updated by the job-tracking procedures.
  • ICX_POR_BATCH_JOBS_S — A supporting job table holding supplementary job state used during creation and status transitions.
  • ICX_POR_FAILED_LINE_MESSAGES — Stores per-line validation failures written by INSERTERROR and FAIL_JOB.
  • ICX_POR_ITEMS — Holds the catalog item and pricing content being validated by VALIDATE_ITEM_PRICE.
  • FND_CURRENCIES — Provides currency validation for item price records.
  • HR_ALL_ORGANIZATION_UNITS — Supplies business-group / organization context used during validation.

Usage Notes

The package is not typically invoked directly by end users. It is called by the iProcurement catalog upload concurrent programs and by the supplier exchange/XML processing engine that drives batch jobs. It may also be invoked from custom PL/SQL that submits or monitors catalog load jobs.

To determine whether a job ran successfully, query ICX_POR_BATCH_JOBS for the job status and loaded/failed item counts after COMPLETE_JOB or FAIL_JOB has executed. A job completed via COMPLETE_JOB indicates success; a job terminated via FAIL_JOB indicates failure, and the corresponding rows in ICX_POR_FAILED_LINE_MESSAGES provide the specific validation errors. Referenced by zero other packages, this package sits at the top of the catalog upload call stack and relies on the ICX_POR_* tables for all persistent job state.