Total Pageviews

January 24, 2016

1/24/2016 03:11:00 PM
Reports With Parameters:

1)If WE have parameters in the report we are suppose to define those parameters
  while defining the Concurrent Program

2)Select Parameters button enter the following Fields

        Seqno:Any +ve number no duplicates are allowed
ParameterName: Any User defined parameter name
    Value set:10/NUMBER or 100 Charachters or FND_DATE
        Token:Enter the Bind Variable name

Token : It is one of the field in parameter form to map the Concurrent Program
        parameter with Report bind Variable.

Value Set: Is nothing but list of values with validations which will be used to
       restrict the user without entering the invalid data.

Required Check Box: When we want to make the parameter as mandatory or Optional we will
     use this check box. If we enable  it will be mandatory
                               disable it will be optional.

Display CheckBox: When we want to hide the parameter we will use this check box
     user can not find the parameter at SRS window.
     we can pass default values internally by using Default types.

Enabled Chec kBox: We can delete the parameter.
     instead of deletion we can also disable the parameter. Whenever we required again
     we can enable

Range: This option will be used to set the values as Low and as well as High.

Related Posts Plugin for WordPress, Blogger...