PA_EMPLOYEES
Hello
P.FULL_NAME,
p.employee_number EMPLOYEE_NUMBER,
P.LAST_NAME,
P.FIRST_NAME,
P.MIDDLE_NAMES,
P.EFFECTIVE_START_DATE,
P.EFFECTIVE_END_DATE,
P.EXPENSE_CHECK_SEND_TO_ADDRESS,
P.BUSINESS_GROUP_ID,
P.VENDOR_ID,
DECODE(P.CURRENT_EMPLOYEE_FLAG, 'Y', '*', P.CURRENT_EMPLOYEE_FLAG) "Active",
typ.SYSTEM_PERSON_TYPE person_type
FROM
Can anyone tell me which patch fixed the view PA_EMPLOYEES.
This is the description of the view that we have which returns and error (ORA-01422: exact fetch returns more than requested number of rows) for some projects.
SELECT P.PERSON_ID,P.FULL_NAME,
p.employee_number EMPLOYEE_NUMBER,
P.LAST_NAME,
P.FIRST_NAME,
P.MIDDLE_NAMES,
P.EFFECTIVE_START_DATE,
P.EFFECTIVE_END_DATE,
P.EXPENSE_CHECK_SEND_TO_ADDRESS,
P.BUSINESS_GROUP_ID,
P.VENDOR_ID,
DECODE(P.CURRENT_EMPLOYEE_FLAG, 'Y', '*', P.CURRENT_EMPLOYEE_FLAG) "Active",
typ.SYSTEM_PERSON_TYPE person_type
FROM
0