Upon hitting the apply button on the create supplier site screen (Controller = ByrCrtStCO), I want to populate the VAT_CODE so it can be saved along side the new ap_supplier_sites_all record. Currently, this attribute for vat_code is not in the view object that gets passed to the create API in the method ByrAddrAMImpl which calls PosVendorPubPkgHelper.createVendorSite method.
I decided to extend the controller ByrCrtStCO, but is there a way to get the new suppliersiteid that just got created so I can call an update API and update the VAT_CODE.
THanks in advance.
No it is not there. The only Oracle allows us to update the vat code is through the tax update page which has a different view object but same AM. In that one, the update happens as direct base table update using the View object set methods and with no API, so it is as if you did "update ap_supplier_sites_all set vat_code - ? where vendor_site_id = ?".
We are now thinking the only way we could update vat_code is through a direct database update or on insert trigger. That is unless you have other ideas. I would appreciate it.