Results for “icx_req_cart_errors”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ICX.ICX_REQ_CART_ERRORS is a transactional detail table within the Oracle iProcurement (ICX) module of Oracle E-Business Suite, documented as valid in both release 12.1.1 and 12.2.2. Its stated purpose is the "Web Requisitions errors table." In practical terms, it persists validation, processing, and submission errors raised against shopping cart contents created through the iProcurement self-service requisitioning flow. When a user builds a requisition in the iProcurement storefront and checkout fails—whether because of catalog item issues, sourcing rule failures, budget or account validation, or interfacing to purchasing and approval workflows—the offending condition is captured here, tied back to the specific cart, cart line, and line distribution involved.

The table therefore acts as the diagnostic bridge between a transient shopping cart and the downstream requisition entities it attempts to create. Under the heuristic Data Vault classification derived from its foreign key structure, this object is best modeled as a link: it resolves relationships among shopping carts, cart lines, and cart line distributions while also carrying descriptive error context on that association.

Key Information Stored

The table contains 10 documented columns. The composite primary key, enforced by ICX_REQ_CART_ERRORS_PK, is formed by CART_ID and ERROR_ID. A corresponding unique index, ICX_REQ_CART_ERRORS_U1, covers the same pair, confirming it as the business-key candidate for the row.

• CART_ID — Identifies the parent shopping cart, joining to ICX_SHOPPING_CARTS. Part of the primary key.
• ERROR_ID — Unique error instance identifier for the cart. Part of the primary key.
• CART_LINE_ID — References the affected line within the cart, joining to ICX_SHOPPING_CART_LINES. Narrows the error to a specific requisition line.
• DISTRIBUTION_NUM — References the line distribution, joining to ICX_CART_LINE_DISTRIBUTIONS, isolating the error to a charge account or distribution split.
• ERROR_TEXT — The human-readable message describing the validation or submission failure.
• CREATED_BY / CREATION_DATE — Standard Who columns recording row creation.
• LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — Standard Who columns recording the most recent update and session.

Common Use Cases and Queries

Support and functional teams query this table to diagnose why requisitions fail at checkout, to reconcile cart contents before retry, and to report recurring error patterns by message or catalog source.

• List errors for a specific shopping cart: SELECT * FROM icx.icx_req_cart_errors WHERE cart_id = :p_cart_id;
• Join to the cart header and line for context: SELECT c.cart_id, l.cart_line_id, e.error_text FROM icx.icx_req_cart_errors e, icx.icx_shopping_carts c, icx.icx_shopping_cart_lines l WHERE e.cart_id = c.cart_id(+) AND e.cart_line_id = l.cart_line_id(+) AND e.cart_id = :p_cart_id;
• Frequency reporting: group by ERROR_TEXT over a date range using CREATION_DATE to surface the most common failures.
• Distribution-level troubleshooting: filter on DISTRIBUTION_NUM to isolate accounting or budget-related errors.

Related Objects

• ICX_SHOPPING_CARTS — parent cart header; joined on CART_ID.
• ICX_SHOPPING_CART_LINES — cart line detail; joined on CART_LINE_ID.
• ICX_CART_LINE_DISTRIBUTIONS — line distribution detail; joined on CART_LINE_ID and DISTRIBUTION_NUM.

These associations make ICX_REQ_CART_ERRORS an essential link between the storefront cart hierarchy and the error diagnostics that gate requisition creation in Oracle iProcurement.