Report Not Displaying Data

C.

In this scenario, Maurice wants to create a report on employees that only shows employees in the selected department in a select list item. He has already created the report, REPORT_1, based on the EMP table and added a select list called P6_DEPTNO above the region. He has also added a correct WHERE clause for REPORT_1 and defined an "on change" dynamic action on P6_DEPTNO to refresh the REPORT_1 region. However, when he runs the page, no data is displayed, regardless of the department selected.

To get the page to work correctly, Maurice needs to make some changes to the dynamic action and the REPORT_1 region. The correct answer is A, which involves adding a set value action before the refresh action of type PL/SQL Expression with code of :P6_DEPTNO and items to submit to P6_DEPTNO. This will ensure that the select list value is properly set and submitted to the server before refreshing the report region.

Here is a more detailed explanation of each answer choice:

A. Add a set value action, before the refresh action, of type PL/SQL Expression with code of :P6_DEPTNO and items to submit to P6_DEPTNO. This answer is correct. Adding a set value action before the refresh action will ensure that the select list value is properly set and submitted to the server before refreshing the report region. The PL/SQL Expression with code of :P6_DEPTNO will set the value of P6_DEPTNO to the selected department number, and items to submit to P6_DEPTNO will ensure that the select list value is submitted to the server.

B. On the REPORT_1 region, set page items to submit to P6_DEPTNO. This answer is incorrect. Setting page items to submit to P6_DEPTNO on the REPORT_1 region will not solve the problem. This setting determines which page items are submitted to the server when the region is refreshed, but it does not affect the behavior of the select list or the dynamic action.

C. In the "on change" dynamic action, set page items to submit to P6_DEPTNO. This answer is incorrect. Setting page items to submit to P6_DEPTNO in the "on change" dynamic action will not solve the problem. This setting determines which page items are submitted to the server when the dynamic action is triggered, but it does not affect the behavior of the select list or the report region.

D. In the "on change" dynamic action, set event scope to "dynamic". This answer is incorrect. Setting event scope to "dynamic" in the "on change" dynamic action will not solve the problem. This setting determines the scope of the dynamic action, but it does not affect the behavior of the select list or the report region.

In summary, Maurice should choose answer A to get the page to work correctly. Adding a set value action before the refresh action of type PL/SQL Expression with code of :P6_DEPTNO and items to submit to P6_DEPTNO will ensure that the select list value is properly set and submitted to the server before refreshing the report region.