krish jagit 10.Jul.07 04:49 PM a Web browser LEI LEI - 6.0; LEI - 6.5; LEI - 7.0; LC LSX - All Releases Windows NT; Windows 2000; Windows 2003
I have a LEI Process to upload all employee information into oracle then gets error records from oracle table after PL/SQL process runs.
I categorized these error messages into 6 different categories and created a keyword list with custom error codes.
ERROR#3-No data found
ERROR#5-Unique constraint violated
ERROR#6-Company not associated with office code
I have another form called Error Codes with fields listed: Error code, Who is Responsible, Cause and Action.
Now what i like to do is, write a notes agent to read these error messages and assign a custom error code which it applies and create a separate notes document using Error Codes form. This way it will be easy retrieval of what's the error message and who is responsible for these errors so they can take further action.
First, How do i write this in lotus script?
Second, Do i need to create a Scripted activity in LEI Admin to run this agent? or else what's the best way to do this?