retrive active users in oracle applications
retrieve currently active and valid fnd user from oracle applications
Archive for the ‘Oracle Applications’ Category
Know request group name of concurrent programs
knowing request group name to which a concurrent program is associated helps in oracle apps…..
find concurrent programs associated with responsibility
Know concurrent programs associated with responsibility using responsiblity key
File contents into BLOB in Oracle Database, using PL/SQL
Often there will be a requirement for reading .out files generated by Oracle Applications and converting into pdf files and send as mail attachment.
Here is a sample PL/SQL procedure which can read a file from a specified location, into a BLOB and returns it.
The calling program can convert this blob data into any form.
Calling program [...]
