This window shows all procedures that may be used in this installation of Data
Migration. All procedures must be pre-defined in the package Intface_Util_API
and will be inserted here during installation of the FNDMIG module. If there are
customized procedures added to IntfaceUtil, you may use LOV on Procedure Name to
store them in this window.
Procedures should be connected to migration jobs and is used internally by IFS/Data Migration to execute the job itself. Pre-defined procedures provided by standard IFS/Data Migration are shown in the table below.
| Procedure Name | Comment | Direction |
|---|---|---|
| CHECK_BY_METHOD_NEW | Reads data from a file , using the standard IFS business logic through
a New__ method, invoking it with CheckOption which means that the data will
be validated only , and not inserted it into the database.
Target LU is derived from specified ViewName. |
File In |
| CREATE_OUTPUT_FILE | Used to write data to file. IFS/Data Migration can retrieve data from
any view and write it to a file according to definition in the formatting
tab. |
File Out |
| CREATE_TABLE_FROM_FILE | Reads data from file and stores them in a table in the database. STORAGE-parameters for the CREATE TABLE statement may be maintained in Admin.exe/Foundation1 Administration/Configuration. |
File In |
| INSERT_BY_METHOD_NEW | Reads data from a file and insert them directly into IFS using the standard
IFS business logic through a New__ method. Target LU is derived from specified
ViewName |
File In |
| INSERT_OR_UPDATE | Same as previous, but checks if the row exists in the database first.
If this is the case, a Modify__ will be performed instead of New__. |
File In |
| FNDMIG_EXPORT | Writes all basic data for one or more migration jobs to a special formatted
file. Just specify file information and a WhereClause if you want to limit the selection. You will find a pre-installed job using this procedure. Read the comments on the job header carefully. |
File Out |
| FNDMIG_IMPORT | Reads datafile created by previous procedure, and inserts all basic
data (i.e. header, column details, method list, rules, groups and conversion lists) You will find a pre-installed job using this procedure. Read the comments on the job header carefully. |
File In |
| MIGRATE_SOURCE_DATA | Used to migrate data from an Oracle source (table, view, db-links) into
IFS using valid IFS business logic. |
Source Migration |
| QUICK_REPORTS_OUT | Used to export Quick Reports to a deployable PL/SQL-script. Pre-defined job is available and can be imported from file EXPORT_QUICK_REPORT.txt (read comments on Job header) |
File Out |
| REPLICATION | Used to replicate data within a Logical Unit, from one Company/Contract to one or more Companies/Contracts | Source Migration |
| REPLIC_DATA_OUT | Replicate Data Structures.( outbound messages to IFS/Connect) | ReplicStructure |