Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter 12.2.7 Predefined Transaction Services Documentation | Manufacturing Predefined Transaction Services | Receive Forecast Service
 
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.