We are building GL custom report using dynamic pivot . Getting error while performing dynamic pivot

Hi Team,

We are building GL custom report using dynamic pivot . But we are error while performing dynamic pivot .

Query Used:

SELECT * FROM

(

SELECT to_char (gjh.default_effective_date, 'MM-DD-YYYY') accounting_date

, sum ((nvl (gjl.accounted_dr, 0) - nvl (gjl.accounted_cr, 0))) accounted_amount

, gcc.segment1

FROM gl_je_lines gjl

, gl_je_headers gjh

, gl_code_combinations gcc

WHERE 1 = 1

AND gjl.code_combination_id = gcc.code_combination_id

AND gjl.je_header_id = gjh.je_header_id

AND (

to_char (gjh.default_effective_date, 'YYYY-MM-DD') >= (:P_FROM_DATE)

AND to_char (gjh.default_effective_date, 'YYYY-MM-DD') <= (:P_TO_DATE)