Previous	Next		Contents	Index	Navigation	Glossary	Library

Oracle HRMS supplies you with SQL*Plus scripts as templates. You can copy the SQL*Plus script templates and modify them to create the standard letters you require. Copy the SQL*Plus scripts from the server side sql directory of the HR product tree (consult your installation guide for details). The following example applies to HR--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.

Once you have written your script, save the file with the name PERWP*** (or OTAWP*** for OTA). You must use this prefix for the system to recognise it as a type of letter. See your Oracle Applications installation server guides for details of where the concurrent manager places the files.

The template scripts Oracle HRMS provides are:

Scripts	Purpose	Used By
PERWPMUK.sql	Example UK SQL*Plus script for MultiMate	HR
PERWPMUS.sql	Example US SQL*Plus script for MultiMate	HR
PERWPWUK.sql	Example US SQL*Plus script for WordPerfect	HR
PERWPWUS.sql	Example US SQL*Plus script for WordPerfect	HR

One of the template SQL*Plus scripts (PERWPWUK.sql) is provided as a example, see Template SQL*Plus Script PERWPWUK. 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 write a SQL*Plus script for MultiMate or WordPerfect:

1. Write a SQL*Plus script to select data from the database in a format your word processor can read and that is compatible with the standard letter.

2. Name the program PERWP*** (or OTAWP*** for OTA).

3. Save the program. (Consult your installation guide for details).

Performing the Next Step:

See Also