User exits are used to set profile options and are actually used
to pass the control from 4gl to 3 gl language to do complex
calculations for ex from Oracle reports to outside and return back
to reports.
few of the commonly used user exits are
fnd.srwinit(It allows oracle AOL user exits to detect that they have been called by oralce reports Called from before report trigger)
fnd.flexsql(for retreiving data from the flex-fields in the report using lexical reference)
fnd.flexidval(use to display the data retreived by flexsql using a formula column)
fnd.srwexit(used to release all the memory alocated by oracle AOL used in
after report trigger)
Cheers