PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Error in running query because of SQL Error, Code=1858, Message=ORA-01858

I have created a view that uses the sql below -

SELECT DISTINCT a.emplid

 , d.name

 , a.g_form_id

 , k.g_form_status

 , d.g_I9V3_COMPL_DTTM

 , a.deptid

 , a.business_unit

 FROM sysadm.ps_g_form_hire a

 , sysadm.ps_g_formlist b

 , sysadm.ps_g_formlist k

 , sysadm.ps_G_FORM_CHKL ch

 , sysadm.ps_G_I9V3_I9_DTLS d

 WHERE a.g_form_id = b.g_form_id

  AND k.g_form_type = 'CHECKLIST'

  AND ch.g_form_id = k.g_form_id

  AND a.g_form_id = ch.g_Hire_form_id

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