Search Results icx_por_upload_items_it

Overview

The ICX_POR_UPLOAD_ITEMS_IT table is a transient data structure within the Oracle iProcurement (ICX) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Its primary role is to serve as a temporary staging area during the bulk load process for catalog items. As a transient table, it is designed to hold data only for the duration of a specific bulk load job. Following the completion of each job, the table is truncated, ensuring it does not retain historical data and is ready for subsequent load operations. This design is critical for managing the performance and data integrity of high-volume item uploads into the iProcurement catalog.

Key Information Stored

The table's structure is centered around tracking individual line items within a bulk upload job. The primary key is a composite of JOB_NUMBER and LINE_NUMBER, which uniquely identifies each record. The JOB_NUMBER column links the item line to a specific bulk load job managed in the related ICX_POR_BATCH_JOBS table. The LINE_NUMBER provides sequential ordering for items within that job. While the provided metadata does not list all columns, typical data stored would include the item details being uploaded, such as item number, description, category, supplier information, unit price, and any processing status or error codes generated during the validation and import phases of the bulk load.

Common Use Cases and Queries

The primary use case is the backend processing of the "Bulk Load Items" or "Catalog Upload" functionality in iProcurement. Administrators use this to add or update large numbers of catalog items from a spreadsheet or data file. Common queries against this table are typically operational and diagnostic, executed during or immediately after a load job. For example, to monitor the progress of a specific job (e.g., JOB_NUMBER = 1001), one might query: SELECT LINE_NUMBER, ITEM_NUMBER, STATUS, ERROR_MESSAGE FROM ICX_POR_UPLOAD_ITEMS_IT WHERE JOB_NUMBER = 1001 ORDER BY LINE_NUMBER;. This helps identify lines that failed validation. Reporting use cases are limited due to the table's transient nature; persistent data is moved to core inventory and purchasing tables upon successful completion.

Related Objects

The table has a direct and documented foreign key relationship, which is fundamental to its operation. It references the ICX_POR_BATCH_JOBS table via the JOB_NUMBER column. The ICX_POR_BATCH_JOBS table acts as the control table for bulk upload processes, storing high-level job information such as the submitter, submission date, and overall job status. Therefore, a complete view of a bulk load operation requires joining these two tables: SELECT b.JOB_NUMBER, b.STATUS as JOB_STATUS, i.LINE_NUMBER, i.ITEM_NUMBER FROM ICX_POR_BATCH_JOBS b, ICX_POR_UPLOAD_ITEMS_IT i WHERE b.JOB_NUMBER = i.JOB_NUMBER;. No other foreign key relationships are documented in the provided metadata.