Step 1: Load the Interface Tables

Using SQL*Loader, your favorite tool, or direct Oracle database-to-database communication, load your data into the required input columns in the following tables:

See Table 5-1. KDLV_PACKAGES_INT interface table, Table 5-2. KDLV_PACKAGE_LINES_INT interface table and Table 5-3. KDLV_PACKAGE_NOTES_INT interface table.

Caution: User data is not validated during import.

Table 5-1. KDLV_PACKAGES_INT interface table
Column	Usage	Data Type	Description
PACKAGE_INTERFACE_ID	Required	NUMBER	Provides a unique identifier for the each record. Derived from the KDLV_INTERFACES_S sequence. For lines tied to a new package, this can be used to tie the line record to the parent record in KDLV_PACKAGES_INT. The PACKAGE_NUMBER and PACKAGE_ID columns can be used for this tie as well. This is required if package lines exist. For new lines, this should be left blank.
DATA_LANG	I	VARCHAR2	Specifies the language of the data being imported, so it can be properly validated in the respective language. If no value is provided, then the language context is the same as the system language of the PPM instance into which the data is being imported.
GROUP_ID	Required	NUMBER	Groups all the records that should be processed at the same time. Use only one GROUP_ID each time you run a report. Derived from the KNTA_INTERFACE_GROUPS_S sequence.
PROCESS_PHASE	Optional	NUMBER	Indicates the current stage of the record as it is being processed. See Process State Information for details.
PROCESS_STATUS	Optional	NUMBER	Indicates the current disposition of the record. See Process State Information for details.
CREATED_BY	Optional	NUMBER	Identifies the USER_ID (from KNTA_USERS) for the user performing the transaction. If left blank, the value is derived from CREATED_BY_USERNAME. If both are left blank, the value is set to the user currently running the report.
CREATED_BY_USERNAME	Required	VARCHAR2	Identifies the USERNAME (from KNTA_USERS) for the user performing the transaction. This is used only if CREATED_BY is left blank.
CREATION_DATE	Optional	DATE	Indicates the transaction date. If left blank, the current date is used.
SOURCE_CODE	Required	VARCHAR2	Provides the identify of the source of the record. This value is not validated and is for informational purposes only.
PACKAGE_ID	Required	NUMBER	Provides an identifier for a package and makes the association between the package and package lines. Derived from the KDLV_PACKAGES_S sequence. For lines tied to a new package, this column can be used to tie the line record to the parent record in KDLV_PACKAGES_INT. Either PACKAGE_INTERFACE_ID and PACKAGE_NUMBER can be used to tie the records. For new lines to be imported into existing packages, this column should refer to the PACKAGE_ID of the existing package.
REQUESTED_BY	Required	NUMBER	Identifies the USER_ID (from KNTA_USERS) for the user requesting the package. If left blank, the value is derived from REQUESTED_BY_USERNAME. If both are left blank, the value is set to the user currently running the report.
REQUESTED_BY_USERNAME	Required	VARCHAR2	Identifies the USERNAME (from KNTA_USERS) of the user requesting the package. This is used only if REQUESTED_BY is left blank.
PACKAGE_NUMBER	Required	VARCHAR2	Identifies the package number. This must use either the same value as PACKAGE_ID or a unique string.
ASSIGNED_TO_USER_ID	Optional	NUMBER	Specifies the USER_ID (from KNTA_USERS) that should initially be assigned the request. If left blank, the value is derived from ASSIGNED_TO_USERNAME. If both are left blank, the package will not have an initial value.
ASSIGNED_TO_USERNAME	Required	VARCHAR2	Specifies the USERNAME (from KNTA_USERS) that should initially be assigned the request. This is used only if ASSIGNED_TO_USER_ID is left blank.
ASSIGNED_TO_GROUP_ID	Optional	NUMBER	Specifies the SECURITY_GROUP_ID (from KNTA_SECURITY_GROUPS) that should initially be assigned to the package. If left blank, this value is derived from ASSIGNED_TO_GROUP_NAME. If both are left blank, the package will not have an initial value.
ASSIGNED_TO_GROUP_NAME	Required	VARCHAR2	Specifies the SECURITY_GROUP_ID (from KNTA_SECURITY_GROUPS) that should initially be assigned the package. This is used only if ASSIGNED_TO_GROUP_ID is left blank.
DESCRIPTION	Required	VARCHAR2	Specifies a user-visible description of the package.
PACKAGE_TYPE_CODE	Required	VARCHAR2	Provides a user-defined categorization of the package. Must be a valid LOOKUP_CODE from KNTA_LOOKUPS where `LOOKUP_TYPE = 'PACKAGE_TYPE'`.
PRIORITY_CODE	Required	VARCHAR2	Indicates the user-defined priority for the package. Must be a valid LOOKUP_CODE from KNTA_LOOKUPS where `LOOKUP_TYPE = 'PACKAGE_PRIORITY'`.
STATUS_CODE	Optional	VARCHAR2	Indicates the status of the package.
PROJECT_CODE	Required	VARCHAR2	Indicates the user-defined project for the package. This should be a valid value from KNTA_LOOKUPS where `LOOKUP_TYPE = 'PROJECT'`.
WORKFLOW_ID	Required	NUMBER	Specifies the workflow that the package should follow. Derived from WORKFLOW_NAME. Either WORKFLOW_ID or WORKFLOW_NAME must be entered.
WORKFLOW_NAME	Required	VARCHAR2	Specifies the workflow that the package should follow. This is used only if WORKFLOW_ID is left blank.
PRIORITY_SEQ	Optional	NUMBER	Provides a sequence number used to determine the relative priority of packages that are scheduled to process at the same time. If left blank, the value is set to 10.
RELEASE_FLAG	Required	VARCHAR2	Indicates whether or not the interface program will release the package once it imports in into the standard Deployment Management tables. Valid values are: Yes No The default is No.
USER_DATA_SET_CONTEXT_ID	Optional	NUMBER	Sets the context identifier for the USER_DATA fields. If left blank, the value is set to 1202.
USER_DATA1 VISIBLE_USER_DATA1 through USER_DATA20 VISIBLE_USER_DATA20	Required	VARCHAR2	Specifies the user-defined fields attached to the user screen. This is required only if user data is defined. This information is not validated nor does it have a default value.
SOURCE_PACKAGE_ID	Required	NUMBER	Identifies the original package for this distribution package.
DISTPKG_STATUS_MEANING	Required	VARCHAR2	Provides a user-visible status for this distribution package.
RUN_GROUP	Required	NUMBER	Provides a run group number of a specific distribution package.
DISTRIBUTION_ID	Required	NUMBER	Identifies the distribution associated with the package.
ENABLED_FLAG	Required	VARCHAR2	Indicates whether or not the distribution package is enabled upon import. (Applies to distribution packages only.) Valid values are: Y N The default values is Y.
DIST_STEP_TRANSACTION_ID	Required	NUMBER	Specifies the path of the distribution workflow step that was run in the transaction with DIST_STEP_TRANSACTION_ID.

