How to make updates of existing Events using data from Session Venues by eScripts

Dear Oracle Siebel Community,

I would like to ask you a question about how to update the eIEvents new fields that I have created on the BusComp and that are using S_SRC_X table. I have extended the eEvents BusComp ‘eEvents Parent Event’ with free text fields for Venues, i.e. fields ‘Event Venue Name’, ‘Event Venue Address’ and ‘Event Venue Additional Info’. The fields are mapped to the extension table S_SRC_X to the following columns: ATTRIB_01, ATTRIB_47 and ATTRIB_02.

 

Now, for the existing past Events and Sessions I need to migrate the data from Venue BusComp (i.e. ‘Loc Mgmt - Location’) to the above fields in the ‘eEvents Parent Event’ BusComp.