HCM Archive - PSFT (MOSC)

MOSC Banner

Error Message in Query

edited Mar 16, 2022 6:17AM in HCM Archive - PSFT (MOSC) 3 commentsAnswered
A SQL error occurred. Please consult your system log for details.
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'), '

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