Search Results cac_sr_object_capacity_u1

Overview

JTF.CAC_SR_OBJECT_CAPACITY is a valid base table in the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environments, owned by the JTF schema. Functional design data is registered under JTF.CAC_SR_OBJECT_CAPACITY. The table stores availability summary information for schedulable objects, expressed as a composite of schedules, exceptions, and tasks. In effect, it captures the computed or derived capacity — the total working hours available for a resource, group, or other schedulable entity — across a defined start and end date-time window, factoring in hours before and after the window that remain relevant to the calculation.

Within the E-Business Suite service and resource scheduling model, this table functions as a persisted availability snapshot. Each row represents one capacity record for one object over one time interval. Because the table is referenced by assignment and plan-option entities, it acts as a supply-side ledger against which demand (task assignments and plan tasks) is matched. The metadata's heuristic Data Vault classification is standalone. In Data Vault modeling terms, this suggests the table can be treated as a self-contained record rather than a link table, though in practice it behaves as a satellite-like capacity fact table keyed to a schedule detail parent.

Key Information Stored

• OBJECT_CAPACITY_ID — Surrogate primary key and unique identifier for each capacity record, underlying CAC_SR_OBJECT_CAPACITY_PK and the unique index CAC_SR_OBJECT_CAPACITY_U1.
• OBJECT_ID, START_DATE_TIME, OBJECT_TYPE — The three-column business key forming unique index CAC_SR_OBJECT_CAPACITY_U2 (CAC_SR_OBJECT_CAPACITY_U2 is the index a user would search for). OBJECT_ID identifies the resource or schedulable entity, START_DATE_TIME anchors the capacity interval, and OBJECT_TYPE classifies the entity.
• END_DATE_TIME — Closes the availability interval.
• AVAILABLE_HOURS — The net capacity within the interval.
• AVAILABLE_HOURS_BEFORE and AVAILABLE_HOURS_AFTER — Allowable capacity immediately preceding and following the interval, supporting scheduling that spans window boundaries.
• SCHEDULE_DETAIL_ID — Foreign key to CAC_SR_SCHDL_DETAILS, linking the capacity record to its governing schedule definition.
• STATUS — Numeric state indicator for the capacity row.
• AVAILABILITY_TYPE — Classifies the nature of the availability (for example, schedule-versus-exception semantics).
• SOURCE_TYPE — Identifies the shift source that generated the capacity.
• OBJECT_VERSION_NUMBER and the standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — Audit and optimistic-locking support.

Common Use Cases and Queries

The table is queried to answer capacity and utilization questions: how many hours a resource is available in a period, how capacity is distributed across object types, and how fully capacity is consumed by assignments. A typical lookup resolves a resource's usable capacity over a range:

• Filter by OBJECT_TYPE and OBJECT_ID, then constrain START_DATE_TIME and END_DATE_TIME to the reporting period.
• Aggregate AVAILABLE_HOURS by OBJECT_TYPE to summarize capacity by entity category.
• Join to JTF_TASK_ASSIGNMENTS on OBJECT_CAPACITY_ID to compare available versus consumed capacity in utilization reporting.
• Analyze AVAILABILITY_TYPE and SOURCE_TYPE to distinguish scheduled capacity from exception-driven adjustments.

Related Objects

• JTF.CAC_SR_SCHDL_DETAILS — Parent schedule detail; joined on SCHEDULE_DETAIL_ID.
• JTF.JTF_TASK_ASSIGNMENTS — References this table via OBJECT_CAPACITY_ID; used for task-to-capacity matching.
• JTF.CSF_R_PLAN_OPTION_TASKS — References this table via OBJECT_CAPACITY_ID; links planned option tasks to capacity.
• Index CAC_SR_OBJECT_CAPACITY_U2 — The unique business-key index on (OBJECT_ID, START_DATE_TIME, OBJECT_TYPE), commonly the access path for point lookups and range scans.
• Standard FND foreign keys to FND_USER.USER_ID (WHO columns) and FND_LOGINS.LOGIN_ID (LAST_UPDATE_LOGIN).