1. Using Replenishment Planning
  2. Collect Resources and the Resource Availability from an External Source

Collect Resources and the Resource Availability from an External Source

This topic provides the procedure for collecting resources and the resource availability from Oracle E-Business Suite or a third-party system.

Import Templates for Collecting Resources and the Resource Availability

When you're collecting resources and the resource availability from Oracle E-Business Suite or a third-party system, you must use the following file-based data import (FBDI) templates:

  • Supply Chain Planning Resources (ScpResourcesImportTemplate.xlsm): Use this import template to specify the resources and resource shifts.

    During the collections process, the information in the import template is used for generating the resource availability.

    Note the following:

    • The Unit of Measure Code column on the WorkCenterResources_ worksheet must specify a unit of measure (UOM) that's based on hours or units.
    • If the resource availability is calculated in hours, then the UOM for hours specified in the MSC_HOUR_UOM profile option code must be specified in the Unit of Measure Code column.

      For 24-hour availability, you can enter Yes in the Available 24 Hours Indicator column on the WorkCenterResources_ worksheet to avoid loading the resource availability for each hour of every day of your plan.

    • For hour-based resources, you can use the ResourceShifts_ worksheet to define the shifts. The information for shifts is considered along with the applicable organization calendars for calculation of the resource availability.

      If you don't have shifts for your hour-based resources, you don't have to enter information on the ResourceShifts_ worksheet. In this case, you'll enter information on only the WorkCenterResources_ worksheet, and the resources will be considered as being available for 24 hours a day.

    • If the resource availability is calculated in units, then the UOM for units specified in the MSC_DEFAULT_UNIT_UOM profile option code must be specified in the Unit of Measure Code column.

      The Available 24 Hours Indicator column should be set to Yes, and values must also be entered in the Capacity Units and Run Rate columns on the WorkCenterResources_ worksheet. The value entered in the Run Rate column becomes the resource availability for a resource.

      Otherwise, the resource availability won't be calculated.

  • Supply Chain Planning Resource Availability (ScpResourceAvailabilityImportTemplate.xlsm): Optionally, use this import template to calculate the resource availability through multiplication of the values in the Capacity Units and Availability columns on the ResourceAvailability_ worksheet.

    When this import template is used, the resource availability isn't generated during the collections process on the basis of the information in the import template named Supply Chain Planning Resources.

    You can also use the import template named Supply Chain Planning Resource Availability to override the generated resource availability when it has some problem.

After you enter data in the import templates, generate the comma-separated values (.csv extension) files, and place them in a compressed file (.zip extension). Then, use the File Import and Export page to import the compressed file to the scm/planningDataLoader/import account on the Oracle WebCenter Content server.

Methods for Collecting Resources and the Resource Availability with the Import Templates

You must collect resources and the resource availability for Oracle E-Business Suite or a third-party system using the Load Planning Data from Flat Files scheduled process. You can submit the scheduled process from the following:

  • Load Planning Data from Files dialog box that you open from the work area for your module in Oracle Fusion Cloud Supply Chain Planning
  • Scheduled Processes work area

You can collect resources and the resource availability separately or with other reference, demand planning data, and supply planning data entities.

  1. To submit the scheduled process through the Load Planning Data from Files dialog box, follow these steps:
    1. In the work area for your module in Oracle Supply Chain Planning, on the Tasks panel tab, in Plan Inputs, click Load Planning Data from Files.
      The Load Planning Data from Files dialog box opens.
    2. On the Parameters tab, select the source system.
    3. Select the collection type.
    4. In Data File, select the compressed file that you previously uploaded to the scm/planningDataLoader/import account on the WebCenter Content server.
    5. In Enable Organization Group Collection, select No.
      In Organization Group, don't select any value.

      If any organization group is applied, the data for resources won't be collected.

    6. Select or enter values in the remaining fields according to your requirement.
    7. Click the Advanced button.
      The Schedule and Notification tabs are displayed.
    8. On the Schedule tab, to collect resources and the resource availability immediately, select As soon as possible.
      To collect resources and the resource availability according to a schedule, select Using a schedule, and specify values in the fields that appear.
    9. On the Notification tab, to receive information about the scheduled process after it's submitted, select or create a notification.
    10. Click Submit.
      A dialog box with the ID of the submitted scheduled process is displayed. Using this process ID, you can query the status of the submitted process in the Scheduled Processes work area.
  2. To submit the scheduled process through the Scheduled Processes work area, follow these steps:
    1. Click Navigator > Tools > Scheduled Processes.
      The Overview page in the Scheduled Processes work area opens.
    2. Click Schedule New Process.
      The Schedule New Process dialog box opens.
    3. Click Job.
    4. Search for the Load Planning Data from Flat Files scheduled process, select it, and click OK.
      The Process Details dialog box opens.
    5. On the Parameters tab, select the source system.
    6. Select the collection type.
    7. In Data File, select the compressed file that you previously uploaded to the scm/planningDataLoader/import account on the WebCenter Content server.
    8. In Enable Organization Group Collection, select No.
      In Organization Group, don't select any value.

      If any organization group is applied, the data for resources won't be collected.

    9. Select or enter values in the remaining fields according to your requirement.
    10. Click the Advanced button.
      The Schedule and Notification tabs are displayed.
    11. On the Schedule tab, to collect resources and the resource availability immediately, select As soon as possible.
      To collect resources and the resource availability according to a schedule, select Using a schedule, and specify values in the fields that appear.
    12. On the Notification tab, to receive information about the scheduled process after it's submitted, select or create a notification.
    13. Click Submit.
      A dialog box with the ID of the submitted scheduled process is displayed. Using this process ID, you can query the status of the submitted process in the Scheduled Processes work area.

Related Topics