I'm sorry to say that the answer is "No", you cannot use a formula in LEI field mapping. However, you might try this technique as a work-around: add a [hidden & editable] date field to your Notes form, e.g. "InsertedDate"; on the LEI Notes Connection document add to the Data Transformation - Formula to Execute During Select something like "select @all; FIELD InsertedDate := @Now;" (note: the trailing semi-colon is mandatory); add InsertedDate to your Activity field mapping. Run the job and see what you get. The result should be Now's date stamped into the appropriate Oracle field. (Warning: don't try this against your production system without first trying on a test database!!!) FYI: Casahl's ReplicAction does allow a type of alias that uses many or all of the Formula Language functions that can be used during field mapping.
This was first published in August 2002