Oracle Global Human Resources Cloud Payroll Implementation Specialist — Question 32

You must send the same message in multiple packages to several email addresses stored in the same database table. How do you accomplish this by using a reusable package step? (Choose the best answer.)

Answer options

• A. Create a procedure and add two tasks. The first one must have a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and the second must have a Command on Target that uses OdiSendMail to send the email by using the bind variable defined in the first task.
• B. Create a Knowledge Module. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Command on Target that uses OdiSendMail to send the email using the bind variable defined in the Command on Source.
• C. Create a counter variable that gets the total number of email addresses stored in the database table. Next, create another variable that selects the email addresses from the database table. Then, create a loop in the packages by using the variables and an OdiSendMail step.
• D. Create a procedure. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a

Correct answer: B

Explanation

Option B is correct because it involves creating a Knowledge Module that effectively retrieves email addresses and uses them to send out emails via OdiSendMail. The other options, while they describe processes, are either incomplete or do not utilize a Knowledge Module as effectively for this scenario.