Loader Database Package for Oracle Managed Cloud Services
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 scripts OOD_aiw_prepare_XXX.sql and 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. Run the loader’s OOD script to generate grants for the BOLINF schema and extra synonyms for the APPS Schema.
1) Connect to SQL*Plus as the APPS user and run OOD_aiw_prepare_XXX.sql e.g. OOD_aiw_prepare_WIP.sql for the WIP Loader (Work In Process Loader).
2) Connect SQL*Plus as the BOLINF user and run aiw_install_XXX.sql e.g. aiw_install_WIP.sql for the WIP Loader.
Before opening sqlplus, please set the LOCAL (or TWO_TASK on Unix/Linux) environment variable on the command line.
set LOCAL=server:port/sid
Two examples:
> set LOCAL=tornado.more4apps.com:1555/vis9
> set LOCAL=tornado
Example:
Set Local (or TWO_TASK on Unix/Linux) environment variable
Start SQL*Plus as APPS and Enter the password for apps when prompted
Run OOD_aiw_prepare_XXX.sql (e.g. OOD_aiw_prepare_WIP.sql)
Press ‘Enter’
(Make sure the default value surrounded by the [ ] is “Y”, otherwise, enter “Y”)
Enter BOLINF password
You will be prompted for the BOLINF password. Enter password and continue as per the instruction in the console.
After a “Synonyms and grants created” message, press enter.
Now, start SQL*Plus as BOLINF and Enter the password when prompted
Once the OOD script installation finishes successfully, connect to SQL*Plus as the BOLINF user and enter the BOLINF password when prompted.
Run aiw_install_XXX.sql (e.g. aiw_install_WIP.sql)
(Ignore the message “SP2-0103: Nothing in SQL buffer to run”)
Select “Y” when asked for the Oracle On Demand site and press ‘Enter’.
Press ‘Enter’
You have successfully installed the loader database packages. Press ‘Enter’.
Repeat these steps for each loader you are installing.
e.g. WIP Loader, INV Physical Stock Take Loader, EAM Work Management Loader.