This discussion is archived
1 Reply Latest reply: May 25, 2012 8:47 AM by shreevat RSS

Setting the Closed Date for a Closed SR using Create_ServiceRequest

user8188746 Newbie
Currently Being Moderated
We are using the CS_ServiceRequest_PUB.Create_ServiceRequest API to create SRs for Data Migration which works fine. The Request Date is set to a migrated date from 1997 - today.

Then we want to Close the SR and set the Closed Date to the migrated closed date from the legacy system, so we pass the Closed_Date value to the CS_ServiceRequest_PUB Update_ServiceRequest API.

Unfortunately the CLOSE_DATE in CS_INCIDENTS_ALL_VL is set to the sysdate. The status that is being set is "Paid", which as been set up as a 'Final' status so we expect the date to be set in the past.

An example is:

REQUEST_DATE = 09-NOV-99 17.58.09
CLOSED_DATE = 19-NOV-99 13.42.52

Oracle after Update API
REQUEST_DATE = 09-NOV-99 17.58.09
CLOSED_DATE = 16-NOV-11 16.54.23

Does anyone have any ideas what influences us being able to set the Closed_Date on an SR other than sysdate?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points