Getting Oracle Apps username from discoverer
Hi we are using Oracle applications release 11 and using discoverer 10g. We use oracle application login to connect to discoverer. can someone please help me figure out how i can get the user name of the person who login and pass it on to my custom sql folder in discoverer?
I also found out that this can be done by some built-in function in discoverer called USER? can you also suggest how i can find these internal functions (through discoverer Admin or Discoverer Plus) or some tutorial on using functions in discoverer.
Appreciate your help.