I want to update the records of "as_leads_all" table, for that i am using the built-in api "AS_OPPORTUNITY_PUB.UPDATE_OPP_HEADER". But i am getting error while updating. can any body please suggest what are the mandatory records that has to passed into the api so that updation will be successfull. Also can any user update record created by any other user or there is any restrictions over updation of records.
As i have assumed your questions, you want to dig through the AS_OPPORTUNITY_PUB.UPDATE_OPP_HEADER api.
One way is to use toad(place the cursor where you have written the api name and press F4).
If you want to navigate from front end, then login as ebusiness/welcome. go to sales online super user, vision insurance responsibility, there you click on sales online.
In that page you can query the existing opportunities, create new leads, opportunities.
If you want more details then check this link.
Oracle Trading Community Architecture User Guide, Reference Guide, Implementation Guide.
I solved it myself. I referred the TCA manual. Manual had clearly explained the mandatory records. It helped me and also any user who has sales online responsibility assigned can update the records. We have to be careful while passing the salesforce id.