Project and Portfolio Management Practitioners Forum
cancel

Problem with advanced rule in ITG Demand Mgr

Highlighted
Con O'Keeffe
Contributor.

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
Honored Contributor.

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
Contributor.

Re: Problem with advanced rule in ITG Demand Mgr

Tim,
That was it!!
Thanks for yourhelp.
Best regards,
Con O'Keeffe