You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Has anyone seen this error before and what can I do to fix it

edited Mar 7, 2018 8:07PM in Reporting and Analytics for HCM 2 comments

Summary

Has anyone seen this error before and what can I do to fix it

Content

I get this error when I am trying to add this code to a report.

 

(select pappf.*,ppa.hr_assignment_id,ppa.hr_term_id  from
 pay_payroll_assignments ppa
,Pay_assigned_payrolls_dn papd
,pay_all_payrolls_f pappf
WHERE  TRUNC(:elmtEndDt) BETWEEN pappf.effective_start_date AND pappf.effective_end_date
                    AND papd.payroll_term_id          = ppa.payroll_term_id
                    AND pappf.payroll_id               = papd.payroll_id) payroll

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!