Resource Availability Not Displayed on Resource Workbench When Department Resource Capacity Unit is Zero

(Doc ID 2172214.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Work in Process - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

WIP scheduling is not honoring resource availability as defined through Department-Resource Shift Capacity Changes.
With both forward and backward scheduling (both within a resource available week and across a resource un-available week), the 11i instance schedules correctly and displays resource availability correctly on the Resource Workbench.
The R12 instance does not recognize any resource requirements nor does it display any resource availability on the Resource Workbench.


EXPECTED BEHAVIOR

WIP should schedule based on Department-Resource Shift Resource Changes. The Resource Workbench should provide details of current resource availability.


STEPS

The issue can be reproduced at will with the following example:
1. Responsibility: Work In Process.

2. Go to Resource form.
  Resource = 04SW-RES
  Type = Machine
  Charge Type = WIP Move

3. Go to Departments form
  Department = 4710
  Resource = 04SW-RES
  Shifts (shift num = 24)

4. Go to Capacity Changes
  The last 2 entries added to 11i test instance to provide future date comparison with R12 instance.

5. Go to Routings form
  Item = 04010100
  Department = 4710
  Operations Effective Date = 10/27/2010
  Operations WIP: Count Point, Autocharge, Backflush (all checked)
 
6. Go to Operation Resources form
  Item = 04010100
  2 resource:
  Resource 1 = 04SW-RES
  Resource 2 = LABOR-RES

7. Create WIP job 800889 or 40,000 FT of product 04010100.
  Based on above setups, production should consume 12 Hours 05 Minutes.
  This consumption can only occur between 05/23/2016 at 00:00:00 and 05/27/2016 at 23:59:00 or between 06/06/2016 at 00:00:00 and 06/10/2016 at 23:59:00.

8. Enter Assembly, Status, Start Quantity = 40000 and Start Date = 05/23/2016 00:00:00

9. Forward scheduling is correct within first week of added capacity. Change Completion Date to 05/27/2016 23:59:00:

10. Backward scheduling is correct within first week of added capacity. Change Start Date to 05/27/2016 20:00:00:

11. Forward scheduling is correct crossing over from first week of added capacity into second week of added capacity. Change Completion Date to 06/06/2016 04:00:00:

12. Backward scheduling is correct crossing over from second week of added capacity into first week of added capacity.

13. Look at 11i Resource Workbench
  WIP job 800889 resource 04SW-RES
  Resource utilization is correct based on last schedule for WIP job 800889

14. Now move to R12.2.5 instance as upgraded from the 11.5.10.2 used in the test sequence above.

15. Department 4710 Resource 04SW-RES Capacity Changes
  The last 2 entries added to R12 test instance to provide future date comparison with 11i instance.

16. Create WIP job 837408 for 40,000 FT of product 04010100. Based on setups carried over from upgraded 11i instance, production should consume 12 Hours 05 Minutes.
  This consumption can only occur between 05/23/2016 at 00:00:00 and 05/27/2016 at 23:59:00 or between 06/06/2016 at 00:00:00 and 06/10/2016 at 23:59:00.

17. Forward scheduling fails within first week of added capacity. Change Completion Date to 05/27/2016 23:59:00:

18. Backward scheduling fails within first week of added capacity. Change Start Date to 05/27/2016 20:00:00:

19. Forward scheduling fails crossing over from first week of added capacity into second week of added capacity. Change Completion Date to 06/06/2016 04:00:00:

20. Backward scheduling fails crossing over from second week of added capacity into first week of added capacity.

21. Look at R12 Resource Workbench
  Resource utilization fails based because last schedule for WIP job 800889 fails.

Cause

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 hundreds of Community platforms