krish jagit 10.Jul.07 04:49 PM a Web browser LEILEI - 6.0; LEI - 6.5; LEI - 7.0; LC LSX - All ReleasesWindows NT; Windows 2000; Windows 2003
Hi,
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.
Example:
ERROR#1-Duplicate entries
ERROR#2-NULL fields
ERROR#3-No data found
ERROR#4-Application error
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.
Two questions?.....
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?
Return to top
Print this page
