Retrieve active users in Oracle Applications
retrieve currently active and valid fnd user from oracle applications
Archive for the ‘Oracle Applications’ Category
How to know Request Group name of Concurrent Programs in Oracle Applications
knowing request group name to which a concurrent program is associated helps in oracle apps…..
How to Find concurrent programs associated with responsibility in Oracle Applications
Know concurrent programs associated with responsibility using responsiblity key
How to find Scheduled Concurrent Programs in Oracle Applications
Know when a concurrent program is scheduled in Oracle Apps
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 [...]
