The Application Engine program PSU_PROC_CRSE has a Do Select action with the following code:
%Select (COURSE, EFFDT, DESCR, TOOLS_REL)
SELECT COURSE
, EFFDT
, DESCR
, TOOLS_REL
FROM PS_PSU_COURSE_TBL A
WHERE A.EFFDT <= (SELECT MAX(A1.EFFDT)
FROM PS_PSU_COURSE_TBL A1
WHERE A1.COURSE = A.COURSe
AND A1.EFFDT <= GETDATE())
The program works fine in testing, but it fails when run on an Oracle database platform.
Select the two approaches that will resolve the problem and give the expected results. (Choose two.)
A. Delete the Where clause.
B. Change the WHERE clause to WHERE A.EFFDT = MAX(EFFDT).
C. Change the SELECT clause to SELECT DISTINCT.
D. Change the WHERE clause to WHERE %EffdtCheck(PSU_COURSE_TBL A, %CurrentDateIn).
E. Replace the GETDATE() function with the %CurrentDateIn system variable.
F. Select the Active check box on the step so that the PeopleSoft Application Engine automatically selects the current row.
|
Download Printable PDF. VALID exam to help you PASS. |
 |