The Open Requisition Interface (ORI) loads the import file (ASCII or Microsoft Excel) using the Oracle database package utl_file. This package provides an easy way to read and write files on the database server. Therefore, the path where these files will be searched for must be entered in the Oracle configuration file init.ora (this name may vary at your database installation).
The following parameters must be specified for running an ORI import job:
-
Name for the import job that is unique to the actual project
-
Path of the import file
-
Name of the import file
-
Processing mode (insert or update)
-
Options belonging to the execution of several CIP functions and procedures
All necessary procedures and functions for the data import are implemented in the package M_PCK_REQ_LOAD.
The ORI import job can be run either in Insert Mode or Update Mode. In Insert Mode, new entries (requisitions, requisition line items, and so forth) can be imported. If an entry already exists, the record will be updated with the values from the import file.
If the job was started in Update Mode, no records will be created and only existing ones will be updated. Each entry (requisition, requisition line item, and so forth) that cannot be found in the database raises a warning. If the import job is run in Insert Mode, the discipline is taken from the requisition node for all new data.