Enhancement - Increase Size of Task Work Interval Business Days to 3 Digits (Doc ID 2017153.1)

Last updated on MAY 04, 2021

Applies to:

Goal

REQUIREMENT

User wants increased the size of MSS Task's Work Interval Bus Day Limits (Duration days) to support 3 digits.
 
 Window: w_prov_plan_maint

BUSINESS JUSTIFICATION

 Users need to set the Work Interval Bus Day for a task to 103 days, however
 the GUI will only allow to enter two digits which would be a max to 99.

The Work Interval Bus Days is stored in table ASAP.PROVISIONING_PLAN_TASK,
column COMPLETION_DAYS that is a variable type NUMBER(2,0)  so, the maximum is 99.
There is no Preference to change this parameter.

Solution

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