Error Message in Query
Error in running query because of SQL Error, Code=904, Message=ORA-00904: "A"."BUSINESS_UNIT": invalid identifier (50,380)
Has anyone seen this error message and do you know what it means? Below is the SQL from the query we are tyring to run.
SELECT A.HRS_JOB_OPENING_ID, A.HRS_PRM_PST_TITLE, A.DEPTID, B.DESCR, A.HRS_PRM_LOCATION, E.DESCR, A.HRS_PRM_LOC_AREA, D.DESCR, A.JOB_FAMILY, C.DESCR, F.FULL_PART_TIME, H.HRS_JO_DESCR_TYP, H.DESCRLONG, I.HRS_JO_DESCR_TYP, I.DESCRLONG, J.HRS_JO_DESCR_TYP, J.DESCRLONG, TO_CHAR(G.HRS_JO_PST_OPN_DT,'YYYY-MM-DD'), '