My Oracle Support Banner

ASCP Workbench Gantt Chart Does Not Show Resource Hours Nor Resource Units (Doc ID 2339901.1)

Last updated on DECEMBER 15, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, User Interface in Test:

Users are on 12.2.6 and have applied patch 25920948 12.2.6.2 - Mandatory patch for R12.SCP_PF.C.Delta.7 - 3. Users are running an EDD Classic Constrained plan 550 days/12 weeks/12 periods and scheduling with 0 days in minutes, 365 days in hours, and 185 in days buckets - They query resource requirements in the ASCP workbench for
Dept = CS-01
Resource = COQUT-UBMO

They can see Available Capacity, Required Capacity, Net Capacity and Capacity Load Ration in the horizontal plan - they select the Gantt Chart and they can see data in the View = Resource - Activities - They see nothing in the View = Resource - Hours - They also see nothing in View = Resource - Units

This sql is not fetching any rows

SQL ID: 775dpcjarxrhw Plan Hash: 0

INSERT INTO MSC_GANTT_DTL_QUERY ( QUERY_ID, ROW_TYPE, ROW_INDEX, PARENT_ID,
 LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
 LAST_UPDATE_LOGIN, START_DATE, END_DATE, RESOURCE_UNITS, RESOURCE_HOURS,
 SCHEDULE_FLAG, DISPLAY_FLAG)
VALUES
( :B10 , :B9 , :B8 , :B7 , SYSDATE, -1, SYSDATE, -1,-1, :B6 , :B5 , :B4 ,
 :B3 , :B2 , :B1 )


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 803 0.15 0.15 0 12 2511 803
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 804 0.15 0.15 0 12 2511 803

EXPECTED BEHAVIOR
-----------------------
Expect to see in the Gantt Chart Resource-Hours and Resource-Units

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ECC Classic Constrained Plan
2. Review resource requirements in main ASCP workbench
3. Select Gantt Chart and there's no resource-hours nor resource-units displayed

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.