Search Results bill

The CRP_BILLS_OF_RESOURCES table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical data structure within the Capacity Requirements Planning (CRP) module. This table stores bill of resources (BOR) information, which defines the resources required to manufacture a specific item or assembly. The BOR serves as a foundational element for capacity planning, enabling organizations to estimate resource utilization, identify bottlenecks, and optimize production scheduling. Below is a detailed breakdown of its structure, functionality, and integration within Oracle EBS.

Table Structure and Key Columns

The CRP_BILLS_OF_RESOURCES table contains columns that capture essential BOR data, including:

ASSEMBLY_ITEM_ID: References the inventory item (from MTL_SYSTEM_ITEMS_B) for which the BOR is defined.
ORGANIZATION_ID: Identifies the inventory organization where the BOR is applicable.
RESOURCE_ID: Links to the resource (from BOM_RESOURCES) required for production.
USAGE_RATE_OR_AMOUNT: Specifies the quantity of the resource consumed per unit of the assembly.
ACTIVITY_ID: Associates the resource with a specific manufacturing activity (if applicable).
LAST_UPDATE_DATE and LAST_UPDATED_BY: Audit columns tracking record modifications.

Functional Role in Capacity Planning

The table supports the following key processes:

Resource Requirement Calculation: CRP uses BOR data to compute total resource demand based on production schedules (MRP_RECOMMENDATIONS or MPS_SCHEDULES).
Capacity Analysis: By comparing BOR-derived demand with available capacity (CRP_RESOURCE_AVAILABILITY), the system identifies overloads or underutilization.
What-If Scenarios: Enables simulation of alternative production plans by adjusting BOR parameters (e.g., resource substitution).

Integration with Other Modules

The CRP_BILLS_OF_RESOURCES table interacts with:

Bills of Material (BOM): BORs often mirror BOM structures but focus on resources rather than components.
Master Production Scheduling (MPS): MPS outputs feed into CRP to drive BOR-based capacity checks.
Shop Floor Management (WIP): Actual resource usage from WIP may trigger BOR updates for accuracy.

Technical Considerations

Indexing: Key columns like ASSEMBLY_ITEM_ID and ORGANIZATION_ID are typically indexed for performance.
Partitioning: In high-volume environments, the table may be partitioned by ORGANIZATION_ID.
API Access: Oracle provides PL/SQL APIs (CRP_BOR_PUB) for programmatic BOR maintenance.

Customization and Extensions

Organizations may extend the table via:

Descriptive Flexfields (DFFs): Adding custom attributes (e.g., resource cost tiers).
Triggers: Implementing validation rules for BOR entries.
Views: Creating summary views for reporting (e.g., CRP_BOR_V).

Conclusion

The CRP_BILLS_OF_RESOURCES table is a cornerstone of Oracle EBS's capacity planning functionality, bridging the gap between production requirements and resource availability. Its design supports complex manufacturing environments, ensuring accurate capacity forecasts and efficient resource allocation. Proper configuration and maintenance of this table are essential for achieving optimal production planning outcomes.

Concurrent Program: CRPRRBOR 12.2.2
execution_filename: CRPRRBOR , product: CRP - Capacity , user_name: Bill of Resource Report , description: Bill of Resource Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: CRPRRBOR 12.1.1
execution_filename: CRPRRBOR , product: CRP - Capacity , user_name: Bill of Resource Report , description: Bill of Resource Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: CRPRRBOR_XML 12.2.2
product: CRP - Capacity , user_name: Bill of Resources Report (XML) , description: Bill of Resources Report , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: CRPRRBOR_XML 12.1.1
product: CRP - Capacity , user_name: Bill of Resources Report (XML) , description: Bill of Resources Report , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: CYCROL 12.1.1
execution_filename: CYCROL , product: CRP - Capacity , user_name: CYCROL , description: CRP Resource Rollup , argument_method: Database fetch , enabled: Yes , execution_method: Spawned ,
Concurrent Program: CYCROL 12.2.2
execution_filename: CYCROL , product: CRP - Capacity , user_name: CYCROL , description: CRP Resource Rollup , argument_method: Database fetch , enabled: Yes , execution_method: Spawned ,
Concurrent Program: CRPPSPRS 12.2.2
execution_filename: CRPPSPRS , product: CRP - Capacity , user_name: CRPPSPRS , description: CRP Purge Resource Scenarios , argument_method: Standard , enabled: Yes , execution_method: SQL*Plus ,
Concurrent Program: CRPPSPRS 12.1.1
execution_filename: CRPPSPRS , product: CRP - Capacity , user_name: CRPPSPRS , description: CRP Purge Resource Scenarios , argument_method: Standard , enabled: Yes , execution_method: SQL*Plus ,
Table: CRP_BILLS_OF_RESOURCES 12.1.1
owner:CRP, object_type:TABLE, fnd_design_data:CRP.CRP_BILLS_OF_RESOURCES, object_name:CRP_BILLS_OF_RESOURCES, status:VALID, product: CRP - Capacity , description: Bill of resource sets , implementation_dba_data: CRP.CRP_BILLS_OF_RESOURCES ,
Table: CRP_BILLS_OF_RESOURCES 12.2.2
owner:CRP, object_type:TABLE, fnd_design_data:CRP.CRP_BILLS_OF_RESOURCES, object_name:CRP_BILLS_OF_RESOURCES, status:VALID, product: CRP - Capacity , description: Bill of resource sets , implementation_dba_data: CRP.CRP_BILLS_OF_RESOURCES ,
Table: CRP_BILL_OF_RESOURCE_ITEMS 12.1.1
owner:CRP, object_type:TABLE, fnd_design_data:CRP.CRP_BILL_OF_RESOURCE_ITEMS, object_name:CRP_BILL_OF_RESOURCE_ITEMS, status:VALID, product: CRP - Capacity , description: Items in a bill of resource set , implementation_dba_data: CRP.CRP_BILL_OF_RESOURCE_ITEMS ,
Table: CRP_BILL_OF_RESOURCE_ITEMS 12.2.2
owner:CRP, object_type:TABLE, fnd_design_data:CRP.CRP_BILL_OF_RESOURCE_ITEMS, object_name:CRP_BILL_OF_RESOURCE_ITEMS, status:VALID, product: CRP - Capacity , description: Items in a bill of resource set , implementation_dba_data: CRP.CRP_BILL_OF_RESOURCE_ITEMS ,
View: CRP_BILL_OF_RESOURCE_ITEMS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CRP.CRP_BILL_OF_RESOURCE_ITEMS_V, object_name:CRP_BILL_OF_RESOURCE_ITEMS_V, status:VALID, product: CRP - Capacity , description: Items in bill of resource view , implementation_dba_data: APPS.CRP_BILL_OF_RESOURCE_ITEMS_V ,
View: CRP_BILL_OF_RESOURCE_ITEMS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CRP.CRP_BILL_OF_RESOURCE_ITEMS_V, object_name:CRP_BILL_OF_RESOURCE_ITEMS_V, status:VALID, product: CRP - Capacity , description: Items in bill of resource view , implementation_dba_data: APPS.CRP_BILL_OF_RESOURCE_ITEMS_V ,