| Description |
While sending contract create feed, feed status got updated for both created and modified records.
*Issue:*
* This scenario may happens only for imported contracts. It contains both Added and Modified records.
* Added records contains dummy ERP PO No as 'C20' and modified does not have ERP PO No.
* After that to make feed to be sent automatically, we ran the below query.
update tblCTContractFeed set strERPPONumber = NULL, ysnSubstituteItem = 1 where strContractNumber = '10'.
* After updating the above statement feed sent automatically but status got updated for both Added and Modified records as 'Awt Ack'.
* This happens in Live for the following contract No's: 10, 11, 28, 29
* Also check SP 'uspIPGenerateSAPPOIDOC_HE' whether we are updating same set of records again and again in Update statement. If so, add a condition to take only required records to update it.
*Expectation:*
* While sending the feed it should update status only for the Added records. Once we receive the ERP PO No, it should send contract update feed for the modified records and status should change to 'Awt Ack'.
|