audit trail

im working on an audit trail module of a certain integrated financial system. it runs in oracle database platform. is there anyone who can provide me the schema or sample code that i can use as template to write and develop the script??