Search This Blog

Friday, July 11, 2008

Query to get Concurrent program name and its parameter

Below query can be used to get concurrent program name and its parameter

SELECT fcpl.user_concurrent_program_name
, fcp.concurrent_program_name
, par.end_user_column_name
, par.form_left_prompt prompt
, par.enabled_flag
, par.required_flag
, par.display_flag
FROM fnd_concurrent_programs fcp
, fnd_concurrent_programs_tl fcpl
, fnd_descr_flex_col_usage_vl par
WHERE fcp.concurrent_program_id = fcpl.concurrent_program_id
AND fcpl.user_concurrent_program_name = &conc_prg_name
AND par.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name


Lakki Reddy Sreehari Reddy said...

Hi Suresh.
I have one query.
In one of my report, i am using one formula column of size 1000.
it returning nearly around 90 characters string.
But, In output report showing only partial string.

i veified all sizes of fields in report layout. all 1000 size.

Please help me on this issue

Suresh Vaishya said...

Make the field varaiable expandable, so it will stretch to show the complete content.


Lakki Reddy Sreehari Reddy said...

hi suresh,

field was expandable only.
still not getting complete string in report output.

Suresh Vaishya said...

Also make sure the frames in which the field is enclosed also has expandable property set.
If possible email me the .rdf file and I can look on that.

Lakki Reddy Sreehari Reddy said...

Hi Suresh,

Please provide your email id.

Suresh Vaishya said..., but if possible ask questions here so that others may also be benefitted by that.

Anonymous said...

Any way to show what value sets are used for the parameters?

Suresh Vaishya said...

New Query posted at

Anonymous said...

Hi, How can we update Concurrent program's parameters through sql query?

Copyright (c) All rights reserved. Presented by Suresh Vaishya