EBS Customizations (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center