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.
-
To submit the scheduled process through the Load Planning Data from Files
dialog box, follow these steps:
-
To submit the scheduled process through the Scheduled Processes work area,
follow these steps: