When the oaf program calls VO, APPS.HR_UTIL_MISC_WEB is invalid,but all_objects show it is valid
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select pp.effective_date||' - '||
pay_us_employee_payslip_web.get_meaning_payslip_label(:1||'', 'JOB')||' '||
pp.action_information14||' - '||
pay_us_employee_payslip_web.get_meaning_payslip_label(:2||'','CHECK')||' '||
pp.check_count payslip_choice,
pp.action_context_id,
pp.person_id,
pp.effective_date
from pay_emp_payslip_action_info_v pp,fnd_user fu
where pp.person_id = fu.employee_id
and fu.user_id =:3
and effective_date >= to_date(:4 ,'YYYY/MM/DD')) QRSLT ORDER BY effective_date desc