Global Availability Script (GAS) and 'Recreateproduct usage' changes post merging 'Transferusage' and adding ‘backorderusage’

Reference No: R2-13868, R2-13665

Version No: 06.01.01-00

Details

Global availability program is now enhanced by providing options to recreate the usage for Daily and Weekly used products instead of always recreating all products.

This way we can reduce the total elapsed time for global availability recreation.

Important Instructions

1. It is mandatory to use the new Global Availability Script (GAS) program from 06.01.01-00 as the old program will not work anymore from this version onwards.

2. Post upgrade to this version, Global Availability program should be executed once for all products before scheduling the daily or weekly options.

Change In Functionality

Global Availability Program has two sub programs

1. RECREATE

   1. Purpose

   2. Products usage like rental, transfer and backorder for the specific interval (which is set at configuration).and option is not visible.

   3. Serial Item stock update based on the Asset status.

2. Options for RECREATE of the usage of products (Items, Parts, Serial Kit).

3. All (POption=0): Recreate all products usage.

   • Daily Used (POption=1): Products used a day before and after (to consider all  region timezone usage).

   • Weekly Used (POption=2): Products used 7 days before and after a day (to consider all region timezone usage).

New Global Availability Program can be executed as shown in below example

• Recreate All Products usage

SQL> exec GlobalAvailability_pkg.recreate(0);

• Recreate Daily used Products usage

SQL> exec GlobalAvailability_pkg.recreate(1);

• Recreate Weekly used Products usage

SQL> exec GlobalAvailability_pkg.recreate(2);

2. POPULATESTATUS

3. Purpose

   1.  To know the status of RECREATE program.

1. With this change, customer who scheduled GAS (Global Avaialbility Script) maintained by CSC script should be replaced with new GlobalAvailability_pkg.

2. Not required to invoke Transfer and Serial stock (Updatestock program) scripts separately as new GlobalAvailability_pkg takes care all those.

New POPULATESTATUS Program can be executed as shown in the example: SQL> Select GlobalAvailability_pkg.PopulateStatus from dual;

Sample result of status against POPULATESTATUS with Option 0

1. Percent -->  100.00%

2. Good Count --> 105

3. Bad Count --> 0

4. Total Done --> 105

5. Total Count --> 105

6. 30Days Older --> 0

7. ETA --> 08/05/2020 08:52:16 am

8. Product Usage Recreate Started

9. Product Usage Recreate Finished

10. Serial Item Stock Recreate Started

11. Serial Item Stock Recreate Finished

Sample result of status against POPULATESTATUS with Option 1 and 2

• Product Usage Recreate Started

• Product Usage Recreate Finished

• Serial Item Stock Recreate Started

• Serial Item Stock Recreate Finished

• Percent means Percentage of Recreation completed

• Good Count means Number of products Recreation completed successfully

• Bad Count means Number of products Recreation failed

• Total Done means Number of products recreation attempted

• Total Count means Number of products considered for recreation

• 30Days Older means Number of usage entries present in database older than 30days

• ETA means expected time to complete the recreate usage

 

2. Modified RecreateProductUsage program

In addition to recreate the usage of Rental order, this program is modified to recreate the transfer and backorder usage.

Two New Parameter added, and the latest parameters are:

Recreateproductusage Program can be executed as shown in the example: exec RecreateProductusage('<<SKU>>',0);