Skip to the content.

CRP Resource Plan – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Capacity · all Capacity reports

Overview

Detail report for each resource code, showing the resource date, hours, work start and end date, type of work scheduled, and the quantity scheduled.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Organization Code, Plan, Department, Resource Code, Resource Description, Sales Order, Planner, Job, Assembly, Component, Show Active only, Expand Lot Time, Show Components

Oracle EBS Tables Used

dual, crp_resource_plan, bom_departments, bom_resources, mtl_parameters, mtl_system_items_vl, mrp_recommendations, wip_entities, wip_discrete_jobs, wip_schedule_groups, mrp_full_pegging, mrp_gross_requirements, oe_order_lines_all, oe_order_headers_all, xxen_report_org_access, wip_operations, wip_requirement_operations, mtl_units_of_measure_tl, mtl_item_locations_kfv, mtl_onhand_quantities_detail, mtl_secondary_inventories, po_distributions_all, po_lines_all, po_line_locations_all, po_headers_all

Report Categories

Enginatics

MRP Pegging, WIP Entities, WIP Job Upload, WIP Discrete Job Shortage, CAC Manufacturing Variance, CAC WIP Resource Efficiency, CAC WIP Account Detail, CAC ICP PII WIP Material Usage Variance

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output CRP Resource Plan 03-Aug-2018 210345.xlsx
Blitz Report™ XML Import CRP_Resource_Plan.xml
SQL Source CRP Resource Plan.sql
Full Report on Enginatics www.enginatics.com/reports/crp-resource-plan/

Executive Summary

The CRP Resource Plan report is the counterpart to the “Available Resources” report. While the former shows supply (capacity), this report shows demand (load). It details the specific work scheduled for each resource, including the start/end dates, hours required, and the specific job or sales order driving the demand. This allows planners to see exactly what is consuming the shop floor’s capacity.

Business Challenge

Knowing that a machine is “busy” isn’t enough. Planners need to know what it is busy doing.

Solution

This report provides a detailed schedule of resource requirements.

Key Features:

Architecture

The report queries CRP_RESOURCE_PLAN (or MRP_GROSS_REQUIREMENTS linked to resource data) to show the load. It joins to WIP_DISCRETE_JOBS and OE_ORDER_LINES_ALL to provide the context of why the resource is needed.

Key Tables:

Impact


© Enginatics GmbH