The Recruitment letter type is linked with a SQL* Plus script and applicant status as 1st interview.
The applicant status is changed from Active Application to 1st interview. Identify the valid
outcome.
A.
It creates a letter request automatically, with the status of Pending.
B.
It creates a letter request automatically, with the status of Completed.
C.
The SQL* Plus script concurrent program associated with the recruitment letter type is fired
automatically.
D.
It creates a letter request automatically, with the status as completed only if the number of
applicants with a status of 1st interview is more than 10.
E.
The SQL* Plus script concurrent program associated with the recruitment letter type is
scheduled to be run at the end of the day.
Explanation:
You need to link your SQL*Plus script with a letter and one or more statuses. In
Oracle Human Resources, you can link one or more applicant assignment statuses with each
recruitment letter. A request for the letter is then created automatically when an applicant is given
an associated assignment status.
When an applicant is given one of these statuses, a pending request for this letter type is created
automatically. If a pending letter request already exists, the applicant is added to the list of people
to receive the letter when you submit the request.
Reference:
Oracle Human Resources Management Systems Configuring, Reporting, and System
Administration Guide, Linking the SQL*Plus Script With a Letter