Hi, Please tell me is it a sql report or Oracle Report(Develoed in Report bulder)?? In case it's an Oracle Report, just check, while creating the executable, which method you are using. You should use Oracle Reports. Regards, Anshul singhal -----Original Message----- Hi, i have a pl/sql report. I created the cncurent program. I have 5 parameters to be passed. So i clicked on parameter buttn the concurent prgram screen and entered the data.

In Oracle Apps Reports, in Concurrent Program Token is Case-sensitive or Not? So many times i have developed the reports, Parameters with Capital let. In Oracle Apps Reports, in Concurrent Program Token is Case-sensitive or Not? So many times i have developed the reports, Parameters with Capital let.

As i read i have to give TOKENS, the exact names of parameters inorder to link it to prgram, but whn i click TOKEN it says field cannot be updated and it shows blank. How should i proceed? Tokens are needed if you use oracle reports to build the report, As you said its a PL/SQL report, create parameters in the PL/SQL procedure and map your parameters in that order. Descargar Windows Vista Ultimate 1 Link Iso 64 Bits. Remember to have 2 out parameter errbuf and retcode to store error message and return code.

If its a SQL query then &1 to &5 can be used to read parameters in the order its registered in the concurrent program. -----Original Message----- Hi,i have a pl/sql report. I created the cncurent program.I have 5 parameters to be passed.so i clicked on parameter buttn the concurent prgram screen and entered the data. As i read i have to give TOKENS, the exact names of parameters inorder to link it to prgram, but whn i click TOKEN it says field cannot be updated and it shows blank. How should i proceed?

TOKENs are only used for Oracle Reports, no need to populate them for PL/SQL conc program PL/SQL takes parameters in order received, so you would refer to you parameters &&1, &&2, etc, for example VARIABLE g_outfile_dir VARCHAR2(100); VARIABLE g_prog_title VARCHAR2(80); VARIABLE g_email_to VARCHAR2(100); BEGIN:g_email_to:= NVL ('&&1', NULL);:g_outfile_dir:= NVL ('&&2', '$APPLCSF/$APPLOUT/');:g_prog_title:= NVL ('&&3', 'Report'). END; thanks ----- Original Message ---- From: anamikar via oracle-apps-l To: Roman Draguilev Sent: Saturday, April 5, 2008 7:27:57 PM Subject: [oracle-apps-l] Passing parameter as tokens in cncurrent program Hi, i have a pl/sql report. I created the cncurent program. I have 5 parameters to be passed.