Teleservice - EBS (MOSC)

MOSC Banner

Getting an Error in cs_servicerequest_pub.Update_ServiceRequest

edited May 19, 2014 12:00PM in Teleservice - EBS (MOSC) 3 commentsAnswered

Hello,

I have written a code to update the service request but it fails

prlog('I''m here');

                           

                            begin

                                    select  regexp_replace(i.ay_incident_no,'[^[[:digit:]into u_incident_number  from  dual;

                                    select incident_id into u_incident_id from cs_incidents_all where incident_number=u_incident_number and external_attribute_11 =  i.LG_JOB_CARD_NUMBER;

                               prlog('Incident Number to be updated: ' || u_incident_number);

                               prlog('Incident ID to be updated: ' || u_incident_id);

                            exception when others then

                                    t_output:= substr(sqlerrm,1,3995);

                                    prout('Incident Number Not Found: Going to Next Row');

                                    begin

                                            UPDATE xxaye_lg_data_in@xxlgintegration

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

EBS Teleservice Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center