0 Replies Latest reply: May 9, 2014 1:04 AM by siakhooi RSS

    csi_item_instance_pub.update_item_instance API return "Start date and end date are not in chronological order or have invalid values. (COL_NAME=START_DATE)"

    siakhooi

      We are using R12, a bolt-on system is using API to update instance, and recently we have one of the record return the following error message:

       

      "Start date and end date are not in chronological order or have invalid values. (COL_NAME=START_DATE)"

       

      the API that we are using for this case is csi_item_instance_pub.update_item_instance

       

      we have no clue where to start checking at.

       

      we try to google and search in the oracle support, for such error message but no luck.

       

      please help, any clue will be very much appreciated!

      many thanks.