March 6, 2008

ASO_QUOTE_PUB.Update_Quote API Error

I have been writing code to utilize the Oracle Quoting API.  While I've run into a number of little road blocks or could I say potholes, I have been able to quickly figure out the problem and continue.  But I came across a problem that vexed me.  When I executed the update_quote call, I would always get the error "Record has been updated".  I tried a lot of variations and did a lot of searching on OTN and Metalink until I came across this the comment below on Metalink.  When you are executing the update_quote, you need to pass the last_update_date along with the quote_header_id or you will always get the error.

Error running the ASO_QUOTE_PUB.Update_Quote API

Problem: Receiving the following error running the ASO_QUOTE_PUB.Update_Quote API. Record has been updated. Please requery to see change. (INFO=quote)
Cause: Error message ASO_API_RECORD_CHANGED is returned If (l_last_update_date <> p_qte_header_rec.last_update_date)
Solution:

Whenever making a call to update quote, query the last_update_date from the database and pass it to p_qte_header_rec. Update quote will throw this warning if p_qte_header_rec.last_update_date doesn't match the last update date in the database.

3 comments:

Anonymous said...

Ben,

Much Appreciated your resolution for the issue. I have been firefighting on this issue since 3 days and your blog showed the path to resolve the issue.

Thanks
Nethi.
nnethi@gmail.com

Anonymous said...

Thanks a lot! You saved me a great deal of time. I don't know how long it would have taken me to find out what's wrong.

Ali

Selva Subra said...

You have really saved my time.. Thanks a tonne.