Loader Database Package

Important Note: if you are an Oracle Managed Cloud Services (OMCS) customer then SKIP THESE INSTRUCTIONS and refer to section Loader Database Package for OMCS

Once the shared package is installed successfully, the DBA needs to install the database package files. The database package files are files that have the extension .plbs, .plbb, .pks or .pkb. These files are included in the XXX_loader.zip or XXX_loader_VERSION.zip with the relevant install script aiw_install_XXX.sql.

This AIW install script is specific to Application Interface Wizard and will need to be run once per Oracle Applications instance/database.

Connect to SQL*Plus as the APPS user and run aiw_install_XXX.sql e.g. aiw_install_WIP.sql for the WIP Loader (Work In Process Loader).

Example:

Start SQL*Plus and Enter the password for apps when prompted

Run aiw_install_XXXl.sql (e.g. aiw_install_WIP.sql)

Press ‘Enter’

Type ‘N’

(If you are an Oracle Managed Cloud Services site you should be following instructions in section below "Loader Database Package for Oracle Managed Cloud Services”.)

(If the “MESG not declared” message appears, this can be ignored.)

Press ‘Enter’

You have successfully installed the loader database packages.

Repeat this step for each loader you are installing.

For example:

WIP Loader, INV Physical Stock Take Loader and EAM Work Management Loader.