Question: what is the difference between fnd_global and fnd_profile?
Answer: FND_GLOBAL is a server-side package which returns the values of system globals, such as the login/signon or “session” type of values. Where as FND_PROFILE uses user profile routines to manipulate the option values stored in client and server user profile caches.