Receive Forecast Service

This service is in the WmOAMFG1227 package and has the following fully-qualified service name: masterScheduling1227.intoOA.forecast:receiveForecast.

This service imports forecasts. You can use the Open Forecast interface to load forecast entries for existing forecasts and forecasting sets in the Oracle Master Scheduling/MRP Application.

The Planning Manager runs in background mode and launches the Forecast Interface Load program to perform the import. The Planning Manager scans for rows with a PROCESS_STATUS = 2. These records are then validated and processed. If they are successfully processed, the PROCESS_STATUS is set to 5. If they contain a validation error, PROCESS_STATUS is set to 4 and the appropriate ERROR_MESSAGE appears.

Since the Planning Manager is normally scheduled from the Oracle Applications, you use the IS flow to insert data into the open interface tables.

Database Scripts

This service does not use any database scripts.

Supporting Transaction Definitions

This service was built from the configured services defined in the following transaction definitions:

  • setForecastTxn1227.txp
  • ForecastTransaction1227.txp

For information about using the transaction definition files to customize this service, see Transaction Definitions.

Flow Control

This service uses the following flow steps to import inventory transactions:

  • specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
  • bizDocMapping maps the incoming business document structure to the required Oracle Applications data structures (the interface tables).
    • getOrgId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes ORGANIZATION_NAME as the input parameter, and queries the table ORG_ORGANIZATION_DEFINITIONS to get the ORGANIZATION_ID corresponding to the ORGANIZATION_NAME.
    • getForecastLineId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes LINE_CODE as the input parameter, and queries the table WIP_LINES to get the LINE_ID corresponding to the current ORGANIZATION_NAME.
    • getInventoryItemId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes ITEM_CODE as the input parameter, and queries the table MTL_SYSTEM_ITEMS_B_KFV to get the INVENTORY_ITEM_ID corresponding to the current ORGANIZATION_NAME.
    • getProjectId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes PROJECT_NAME as the input parameter, and queries the table PA_PROJECTS_ALL to get the PROJECT_ID.
    • getTaskId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes PROJECT_NAME and TASK_NUMBER as the input parameters, and queries the tables PA_PROJECTS_ALL and PA_TASKS to get the TASK_ID.
    • getOracleAppsUserId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes ORACLE_APPS_USER_NAME as the input parameter from the business document, and queries the table FND_USER to get the USER_ID. The USER_ID information is required for insertion into the interface tables.
    • getOASystemDateObject returns the Oracle Applications system date as a date object.
    • convertToDataObject converts text date format into object date format. This service is a transformer in bizDocMapping.
  • setForecastTxn inserts data into the interface table, MRP_FORECAST_INTERFACE for Open Forecast.

For more details on receive transactions, see Overview of Receive Service Transaction Processing.

Business Document Structure

This service uses the business document ForecastBizDoc. Its structure is as follows:

  • FORECAST_BIZDOC
FORECAST_BIZDOC (Maps to MRP_FORECAST_INTERFACE)
Field Name Maps to Column Description
ITEM_NUMBER INVENTORY_ITEM_ID Required. Item number in the forecast.
ORGANIZATION_NAME ORGANIZATION_ID Required. Name of the organization.
FORECAST_DESIGNATOR FORECAST_DESIGNATOR Required. Forecast name.
CONFIDENCE_
PERCENTAGE
CONFIDENCE_
PERCENTAGE
 Required. Reliability of forecast data in percentage.
FORECAST_DATE FORECAST_DATE Required.
QUANTITY QUANTITY Required.
COMMENTS COMMENTS Comments about the forecast.
WORKDAY_CONTROL WORKDAY_CONTROL Indicates the action that the Forecast Interface Load should use if it finds a forecast date or a forecast end date that is not a valid workday. Use:
  • 1 for Reject (default).
  • 2 for Shift forward.
  • 3 for Shift backward.
If set to null then it assumes 1
BUCKET_TYPE BUCKET_TYPE Use:
  • 1 for Days (default).
  • 2 for Weeks.
  • 3 for Periods.
FORECAST_END_DATE FORECAST_END_DATE End date forecasts that span multiple periods.
TRANSACTION_ID TRANSACTION_ID Required only when replacing an existing forecast. Must match existing transaction ID in MRP_FORECAST_DATES table.
SOURCE_CODE SOURCE_CODE Identifies external system.
SOURCE_LINE_ID SOURCE_LINE_ID External system reference for the forecast record.
PROJECT_NAME PROJECT_ID Project name.
TASK_NUMBER TASK_ID Task number.
LINE_CODE LINE_ID Line code of WIP job line.