Alert Email with Reason of failure as content needs to go to Business User

[Former Member]

Dear Friends,

My scenario is simple:

Source CSV File -

---

>PI----

---

>ECC.

When they send Source file to PI by Missing Mandatory field for eg say Last Name.

i have created Alert for this Interface it gives as as usual all techincal jargon and error due to MApping_execution_Runtime.

My requiremnt is When they miss any Mandatory field in source.I should send a Alert to Business user with Resonn of failure.

In this example : Alert should go to end user as : Last name is Missing...... some understanable content to user.

Not our Techincal content .

Kindly tell me how to send Non Techincal Content alert to Business User for this Interface.

Take care,

Preetha

[former_member200962]

You can achieve this in following ways:

1) Create a condition in Receiver Determination to check the existence/ non-existance of the req node.....then select the receiver based on this node....if node exists then proceed as normal...if not then define anoter flow which will send the message directly to the user.....the advantage is that you are avoinding the pipeline steps...

2) use this alert container variable to raise the alert: SXMS_ERROR_CODE......this will give you the required alert text wqhich will be understood by the non-technical person.....this text is taken from SXMB_MONI....for more info refer:

http://help.sap.com/saphelp_nw70/helpdata/en/d0/d4b54020c6792ae10000000a155106/content.htm

Regards,

Abhishek.

[Former Member]

Hi Abhishek,

My structure as follows: For eg If Last Name is missing in source. User should get the mail stating Last Name is Missing.

Kindly tell how to write the condition following source filein Reciver Determination.

My Source file:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_Vendor_Master_CSV xmlns:ns0="http://palm.com/xi/PALMAPPSTORE/in/VendorMaster">

<Vendor>

<Vendor_Detail>

<RecordType>N</RecordType>

<Timestamp>2009</Timestamp>

<FirstName>REEEE</FirstName>

<MiddleName>D</MiddleName>

<LastName>EWQEQW</LastName>

<Developer_Portal_Id>D1000001</Developer_Portal_Id>

<PayerID>P123456789</PayerID>

<Address1>Suite 100</Address1>

<Address2>200 Good Street</Address2>

<City>New York</City>

<District>NY</District>

<PostalCode>10202 </PostalCode>

<Region>NJ</Region>

<Country>USA</Country>

<POBox/>

<Telephone>408-888-8888</Telephone>

<Mobile>408-999-9999</Mobile>

<Fax/>

<Payer_Email/>

<TaxCountry>USA</TaxCountry>

<USTaxid>123-456-789</USTaxid>

<VATid/>

<Diversity/>

<BackupWithholding>N</BackupWithholding>

<RecipientType>01</RecipientType>

<PaymentProvider>PP</PaymentProvider>

</Vendor_Detail>

</Vendor>

</ns0:MT_Vendor_Master_CSV>

[Former Member]

As the ALERT needs to go to BusinessUser.. It should not include Technical details...

Also these errors are not truely not mapping errors. Data validation should be captured & error should be raised explicitly.

so raise Alert as mentioned in the weblog below.. (Triggering ALERTS from a UDF)

/people/bhavesh.kantilal/blog/2006/07/25/triggering-xi-alerts-from-a-user-defined-function

-SM

[Former Member]

Kumar,

Follow the blog given by siva and you may need to do one of the steps given by Bhavesh for the question asked by aamir. This is because you already have a message in XI and you may need to stop processing the message.

Regards,

---Satish

[Former Member]

I am not able to understand tht blog... Why i need to go for Lookup...

When any of the fields in Source is manadatory field in PI then PI should give alert to end user the correposnding FIELDin the particukar row and record is missing.

this is my exact requirement.

CSV file contains 100 records

For eg: Last name in source file is miising then PI shoul throw alert to end user as :

Last name is missing in 50 th record.

This is my exact requiremnt.

File->PI-->ECC

Take care.

Karthik