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.
- CART_ID — the surrogate primary key, enforced by ICX_SHOPPING_CARTS_PK and also covered by the unique index ICX_SHOPPING_CARTS_U1. This is the primary business-key candidate and the join column for all dependent tables.
- SHOPPER_ID — identifies the user who created the shopping cart.
- SAVED_FLAG and EMERGENCY_FLAG — status indicators distinguishing saved (unsubmitted) carts and emergency requisitions.
- APPROVER_ID, APPROVER_NAME, and NOTE_TO_APPROVER — approver routing and annotation data captured at header level.
- HEADER_DESCRIPTION and NOTE_TO_BUYER — free-text fields for buyer and approver communication.
- DESTINATION_TYPE_CODE, DESTINATION_ORGANIZATION_ID, DELIVER_TO_LOCATION_ID, and DELIVER_TO_REQUESTOR_ID — delivery and destination configuration, with DELIVER_TO_LOCATION_ID forming the foreign key to HR_LOCATIONS_ALL.
- NEED_BY_DATE — the requested receipt date for the requisition.
- ORG_ID — the operating unit, essential for multi-org security and reporting.
- HEADER_ATTRIBUTE_CATEGORY and HEADER_ATTRIBUTE1 through HEADER_ATTRIBUTE15 — the descriptive flexfield segments for capturing client-specific header attributes.
- REQ_NUMBER_SEGMENT1 and RESERVED_PO_NUM — requisition numbering and reserved purchase order number references.
- Standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) support audit tracking and concurrency control.
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.
-
Web Requisitions headers table
-
Web Requisitions headers table
-
View: ICX_SHOPPING_CARTS_V 12.1.1
Web Requisitions Header View
APPS.ICX_SHOPPING_CARTS_V·↳ ICX_CART_DISTRIBUTIONS·↳ ICX_SHOPPING_CARTS·Explore ICX module →
-
View: ICX_SHOPPING_CARTS_V 12.2.2
Web Requisitions Header View
APPS.ICX_SHOPPING_CARTS_V·↳ ICX_CART_DISTRIBUTIONS·↳ ICX_SHOPPING_CARTS·Explore ICX module →
-
TABLE: POA.POA_DBI_REQ_F 12.1.1
-
eTRM - ICX Tables and Views 12.2.2
-
eTRM - ICX Tables and Views 12.1.1