Table 5-2. KDLV_PACKAGE_LINES_INT interface table
Column	Usage	Data Type	Description
PACKAGE_LINE_INTERFACE_ID	Optional	NUMBER	Provides a unique identifier for the record. If left blank, the value is derived from the KDLV_INTERFACES_S sequence.
GROUP_ID	Required	NUMBER	Groups all the records that should be processed at the same time. Use only one GROUP_ID each time you run a report. Derived from the KNTA_INTERFACE_GROUPS_S sequence.
PACKAGE_INTERFACE_ID	Required	NUMBER	Provides a unique identifier for the each record. Derived from the KDLV_INTERFACES_S sequence. For lines tied to a new package, this can be used to tie the line record to the parent record in KDLV_PACKAGES_INT. The PACKAGE_NUMBER and PACKAGE_ID columns can be used for this tie as well. This is required if package lines exist. For new lines, this should be left blank.
PACKAGE_ID	Required	NUMBER	Provides an identifier for a package and makes the association between the package and package lines. Derived from the KDLV_PACKAGES_S sequence. For new lines to be imported into existing packages, this column should refer to the PACKAGE_ID of the existing package. For lines tied to a new package, this column can be used to tie the line record to the parent record in KDLV_PACKAGES_INT. Either PACKAGE_INTERFACE_ID and PACKAGE_NUMBER can be used to tie the records.
PACKAGE_NUMBER	Required	VARCHAR2	Identifies the package number. This must use either the same value as PACKAGE_ID or a unique string.
PROCESS_PHASE	Optional	NUMBER	Indicates the current stage of the record as it is being processed. See Process State Information for details.
PROCESS_STATUS	Optional	NUMBER	Indicates the current disposition of the record. See Process State Information for details.
CREATED_BY	Optional	NUMBER	Identifies the USER_ID (from KNTA_USERS ) for the user performing the transaction. If left blank, the value is derived from CREATED_BY_USERNAME. If both are left blank, the value is set to the user currently running the report.
CREATED_BY_USERNAME	Required	VARCHAR2	Identifies the USERNAME (from KNTA_USERS) for the user performing the transaction. This is used only if CREATED_BY is left blank.
CREATION_DATE	Optional	DATE	Indicates the transaction date. If left blank, the current date is used.
SOURCE_CODE	Required	VARCHAR2	Provides the identify of the source of the record. This value is not validated and is for informational purposes only.
SEQ	Required	NUMBER	Provides a user-visible sequence number for the package line. This must be a unique, positive integer and not conflict with other package lines in the interface table or existing lines if importing lines to an existing packages.
PACKAGE_LINE_ID	Optional	NUMBER	Provides the identifier for a package line. This is normally left blank and the value is derived from the KDLV_PACKAGE_LINES_S sequence.
OBJECT_TYPE_ID	Required	NUMBER	Provides the object type ID attached to the package line. Derived from OBJECT_TYPE_ID (in KDLV_OBJECT_TYPES). Either OBJECT_TYPE_ID or OBJECT_TYPE_NAME must be entered.
OBJECT_TYPE_NAME	Required	VARCHAR2	Provides the object type name attached to the package line. Derived from OBJECT_TYPE_NAME (in KDLV_OBJECT_TYPES). This is used only if OBJECT_TYPE_ID is left blank.
OBJECT_NAME	Required	VARCHAR2	Specifies the name of the object to be processed. This value is not validated.
APP_CODE	Optional	VARCHAR2	Specifies the application category for the package line. Derived from KDLV_ENVIRONMENT_APPS. The APP_CODE must exist for all environments in the workflow attached to the package. APP_CODE can be used as information and can sometimes determine migration behavior.
PARAMETER_SET_CONTEXT_ID	Optional	NUMBER	Sets the context identifier for the detail fields. This is normally left blank and is derived from OBJECT_TYPE_ID.
PARAMETER1 VISIBLE_PARAMETER1 through PARAMETER30 VISIBLE_PARAMETER30	Required	VARCHAR2	Specifies the user-defined fields attached to the user screen. This is required only if user data is defined.
RELEASE_FLAG	Optional	VARCHAR2	Indicates whether or not the interface program will release the package once it imports in into the standard Deployment Management tables. Valid values are: Yes No The default is No.
USER_DATA_SET_CONTEXT_ID	Optional	NUMBER	Sets the context identifier for the USER_DATA fields. If left blank, the value is set to 1203.
USER_DATA1 VISIBLE_USER_DATA1 through USER_DATA20 VISIBLE_USER_DATA20	Required	VARCHAR2	Specifies the user-defined fields attached to the user screen. This is required only if user data is defined. This information is not validated nor does it have a default value.
OBJECT_REVISION	Required	VARCHAR2	Specifies the denormalized object_revision of the object entered on this line.
SOURCE_PACKAGE_LINE_ID	Required	NUMBER	Identifies the original package line for this distribution package line.
ENABLED_FLAG	Required	VARCHAR2	Indicates whether or not the distribution package is enabled upon import. (Applies to distribution packages only.) Valid values are: Y N The default is Y.

