Previous | Next | Contents | Index | Navigation | Glossary | Library |
Oracle HRMS supplies SQL*Plus script templates. It also supplies two sample Microsoft Word documents containing merge codes for the SQL*Plus scripts. You can copy the SQL*Plus scripts from the server side sql directory of the HR or product tree. (Consult your installation guide for details).
Oracle Training Administration does not provide template scripts, but we provide an example of a Confirmation letter SQL mail merge file, see OTA SQL*Plus Script
You can copy the word documents from the client-side directory [APPL_TOP]\PER76\LETGEN.
You can run the scripts on the server side and make them accessible to other users across the network, or you must copy them to a directory which is accessible from the PC, such as a network drive. You must also make the Microsoft Word documents accessible to other users across the network, or you must copy them to each PC.
Scripts and Documents | Purpose | Used By |
PERWPOUS.sql | Example US Offer letter SQL mail merge file | HR |
PERWPOUK.sql | Example UK Offer letter SQL mail merge file | HR |
PERWPIUS.sql | Example US Interview letter SQL mail merge file | HR |
PERWPIUK.sql | Example UK Interview letter SQL mail merge file | HR |
PERWPOUS.doc | Example US Offer MS Word document | HR |
PERWPOUK.doc | Example UK Offer MS Word document | HR |
PERWPIUS.doc | Example US Interview MS Word document | HR |
PERWPIUK.doc | Example UK Interview MS Word document | HR |
One of the template SQL*Plus scripts is provided as an example, see Template SQL*Plus Script PERWPOUK
Oracle Training Administration does not provide template scripts, but we provide an example of a Confirmation letter SQL mail merge file, see OTA SQL*Plus Script
To generate your Microsoft Word letter, see Generating a Microsoft Word Letter
Previous | Next | Contents | Index | Navigation | Glossary | Library |