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

have 2 queries that work singularly but errors out when used as a UNION of the 2 sqls, query errors

Accepted answer
41
Views
10
Comments
in Payroll and Global Payroll Interface (GPI) 10 comments

Summary:

I have 2 queries that work beautifully when ran individually but when I create a UNION of the 2 queries I run into issues.

Content (required):

I am trying to list out hours detail for PL accrual routine and can run each of the sqls individually and I get the correct information. But in order to get the total information, I need to run a union of the 2 queries (see below). The only fields that do not have the same data types are peev.screen_entry_value (VARCHAR2) and det.value which is numeric. I tried different ways to convert the VARCHAR2 field in the sql but not successful in any of my attempts (using To_NUMBER or CAST) .

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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