Results for “emergency_flag”

24 results




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

Overview

ICX_SHOPPING_CARTS is the web requisitions header table within the ICX schema, owned by the Oracle iProcurement product module. In Oracle E-Business Suite 12.1.1 and 12.2.2, it serves as the central staging and persistence structure for requisition headers created through the iProcurement self-service interface. When a shopper assembles items in a web shopping cart and submits or saves the cart, the header-level information — including shopper identity, approver details, delivery destinations, and header descriptive flexfield values — is written to this table. The table therefore acts as the interim container that precedes conversion into the Purchasing module's requisition tables (PO_REQUISITION_HEADERS_ALL and PO_REQUISITION_LINES_ALL).

From a Data Vault modeling perspective, the mined foreign-key structure classifies ICX_SHOPPING_CARTS as hub-leaning. The table is referenced by multiple dependent tables — ICX_CART_DISTRIBUTIONS, ICX_REQ_CART_ERRORS, and ICX_SHOPPING_CART_LINES — while it carries a single outgoing reference to HR_LOCATIONS_ALL via DELIVER_TO_LOCATION_ID. This pattern suggests treating CART_ID as a durable business entity key and the descriptive columns as attributes that may be modeled as a satellite around that hub.

Key Information Stored

The table contains 40 documented columns. The most significant are summarized below.

Common Use Cases and Queries

Common scenarios include reporting on open or saved shopping carts, monitoring emergency requisitions, and reconciling iProcurement submissions with downstream Purchasing records. A representative query to list carts for an operating unit with delivery details is:

  • SELECT c.cart_id, c.shopper_id, c.saved_flag, c.need_by_date, l.location_code FROM icx.icx_shopping_carts c, hr.hr_locations_all l WHERE c.deliver_to_location_id = l.location_id AND c.org_id = :org_id;
  • Aggregating line counts per cart: join ICX_SHOPPING_CART_LINES on CART_ID and apply GROUP BY CART_ID.
  • Detecting submission failures: joining ICX_REQ_CART_ERRORS on CART_ID to surface error rows for carts that failed conversion into Purchasing requisitions.
  • Analysis of saved (unsubmitted) carts: filter on SAVED_FLAG and SHOPPER_ID to identify stalled requisition drafts.

Related Objects

  • ICX_SHOPPING_CART_LINES — join on CART_ID; holds the line-level items belonging to each cart header.
  • ICX_CART_DISTRIBUTIONS — join on CART_ID; stores charge account and distribution splits for cart lines.
  • ICX_REQ_CART_ERRORS — join on CART_ID; captures errors encountered when a cart is converted to a requisition.
  • HR_LOCATIONS_ALL — referenced by DELIVER_TO_LOCATION_ID; supplies deliver-to location details.
  • PO_REQUISITION_HEADERS_ALL — downstream requisition header, populated when the cart is successfully submitted.
  • PO_REQUISITION_LINES_ALL — downstream requisition lines corresponding to the cart's line items.
  • ICX_SHOPPING_CARTS_PK / ICX_SHOPPING_CARTS_U1 — the primary-key constraint and unique index on CART_ID that guarantee header uniqueness.