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.
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. |