DevOps, CI/CD and Automation

Hi All,



once i ran the General Ledger Daily Book concurrent program for one day dedit and credit details it showing different totals of debit and credit.but i ran same sql statements in back end it is showing equal credit and debit.credit and debit deference in report is showing only 1cent
for one day .remaing days it is showing correct.now what i plan is customize the report based on the header_id it is given results but same functionality.that's why i chage one select statement in this report i got this error ORA-24323 VALUE NOT ALLOWED.

THIS IS PREVIOUS SELECT STATEMENT:-
SELECT &C_ALL_SEGS AccountD,
replace(substr(glf.description,1,20),'.',' ') DescriptionD,
replace(b.name,'.',' ') JE_HeaderD,
l.je_line_num Line_NumberD,
replace(c.user_je_category_name,'.',' ') CategoryD,
replace(h.external_reference,'.',' ') ReferenceD,
replace(l.description,'.',' ') HistoricD,
nvl(l.accounted_dr,0) DebitD,
nvl(l.accounted_cr,0) CreditD,
to_char(l.effective_date,'MM') JE_MonthD,
to_char(l.effective_date,'DD') JE_DayD
From FND_FLEX_VALUES_VL glf ,
gl_je_lines l ,
gl_code_combinations glcc ,
gl_je_headers h ,
gl_je_batches b ,
gl_je_categories c
-- fnd_currencies cu
where h.default_effective_date between :P_PRT_START_DATE and :P_PRT_END_DATE
and l.status = 'P'
and l.code_combination_id = glcc.code_combination_id
AND glcc.chart_of_accounts_id = : C_CHART_OF_ACCTS
and b.set_of_books_id = : P_SOB_ID
AND b.set_of_books_id = h.set_of_books_id
AND h.set_of_books_id = l.set_of_books_id
and l.je_header_id = h.je_header_id
AND c.je_category_name = h.je_category
and b.je_batch_id = h.je_batch_id
and &C_BALANCING_SEG = : P_COMPANY
and &C_ACCOUNT_SEG = glf.flex_value
and glf.flex_value_set_id = : C_ACCOUNT_VS
and h.actual_flag = 'A'
AND EXISTS (SELECT 'x' FROM fnd_currencies
WHERE currency_code = h.currency_code
AND currency_flag = 'Y')
ORDER by l.effective_date, &C_ALL_SEGS,l.je_line_num


NOW I JUST ADD ONE MORE CONCDITION IN THIS SELECT STATEMENT

AND to_char(l.effective_date,'DD')=:P_LINE_DATE

I GOT THIS ERROR ORA-24323 VALUE NOT ALLOWED.

PLEASE ANY HELP TO ME HOW TO CUSTOMIZE THE REPORT SAME FUNCTIONALITY JUST ADD ONE MORE CONCDITION IN THIS SELECT
STATMENT.

Thank's