Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] FOC36395 ERROR
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] FOC36395 ERROR
 Login/Join
 
Member
posted
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,


WebFOCUS 7.6.11
All Outputs
 
Posts: 9 | Registered: August 12, 2009Reply With QuoteReport This Post
Guru
posted Hide Post
Did you see the earlier topic:
(FOC36395) TITLE IS TOO LONG - LIMIT IS 64 CHARACT : earlier post


(Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats)
 
Posts: 391 | Location: California | Registered: April 14, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] FOC36395 ERROR

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.