SQL Query is throwing an error

Query 1 is throwing ORA-01858 error where as query2 and query3 are working fine when tested on the same database.

Please help me in understanding the issue in query1 and help me with the appropriate fix.

/**** Query1 *********/

SELECT

 /*+ ALL_ROWS */

 GLD.NAME         AS LEDGER_NAME,

 GJH.JE_HEADER_ID     AS JE_HEADER_ID ,

 GJH.POSTED_DATE,

 GJH.STATUS,

 GJH.JE_SOURCE,

 GJH.JE_CATEGORY,

 GJH.PERIOD_NAME,

 GP.PERIOD_YEAR,

 GP.PERIOD_NUM,

 GJL.JE_LINE_NUM,

 GJL.EFFECTIVE_DATE AS EFF_DATE,

 GJL.ENTERED_DR,

 GJL.ENTERED_CR,

 GCC.SEGMENT1,

 GCC.SEGMENT2,

 GCC.SEGMENT3,

 GCC.SEGMENT4,

 GCC.SEGMENT5,

 GCC.SEGMENT6,