Table 5-3. KDLV_PACKAGE_NOTES_INT interface table
Column	Usage	Data Type	Description
PACKAGE_NOTE_INTERFACE_ID	Optional	NUMBER	Provides a unique identifier for the record. If left blank, the value is derived from the KDLV_INTERFACES_S sequence.
GROUP_ID	Required	NUMBER	Groups all the records that should be processed at the same time. Use only one GROUP_ID each time you run a report. Derived from the KNTA_INTERFACE_GROUPS_S sequence.
PACKAGE_INTERFACE_ID	Required	NUMBER	Provides a unique identifier for the each record. Derived from the KDLV_INTERFACES_S sequence. This is required if package lines exist. For new lines, this should be left blank. For lines tied to a new package, this can be used to tie the line record to the parent record in KDLV_PACKAGES_INT. The PACKAGE_NUMBER and PACKAGE_ID columns can be used for this tie as well.
PACKAGE_ID	Required	NUMBER	Provides an identifier for a package and makes the association between the package and note. Derived from the KDLV_PACKAGES_S sequence. Identifies the package ID. This can be used to tie the note record to the parent record in KDLV_PACKAGES_INT. Either PACKAGE_INTERFACE_ID and PACKAGE_NUMBER can be used to tie the records.
PACKAGE_NUMBER	Required	VARCHAR2	Identifies the package number. This must use either the same value as PACKAGE_ID or a unique string. This can be used to tie the note record to the parent record in KDLV_PACKAGES_INT. The PACKAGE_INTERFACE_ID and PACKAGE_ID can be used for this tie as well.
PROCESS_PHASE	Optional	NUMBER	Indicates the current stage of the record as it is being processed. See Process State Information for details.
PROCESS_STATUS	Optional	NUMBER	Indicates the current disposition of the record. See Process State Information for details.
CREATED_BY	Optional	NUMBER	Identifies the USER_ID (from KNTA_USERS) for the user performing the transaction. If left blank, the value is derived from CREATED_BY_USERNAME. If both are left blank, the value is set to the user currently running the report.
CREATED_BY_USERNAME	Required	VARCHAR2	Identifies the USERNAME (from KNTA_USERS) for the user performing the transaction. This is used only if CREATED_BY is left blank.
CREATION_DATE	Optional	DATE	Indicates the transaction date. If left blank, the current date is used.
SOURCE_CODE	Required	VARCHAR2	Provides the identify of the source of the record. This value is not validated and is for informational purposes only.
NOTE	Required	CLOB	Specifies the full text of the note.
REPLACE_NOTE_FLAG	Obsolete	VARCHAR2	No longer used.