Hi,

When using the SQL Report Wizard I recieve the following error (FOC36395 - TITLE IS TOO LONG - LIMIT 64 CHARACTERS) when the code below is used. What could be the possible cause of this error because I do not see anything wrong with the code. FYI: when I run the code in another editor such as TOAD it works fine.

SELECT fgbgenl_fund_code,
DECODE (fgbgenl_acct_code, '14700', '42100', fgbgenl_acct_code),
ABS (SUM (fgbgenl_sum_periodic_dr - fgbgenl_sum_periodic_cr)),
DECODE (
SIGN (SUM (fgbgenl_sum_periodic_dr - fgbgenl_sum_periodic_cr)),
'1', 'D',
'C')
FROM fgbgenl, ftvacct, ftvatyp
WHERE fgbgenl_coas_code = '1'
AND fgbgenl_fsyr_code = '10'
AND fgbgenl_fund_code <> 'B00001'
AND fgbgenl_acct_code <> '31100'
AND fgbgenl_period <> '00'
AND fgbgenl_acct_code = ftvacct_acct_code
AND fgbgenl_coas_code = ftvacct_coas_code
AND ftvacct_eff_date <= SYSDATE
AND ftvacct_nchg_date > SYSDATE
AND (ftvacct_term_date IS NULL OR ftvacct_term_date > SYSDATE)
AND ftvacct_atyp_code = ftvatyp_atyp_code
AND ftvacct_coas_code = ftvatyp_coas_code
AND ftvatyp_eff_date <= SYSDATE
AND ftvatyp_nchg_date > SYSDATE
AND (ftvatyp_term_date IS NULL OR ftvatyp_term_date > SYSDATE)
AND ( ftvatyp_internal_atyp_code IN ('10', '20')
OR fgbgenl_acct_code = '54400'
OR fgbgenl_acct_code = '55400')
GROUP BY fgbgenl_fund_code, fgbgenl_acct_code, ftvacct_normal_bal;

Regards,

Erika

This message has been edited. Last edited by: Kerry,

Did you see the earlier topic:
(FOC36395) TITLE IS TOO LONG - LIMIT IS 64 CHARACT : earlier post