Search Results icx_shopping_carts




Overview
Explore in AI Chat

Overview

The ICX_SHOPPING_CARTS table is the core header table for shopping cart requisitions within Oracle iProcurement, a module of Oracle E-Business Suite (EBS). It functions as the primary repository for the header-level data of a web requisition, representing the shopping cart itself before it is converted into a formal purchase requisition in the Purchasing module. Each record in this table corresponds to a distinct shopping cart session initiated by a user. Its role is critical in the procure-to-pay process, capturing the initial request's metadata, requester information, delivery details, and overall cart status, thereby serving as the parent entity for individual cart lines stored in related tables.

Key Information Stored

The table stores essential header attributes for a shopping cart. The primary key, CART_ID, uniquely identifies each cart. Other significant columns typically include REQUESTER_ID (linking to the employee creating the cart), CREATION_DATE, and STATUS to track the cart's lifecycle (e.g., SAVED, SUBMITTED, CONVERTED). The DELIVER_TO_LOCATION_ID is a crucial foreign key to HR_LOCATIONS_ALL, specifying the delivery destination. The table also commonly holds fields for currency, total amount, descriptive information, and references to the eventual purchase requisition (REQ_HEADER_ID) once the cart is successfully processed and transferred to the Purchasing module.

Common Use Cases and Queries

This table is central for auditing, troubleshooting, and reporting on iProcurement activity. Common scenarios include tracking the volume and status of carts, identifying stalled or error-prone requisitions, and analyzing requester behavior. A typical query retrieves cart details along with requester and location information for analysis or support tickets.

  • Sample Query for Cart Analysis:
    SELECT cart.cart_id, cart.creation_date, cart.status,
    person.full_name requester, loc.location_code
    FROM icx_shopping_carts cart,
    per_all_people_f person,
    hr_locations_all loc
    WHERE cart.requester_id = person.person_id
    AND cart.deliver_to_location_id = loc.location_id
    AND cart.creation_date > SYSDATE - 30
    ORDER BY cart.creation_date DESC;
  • Use Case: Identifying carts that failed to convert to requisitions by joining with the ICX_REQ_CART_ERRORS table to diagnose system or data issues.

Related Objects

As indicated by the foreign key relationships, ICX_SHOPPING_CARTS is the central node in the iProcurement shopping cart data model. Key dependent objects include:

  • ICX_SHOPPING_CART_LINES: Stores the individual line items within a cart, linked via CART_ID.
  • ICX_CART_DISTRIBUTIONS: Holds accounting distribution details for cart lines.
  • ICX_REQ_CART_ERRORS: Captures any errors encountered during the cart-to-requisition conversion process.
  • HR_LOCATIONS_ALL: Provides the valid delivery location details via the DELIVER_TO_LOCATION_ID foreign key.
  • PO_REQUISITION_HEADERS_ALL: While not a direct foreign key in the provided metadata, a REQ_HEADER_ID column typically exists to link the converted cart to its final purchase requisition.