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,
ErikaThis message has been edited. Last edited by: Kerry,
WebFOCUS 7.7.05 All Outputs
September 14, 2010, 04:47 PM
N.Selph
Did you see the earlier topic: (FOC36395) TITLE IS TOO LONG - LIMIT IS 64 CHARACT : earlier post