Update asset number

Hi All,

I need to update an asset number for an existing asset.

For eg: Need to change asset number 1234 to A-1234

Earlier I used -

update FA_ADDITIONS_B

set ASSET_NUMBER = 'A-1234'

Where ASSET_ID =1234; commit;

Can I use an update like above on base tables? Can anyone please tell if there is a standard interface/update program to achieve this?

Any assistance provided is highly appreciated.

Thanks,

Rahul