Transfer Planning Data

The EXECUTE_TRANSFER program is used to transfer planning data in SCV based on mapping definitions.

These parameters are used in the EXECUTE_TRANSFER program:

REFRESH_MODE
The refresh mode to use when transferring planning data. Possible values:
  • Full
  • Partial
  • Incremental
TARGET_DELETE_MODE
The mode used for deleting records in the target table when transferring planning data. Possible values:
  • Physical
  • Logical
  • None
TARGET_UPDATE_MODE
The mode used for updating records in the target table when transferring planning data. Possible values:
  • Insert
  • Merge
Note: The value in this parameter must be specified, if the TARGET_DELETE_MODE parameter is set to None.
TRANSFER_MODE
The mode used for transferring source records based on the deleted_flag status. Possible values:
  • All: All records are transferred to the target table.
  • NotDeleted: Records with only deleted_flag="N" in source are transferred to the target table.
Note: By default, this value is set to NotDeleted.
DELETE_VALID_IN_TARGET_INBOX
Indicates whether valid records in the target inbox must be deleted, based on the value specified in the TARGET_DELETE_MODE parameter. Once the deletion of valid records is completed, the process proceeds with the other tasks.
Note: By default, this value is set to N. This parameter is used only when the target table is an inbox.
SOURCE
The source system from which the transferred planning data is imported.
MAPPING_ID
The mapping ID to execute the planning data transfer process.
MAPPING_NAME
The name of the mapping to be processed.
TARGET_TABLE_NAME
The name of the target table where the planning data is transferred.
TARGET_TABLE_GROUP_ID
The ID of the target table group to be processed.
TARGET_TABLE_GROUP_NAME
The name of the target table group to be processed.
TARGET_TABLE_AREA
The name of the target table area to be processed.
SKIP_IF_SOURCE_TABLE_EMPTY
Indicates whether to ignore execution of the transfer if the source table does not contain data.
SNAPSHOT_COLUMN
The name of the column in target table whose values are compared against WINDOW_START and WINDOW_END, during incremental transfer.
INCLUDE_USER_DATA
Indicates whether user-created records must be included in the source data.
Note: By default, this value is set to N. This parameter is only used when the target table is a Core table.