Daniel Borgstrom talking about Oracle

Submitted/scheduled job can be found in: dba_jobs Running jobs can be found in: dba_jobs_running Remove a job: dbms_job.remove( jobno ); DBMS_JOB have been deprecated and replaced by DBMS_SCHEDULER (available from 10.1). Read more about DBMS_SCHEDULER here .

Using Advanced Queing is a good idea when you have some integration or other stuff you want to execute asynchronous. With Advanced Queing it's also possible to automte the deque process using a subscriber. This means, as soon as you put anything on the que it will be dequed as soon as possible. The below example will illustrate that. The code will also show how to read a muli level XML using PL/SQL. Create que table (also stops the que and drops the que table if it's existing). BEGIN BEGIN DBMS_AQADM.STOP_QUEUE(queue_name => 'XXDEMO_INV_QUE'); EXCEPTION WHEN others THEN NULL; END; BEGIN DBMS_AQADM.DROP_QUEUE(queue_name => 'XXDEMO_INV_QUE'); EXCEPTION WHEN others THEN NULL; END; BEGIN DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => 'XXDEMO_INV_AQTAB'); EXCEPTION WHEN others THEN NULL; END; DBMS_AQADM.CREATE_QUEUE_TABLE ( queue_table => 'XXDEMO_INV_AQTAB', q...

Sometimes when you are developing a Forms Personalization it will error out before the form is opened. When this happens you cannot disable custom code to get the form to open and fix the problem. The easiest way to fix this is to disable it directly in the core table. UPDATE fnd_form_custom_actions SET enabled = 'N' WHERE action_id = your action id ; Now your form will open and you can fix the problem.