Script to check for scheduled concurrent requests in Oracle Apps 11i

By
Jul 6, 2011
No Comments

Just a quick script that I wrote to report on concurrent requests that are scheduled to run in the future: select fcr.request_id, fcr.parent_request_id, fu.user_name requestor, to_char(fcr.requested_start_date, ‘MON-DD-YYYY HH24:MM:SS’) START_DATE, fr.responsibility_key responsibility, fcp.concurrent_program_name, fcpt.user_concurrent_program_name, decode(fcr.status_code, ‘A’, ‘Waiting’, ‘B’, ‘Resuming’, ‘C’, ‘Normal’, ‘D’, ‘Cancelled’, ‘E’, ‘Error’, ‘F’, ‘Scheduled’, ‘G’, ‘Warning’, ‘H’, ‘On Hold’, ‘I’, ‘Normal’, ‘M’, ‘No […]

Disconnecting users from Oracle MWA

By
Jan 26, 2011
No Comments

These instructions are for E-Business Suite 11.5.10 CU2; they may or may not work in other versions. For an MWA telnet server, or Listener, at a given port number, there is a command channel listening at the next highest port number.  For example, if the Listener is on port 21001, the command channel is on […]