Search Results crp_bills_of_resources




Overview
Explore in AI Chat

Overview

The CRP_BILLS_OF_RESOURCES table is a core data object within the Capacity (CRP) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as the master definition table for bill of resource sets. A bill of resources is a structured list of all the resources, such as machines, labor, or tooling, required to produce a specific item or assembly over a defined period. This table stores the header-level information for these sets, enabling the system to perform detailed capacity planning and rough-cut capacity planning (RCCP) by modeling the resource demands of production schedules against available capacity.

Key Information Stored

As a header table, CRP_BILLS_OF_RESOURCES primarily stores identifying and organizational metadata for each bill of resource set. The documented primary key consists of the BILL_OF_RESOURCES and ORGANIZATION_ID columns, ensuring uniqueness of a bill within a specific inventory organization. While the full column list is not detailed in the provided metadata, typical columns in such a master table would include a descriptive name, creation and last update dates, status flags (e.g., active, inactive), and potentially a reference to the associated assembly item or routing. The ORGANIZATION_ID is a critical column that ties the bill to a specific operating unit within the manufacturing hierarchy.

Common Use Cases and Queries

This table is central to capacity planning analyses. Planners use the data to load resource requirements from a master production schedule (MPS) or discrete jobs to generate capacity reports and identify potential bottlenecks. Common queries involve joining this header to its detail lines to summarize total resource demand. A typical reporting pattern is to list all active bills of resources within a specific organization, often for audit or setup verification purposes. For example:

  • Retrieving a list of all bill of resource headers: SELECT bill_of_resources, organization_id FROM crp_bills_of_resources WHERE organization_id = :org_id;
  • Joining to detail lines to analyze resource requirements: SELECT cbr.bill_of_resources, cbri.resource_id, cbri.usage_rate FROM crp_bills_of_resources cbr JOIN crp_bill_of_resource_items cbri ON cbr.bill_of_resources = cbri.bill_of_resources AND cbr.organization_id = cbri.organization_id;

Related Objects

The primary documented relationship for the CRP_BILLS_OF_RESOURCES table is with the CRP_BILL_OF_RESOURCE_ITEMS table, which holds the detailed resource requirements for each bill. The foreign key relationship is explicitly defined: the CRP_BILL_OF_RESOURCE_ITEMS table references CRP_BILLS_OF_RESOURCES using the composite key of BILL_OF_RESOURCES and ORGANIZATION_ID. This establishes a one-to-many relationship where one bill header can have multiple resource item lines. This structure is essential for capacity planning, as the header defines the bill set, while the child table lists the specific resources, their usage rates, and applicable dates.