Field Service - EBS (MOSC)

MOSC Banner

want to insert data in a table whenever a task created in a specific FSE's queue

edited Sep 11, 2015 10:02AM in Field Service - EBS (MOSC) 4 commentsAnswered

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 .

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center