Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with advanced rule in ITG Demand Mgr

Highlighted
Con O'Keeffe
Occasional Advisor

Problem with advanced rule in ITG Demand Mgr

Greetings Gurus,
I'm trying to create an advance rule that will build a direct link to a support case when a support case number is entered.
I am working in ITG Version 6.0.0 SP7.
Below is the SQL.

Select 'http://metalink.oracle.com/metalink/plsql/tar_main.this_tar?p_ctryCode=840#38;tar_num='||[REQD.VP.P_TAR_NUMBER] , 'http://metalink.oracle.com/metalink/plsql/tar_main.this_tar?p_ctryCode=840#38;tar_num='||[REQD.VP.P_TAR_NUMBER] from dual;
I have tried several variations, but I always get a KNTA-10521 error.
The attachment has further details
What did I do wrong?
Thanks in advance for your help,
Con O'Keeffe
2 REPLIES
Tim Brandish
Frequent Visitor

Re: Problem with advanced rule in ITG Demand Mgr

try the attached sql. I think you just need to have quotes around your tokens, make sure you don't have a line break in your URL and remove the semicolon at the end.
Con O'Keeffe
Occasional Advisor

Re: Problem with advanced rule in ITG Demand Mgr

Tim,
That was it!!
Thanks for yourhelp.
Best regards,
Con O'Keeffe
//Add this to "OnDomLoad" event