TRIGGER TIMINGS

Hi,

  I have a before insert trigger and after insert trigger on a standard oracle table (mtl_system_items_b). In before insert trigger I am assigning a value to one of the attributes. In after insert trigger I am passing the same attribute value to create a record in mtl_cross_references table which references the item in the mtl_system_items_b table. But the record is not being created in mtl_cross_references and I get an error message saying "Cannot find an item master record for this item". I was under the impression when After Insert trigger fires, the record already exists in the database. Is