want to insert data in a table whenever a task created in a specific FSE's queue
Hi ,
My requirement is >> lets say there is a CE who is having specific CE code 'US539D20' ,
whenever a task assigned to this particular CE , then a particular data should insert in the table with the following format
TASK_NUMBER VARCHAR2(30),
SR_NUMBER VARCHAR2(70),
LOCATION VARCHAR2(50),
CUSTOMER_NUM VARCHAR2(40),
PID VARCHAR2(40),
CREATED_BY VARCHAR2(20),
CREATION_DATE DATE,
PROCESS_FLAG VARCHAR2(2),
LAST_UPDATED_BY VARCHAR2(20) ,
LAST_UPDATED_DATE DATE,
REPAIR_ORDER VARCHAR2(30)
i want to make it automatic with the help of concurrent program .