View Suresh Vaishya's profile
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 fcpl.LANGUAGE = 'US'
AND par.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name
9 Comments:
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
Make the field varaiable expandable, so it will stretch to show the complete content.
Suresh
hi suresh,
field was expandable only.
still not getting complete string in report output.
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.
Hi Suresh,
Please provide your email id.
sureshvaishya@gmail.com, but if possible ask questions here so that others may also be benefitted by that.
Any way to show what value sets are used for the parameters?
New Query posted at
http://sureshvaishya.blogspot.com/2009/03/concurrent-program-name-with-parameter.html
Hi, How can we update Concurrent program's parameters through sql query?
Post a Comment