My Oracle Support Banner

Update Service Request API Error :"The Incident Reported Date DD-MMM-YY and Incident Occurred Date DD-MMM-YY do not match. The Incident Reported Date must be equal to or greater than the Incident Occurred date." (Doc ID 2457150.1)

Last updated on OCTOBER 09, 2018

Applies to:

Oracle Teleservice - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, APIs & Interfaces

When trying to update fields 'Reported' and 'Incident Time' through API for a Service Request getting the following error:


ERROR
-----------------------
Error :1: The Incident Reported Date DD-MMM-YY and Incident Occurred Date DD-MMM-YY do not match. The Incident Reported Date must be equal to or greater than the Incident Occurred date. Status :E




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Connect to the back end using SQL Plus
2. Run the following script to update 'Reported' and 'Incident Time' of a Service Request

PS:This is sample script which needs to be modified accordingly in each environment

DECLARE
l_return_status VARCHAR2(1);
l_msg_count NUMBER;
l_msg_data VARCHAR2(1000);
l_msg_dummy VARCHAR2 (4000) ;
l_output VARCHAR2 (15000);
l_service_request_rec cs_servicerequest_pub.service_request_rec_type;
l_notes cs_servicerequest_pub.notes_table;
l_contacts cs_servicerequest_pub.contacts_table;
l_sr_update_out_rec cs_servicerequest_pub.sr_update_out_rec_type;
l_workflow_process_id NUMBER;
l_interaction_id NUMBER;
l_user_id NUMBER;
l_resp_id NUMBER;
l_resp_appl_id NUMBER;
l_object_version_number number;
BEGIN
 FND_GLOBAL.APPS_INITIALIZE (USER_ID => 112634,
  RESP_ID => 61525,
  RESP_APPL_ID => 513);

cs_servicerequest_pub.initialize_rec( l_service_request_rec);

l_service_request_rec.REQUEST_DATE := TO_DATE ('31-Aug-2018 16:27:34', 'dd-MON-YYYY HH24:MI:SS');
l_service_request_rec.INCIDENT_OCCURRED_DATE :=l_service_request_rec.REQUEST_DATE;

SELECT object_version_number
  INTO l_object_version_number
  FROM cs_incidents_all_b
  WHERE incident_id = 2926538;
  
CS_ServiceRequest_PUB.Update_ServiceRequest (p_api_version => 3.0,
  p_init_msg_list => FND_API.G_FALSE,
  p_commit => FND_API.G_FALSE,
  x_return_status => l_return_status,
  x_msg_count => l_msg_count,
  x_msg_data => l_msg_data,
  p_request_id => 2926538,
  p_object_version_number => l_object_version_number,
  p_last_updated_by => NULL, --fnd_global.user_id,
  p_workflow_process_id => NULL,
  p_last_update_date => NULL,
  p_service_request_rec => l_service_request_rec,
  p_notes => l_notes,
  p_contacts => l_contacts,
  x_workflow_process_id => l_workflow_process_id,
  x_interaction_id => l_interaction_id );
  IF (l_return_status = 'S') then
  COMMIT;
  ELSE
  ROLLBACK;
  BEGIN
  FOR i IN 1 .. l_msg_count
  LOOP
  fnd_msg_pub.get (i,
  fnd_api.g_false,
  l_msg_data,
  l_msg_dummy);
  l_output := (TO_CHAR (i) || ': ' || l_msg_data);
  END LOOP;
  END;
  DBMS_OUTPUT.PUT_LINE ('Error :'||l_output);
  END IF;
  DBMS_OUTPUT.PUT_LINE ('Status :'||l_return_status);
END;
/



Get the above error


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.