Results for “okc_user_bins”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKC_USER_BINS is a denormalized table in the OKC (Contracts Core) schema of Oracle E-Business Suite, present in releases 12.1.1 and 12.2.2. Its documented purpose is to maintain various lists of contracts for user portals. In practical terms, the table functions as a materialized working set: business users and portal pages frequently need to retrieve filtered, pre-qualified lists of contracts — for example, contracts belonging to a particular type, program, or contract number pattern — without repeatedly executing expensive joins against the full contract header tables. OKC_USER_BINS satisfies this requirement by storing a curated, denormalized projection of contract attributes keyed to a specific contract and security context.
Because the table carries a foreign key to OKC_K_HEADERS_B on CONTRACT_ID, it does not own the contract entity itself; it describes and categorizes contracts owned by the header table. Under the heuristic Data Vault classification documented in the ETRM metadata, this object is satellite-leaning, meaning it is best modeled as a satellite that stores descriptive, query-oriented attributes about a parent business key (the contract) rather than as a hub or link. This classification is a modeling suggestion derived from the foreign-key topology, not a physical constraint of the EBS schema.
Key Information Stored
The table contains eleven documented columns. The most significant are:
- ID — The surrogate primary key, enforced by OKC_USER_BINS_PK and also backed by the unique index OKC_USER_BINS_U1. This is the technical identifier of the bin entry, not of the contract.
- CONTRACT_ID — Foreign key to OKC_K_HEADERS_B. This is the true business key candidate linking a bin row back to the contract header it represents.
- CONTRACT_NUMBER — The human-readable contract number, denormalized to avoid a join when displaying contract lists.
- CONTRACT_NUMBER_MODIFIER — The modifier component of the contract number, preserved alongside the base number for accurate rendering.
- BIN_TYPE — Categorizes the bin, effectively defining which list or portal grouping the row belongs to.
- CONTRACT_TYPE — The contract type classification used for filtering and display.
- PROGRAM_NAME — Identifies the program or grouping context associated with the bin entry, typically used by portal programs that populate or consume the bins.
- SHORT_DESCRIPTION — A truncated descriptive text for the contract, supporting list-style display.
- SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing Multi-Org / data-security partitioning so that a user sees only bins within permitted security groups.
- CREATED_BY / CREATION_DATE — Standard EBS audit columns recording who populated the bin row and when.
The distinction between ID and CONTRACT_ID is important: ID uniquely identifies a bin row, while CONTRACT_ID is the meaningful business reference and may legitimately appear in more than one bin.
Common Use Cases and Queries
Typical usage centers on portal and list-of-values queries that must return contracts quickly. A common pattern retrieves all contracts of a given bin type for the current user's security group:
SELECT contract_id, contract_number, contract_type, short_description FROM okc_user_bins WHERE bin_type = :p_bin_type AND security_group_id = :p_sec_group ORDER BY contract_number;- Joining back to the header for authoritative detail:
SELECT b.contract_number, h.* FROM okc_user_bins b, okc_k_headers_b h WHERE b.contract_id = h.id AND b.bin_type = :p_bin_type; - Detecting stale or orphaned bin entries that no longer match a live header, useful when reconciling portal lists.
- Reporting by PROGRAM_NAME to determine which concurrent program or portal process populated a given set of bins and when, using CREATED_BY and CREATION_DATE.
Because the table is denormalized, reporting queries should treat it as a cache rather than a system of record; contract attributes must be validated against OKC_K_HEADERS_B when accuracy is critical.
Related Objects
- OKC_K_HEADERS_B — The primary parent table; joined on OKC_USER_BINS.CONTRACT_ID = OKC_K_HEADERS_B.ID. All contract detail and versioning resides here.
- OKC_K_HEADERS_TL — Holds translated header text and is commonly joined with the header for descriptions.
- FND_SECURITY_GROUPS — Referenced on SECURITY_GROUP_ID; governs data-security partitioning of bin rows.
- OKC_K_LINES_B — Contract lines; the header referenced by CONTRACT_ID parents the line records.
- OKC_K_ITEMS — Contract line items, reached through OKC_K_LINES_B for item-level reporting.
- OKC_USER_BINS_PK / OKC_USER_BINS_U1 — The primary-key constraint and unique index that enforce row identity on ID.
- OKC Contracts Core APIs — Public contract APIs such as OKC_CONTRACT_PUB and related concurrent programs operate against OKC_K_HEADERS_B and may repopulate the bins indirectly.
-
Denormalized entity used to maintain various lists of contracts for user portals.
-
Denormalized entity used to maintain various lists of contracts for user portals.
-
SYNONYM: APPS.OKC_USER_BINS 12.2.2
-
TABLE: OKC.OKC_USER_BINS 12.2.2
-
SYNONYM: APPS.OKC_USER_BINS 12.1.1
-
TABLE: OKC.OKC_USER_BINS 12.1.1
-
View: OKC_USER_BINS_V 12.1.1
View for Table OKC_USER_BINS
APPS.OKC_USER_BINS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ OKC_K_HEADERS_B·↳ OKC_K_HEADERS_TL·Explore OKC module →
-
VIEW: OKC.OKC_USER_BINS# 12.2.2
-
View: OKC_USER_BINS_V 12.2.2
View for Table OKC_USER_BINS
APPS.OKC_USER_BINS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ OKC_K_HEADERS_B·↳ OKC_K_HEADERS_TL·Explore OKC module →
-
VIEW: APPS.OKC_USER_BINS_V 12.2.2
-
VIEW: OKC.OKC_USER_BINS# 12.2.2
-
VIEW: APPS.OKC_USER_BINS_V 12.1.1
-
VIEW: APPS.OKC_USER_BINS_V 12.1.1
-
VIEW: APPS.OKC_USER_BINS_V 12.2.2
-
Table: OKC_K_HEADERS_B 12.1.1
Stores header level attributes of a Contract. It groups all the lines and terms and conditions of a contract.
Not implemented in this database·Explore OKC module →
-
Table: OKC_K_HEADERS_B 12.2.2
Stores header level attributes of a Contract. It groups all the lines and terms and conditions of a contract.
Not implemented in this database·Explore OKC module →
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1