Report Customization

[ram226]

How to use SRW.USER_EXIT('FND SRWINIT') and FND FLEXSQL and FND FLEXIDVAL in customizing the report.

[siva sankar]

Hi Ram,


SRW.USER_EXIT('FND SRWINIT') in this we can call before report trigger.

FND FLEXSQL -This one also we can call before report trigger.
synatx:
fnd flexsql
CODE="fexfield code"
appl_short_name="application short name"
OUTPUT="utput lexcal parameter name"
MODE="{select/where/having/orderby}"
DISPLAY="{all/flexfield qualifier/segmant number}"

FLEXIDVAL- we cal call this user exit from formula column to populate the segment vales into formula column
srw.user_exit(_struct_num);
srw.user_exit(:c_flexdata);
srw.user_exit('fnd flexidval
CODE="GL#"
NUM="_struct_num"
Appl_short_name="SQLGL"
DATA=":c_flexdata"
VALUE=":cf_DATA"
DISPLAY="ALL");

Thanks,
Siva Sankar

[siva sankar]

Hi Ram,


SRW.USER_EXIT('FND SRWINIT') in this we can call before report trigger.

FND FLEXSQL -This one also we can call before report trigger.
synatx:
fnd flexsql
CODE="fexfield code"
appl_short_name="application short name"
OUTPUT=" utput lexcal parameter name"
MODE="{select/where/having/orderby}"
DISPLAY="{all/flexfield qualifier/segmant number}"

FLEXIDVAL- we cal call this user exit from formula column to populate the segment vales into formula column
srw.user_exit(_struct_num);
srw.user_exit(:c_flexdata);
srw.user_exit('fnd flexidval
CODE="GL#"
NUM=" _struct_num"
Appl_short_name="SQLGL"
DATA=" : c_flexdata"
VALUE=" :cf_DATA"
DISPLAY="ALL");

Thanks,
Siva Sankar