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:
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
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
You have really saved my time.. Thanks a tonne.
Post a Comment