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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

SQL query need to be debug

Summary:

Hi all,

The Query which I run is showing the field names and the data is not populating. please help me to debug the error.

Content (required):

Outer joins need to be added.

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

WIth pay_roll as (SELECT 

py.payroll_name,

pt.hr_term_id

FROM

pay_payroll_terms pt,

pay_assigned_payrolls_dn apd,

pay_all_payrolls_f py

WHERE 1=1

AND pt.payroll_term_id = apd.payroll_term_id

AND pt.payroll_term_id = apd.payroll_term_id

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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