Search Results duplicate_in_r12

Overview

The ICX.POR_FAVORITE_LIST_LINES table is an Oracle iProcurement (ICX) transactional table that stores the individual items added to a user's or organization's favorite lists. Favorite lists function as reusable, pre-populated shopping carts in iProcurement, allowing requesters to quickly re-add frequently ordered items to a requisition without re-entering item, supplier, pricing, and category details. Each row in this table represents a single line entry within a favorite list, as distinguished from the parent favorite list header.

The object resides in the ICX schema and is marked VALID in the referenced releases (12.1.1 and 12.2.2). The heuristic Data Vault classification mined from its foreign-key structure is standalone. Under this modeling lens, the table behaves as a satellite-like structure capturing descriptive, largely non-repeating attributes about a favorite list line, anchored to its parent favorite list. Because most foreign keys point outward to shared reference and master tables (item, manufacturer, line type, ASL) rather than forming a chained dependency network, the standalone classification is a reasonable suggestion rather than a strict declaration. The primary key is POR_FAVORITE_LIST_LINES_PK1, defined on FAVORITE_LIST_LINE_ID, with a corresponding unique index POR_FAVORITE_LIST_LINES_U1 on the same column.

Key Information Stored

The documented physical schema contains 66 columns. The most operationally significant are summarized below.

• FAVORITE_LIST_LINE_ID — Surrogate primary key (POR_FAVORITE_LIST_LINES_PK1 / POR_FAVORITE_LIST_LINES_U1), uniquely identifying each favorite list line.
• FAVORITE_LIST_ID — Foreign reference to the parent favorite list header; the principal join path to the list container.
• ITEM_ID, ITEM_DESCRIPTION, ITEM_REVISION, ITEM_TYPE — Core item identity and descriptive attributes carried onto the line.
• LINE_TYPE_ID — References PO_LINE_TYPES_B; governs the purchasing line type applied to the requisition line.
• CATEGORY_ID, CATEGORY, RT_ITEM_ID, RT_CATEGORY_ID — Purchasing category and, where applicable, the "real-time" item/category identifiers used by iProcurement search.
• UNIT_PRICE, CURRENCY, PRICE_LIST_ID, RATE_TYPE, RATE, RATE_DATE — Pricing and currency conversion context so the line repopulates with the correct cost.
• SUGGESTED_VENDOR_ID, SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_SITE_ID, ASL_ID — Supplier sourcing information, including linkage to the approved supplier list (PO_APPROVED_SUPPLIER_LIST).
• MANUFACTURER_ID, MANUFACTURER_NAME, MANUFACTURER_PART_NUMBER — Manufacturer and part-number detail referencing MTL_MANUFACTURERS.
• SUPPLIER_ITEM_NUM, SUPPLIER_URL — Supplier catalog and reference information.
• TEMPLATE_NAME, TEMPLATE_LINE_NUM, NONCAT_TEMPLATE_ID — Describes whether the line originated from a template, particularly for non-catalog requests.
• RT_ITEM_ID — Foreign key to ICX_POR_ITEMS, tying the line to iProcurement's item search representation.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1...ATTRIBUTE15 — Standard EBS extensibility (DDF) columns for customer-defined fields.
• Standard WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Reporting and administration frequently need to enumerate the contents of favorite lists for a user, validate pricing or supplier data, or purge stale entries. A basic query joining lines to their parent header and to the item master is common:

• List all lines for a given favorite list: SELECT * FROM icx.por_favorite_list_lines WHERE favorite_list_id = :list_id;
• Retrieve line-level pricing and supplier context: join SUPPLIER_ITEM_NUM, UNIT_PRICE, and CURRENCY to build catalog-style reports.
• Identify lines sourced from templates (TEMPLATE_NAME IS NOT NULL) versus catalog items, useful for non-catalog spend analysis.
• Audit ASL alignment: compare ASL_ID against PO_APPROVED_SUPPLIER_LIST to detect lines whose approved supplier has become inactive.
• Extract customer-defined data via ATTRIBUTE_CATEGORY plus ATTRIBUTE1–15 for downstream analytics.
• Track the DUPLICATE_IN_R12 and NEW_SUPPLIER flags where migration or data-cleanup activities are performed.

Related Objects

The table participates in several documented foreign-key relationships and depends on associated master and reference tables:

• POR_FAVORITE_LIST_LINES.LINE_TYPE_ID → PO_LINE_TYPES_B — Determines the purchasing line type (e.g., goods, services) applied to the line.
• POR_FAVORITE_LIST_LINES.MANUFACTURER_ID → MTL_MANUFACTURERS — Links the line to manufacturer master data.
• POR_FAVORITE_LIST_LINES.RT_ITEM_ID → ICX_POR_ITEMS — Connects to iProcurement's item search structure.
• POR_FAVORITE_LIST_LINES.ASL_ID → PO_APPROVED_SUPPLIER_LIST — Associates the line with an approved supplier list entry.
• Parent favorite list header (FAVORITE_LIST_ID) — The header table that groups these lines; it is the logical parent for list retrieval.
• MTL_SYSTEM_ITEMS_B (via ITEM_ID) and MTL_CATEGORIES_B (via CATEGORY_ID) — Standard item and category master references used to resolve ITEM_DESCRIPTION and CATEGORY.

Because the table is transactional within iProcurement, its primary consumers are the iProcurement shopping and favorite-list UI pages and the requisition creation logic that copies favorite-list lines into POR_REQUISITION_LINES_ALL when a requester checks out.