Search Results cr_rsrc_dtl
The CR_RSRC_DTL table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical repository for detailed resource information within the Costing module. This table stores granular data related to resource consumption, allocations, and costing across various business processes, particularly in manufacturing, project accounting, and inventory valuation. It serves as a foundational component for cost roll-up calculations, variance analysis, and financial reporting.
Key Attributes and Structure
The CR_RSRC_DTL table contains columns that capture transactional and master data elements, including:- RESOURCE_ID: Unique identifier linking to the BOM_RESOURCES table, defining the resource type (labor, machine, overhead, etc.).
- ORGANIZATION_ID: Maps to HR_ORGANIZATION_UNITS, associating resources with specific inventory organizations.
- COST_ELEMENT_ID: Categorizes costs into material, labor, overhead, or outside processing.
- TRANSACTION_ID: References MTL_MATERIAL_TRANSACTIONS or WIP_TRANSACTIONS for audit trails.
- ACTUAL_QUANTITY and STANDARD_QUANTITY: Track consumed vs. expected resource units.
- ACTUAL_COST and STANDARD_COST: Store monetary values for variance analysis.
- PERIOD_ID: Ties records to accounting periods in GL_PERIODS.
Functional Integration
The table integrates with multiple EBS modules:- Manufacturing (BOM/WIP): Captures resource usage in work orders, enabling job costing and production variance reporting.
- Inventory: Supports landed cost calculations and inventory valuation adjustments.
- Projects (PA): Allocates resource costs to projects via PA_EXPENDITURE_ITEMS integration.
- General Ledger: Feeds cost distributions to GL_INTERFACE for financial posting.
Technical Considerations
- Indexing: Heavily indexed on RESOURCE_ID, ORGANIZATION_ID, and PERIOD_ID for performance in cost roll-up queries.
- Partitioning: In 12.2.2, table partitioning by period improves archival and query performance.
- Purge Logic: Managed via concurrent programs like "Cost Purge" to maintain optimal size.
Business Process Impact
Data in CR_RSRC_DTL directly influences:- Cost of Goods Sold (COGS) calculations
- Production efficiency analysis through variance reports
- Project profitability tracking
- Standard cost updates via CST_STD_COSTS interface
Customization Considerations
Extensions to this table require careful analysis due to:- Triggers that enforce cost accounting rules
- Dependencies in cost processor engine (CSTPACIN.pls)
- Integration with subledger accounting (SLA) in 12.2.2
-
Table: CR_RSRC_DTL
12.1.1
owner:GMP, object_type:TABLE, fnd_design_data:GMP.CR_RSRC_DTL, object_name:CR_RSRC_DTL, status:VALID, product: GMP - Process Manufacturing Process Planning , description: Plant-specific resource information , implementation_dba_data: GMP.CR_RSRC_DTL ,
-
Table: CR_RSRC_DTL
12.2.2
owner:GMP, object_type:TABLE, fnd_design_data:GMP.CR_RSRC_DTL, object_name:CR_RSRC_DTL, status:VALID, product: GMP - Process Manufacturing Process Planning , description: Plant-specific resource information , implementation_dba_data: GMP.CR_RSRC_DTL ,
-
APPS.GMD_MBR_UTIL_PKG dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMP_WPS_WRITER dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMD_RESULTS_GRP dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMD_SS_ERES_PKG dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMP_RESOURCE_DTL_PUB dependencies on CR_RSRC_DTL
12.1.1
-
APPS.OPI_EDW_RES_UTIL_FOPM_SZ dependencies on CR_RSRC_DTL
12.1.1
-
APPS.OPI_DBI_PRE_R12_RES_PKG dependencies on CR_RSRC_DTL
12.1.1
-
APPS.MSC_CL_GMP_UTILITY dependencies on CR_RSRC_DTL
12.2.2
-
APPS.MIGRATE_BATCH dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GME_BATCHSTEP_RSRC_PVT dependencies on CR_RSRC_DTL
12.1.1
-
APPS.OPI_DBI_RES_OPM_PKG dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMO_OC_TRANS_PKG dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMD_RECIPE_FETCH_PUB dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GME_INIT_RSRC_TXNS_SUMMARY dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GMO_OC_TRANS_PKG dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GME_GANTT_LOV_PKG dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GMP_RSRC_AVL_PKG dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMP_RESOURCES_PUB dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMD_QMREJ dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GME_BATCH_STEP_CHG_PVT dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GME_MOBILE_LOVS dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMP_APS_WRITER dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMD_COMMON_VAL dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GME_GANTT_RSRC_PKG dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GMP_RESOURCES_PUB dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GME_RESOURCE_ENGINE_PVT dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GMD_COMMON_VAL dependencies on CR_RSRC_DTL
12.2.2
-
APPS.MIGRATE_BATCH dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GMP_WPS_WRITER dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GMP_RESOURCE_DTL_PUB dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GME_API_PUB dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GME_INIT_RSRC_TXNS_SUMMARY dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMD_SPEC_VRS_GRP dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMD_FETCH_OPRN dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMP_RESOURCE_DTL_PUB dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GME_API_PUB dependencies on CR_RSRC_DTL
12.1.1
-
APPS.OPI_DBI_RES_PKG dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMD_OPRN_MIGRATION dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMP_EAM_DOWNTIME_PKG dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMD_SPEC_VRS_GRP dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GME_BATCH_STEP_CHG_PVT dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GMD_FETCH_OPRN dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GME_BATCHSTEP_RSRC_PVT dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GMP_RESOURCE_DTL_PUB dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GMD_OPRN_MIGRATION dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GMP_APS_WRITER dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GMD_RECIPE_FETCH_PUB dependencies on CR_RSRC_DTL
12.2.2
-
APPS.GME_GANTT_LOV_PKG dependencies on CR_RSRC_DTL
12.1.1