create a report in PI and send it in an email

[Former Member]

Hi,

We have requirement to create a report in PI(single stack) in the below format and send the same in an email:

***************************************************************************************************


Source system = XXX

Total Number of Invoices in File = 7

Destination system = XXX

Total Number of Invoices sent to ECC = 6


Number of invoices for CC1 = 5
Number of invoices for CC2 = 1


Total Number of IDOCs = 6
Total Number of Invoices Dropped by PI = 1

***************************************************************************************************


Invoices sent to ECC:
<invoice number> Sending Company:
<sending company> Type: <invoice type>   

Invoices Dropped by ECC-PI:
<invoice number> Sending Company:
<sending company> Type: <invoice type>   


***************************************************************************************************



Total Number of Conversion Errors = 1

Company code <XXXX> not found on table <table name>.     

<<
end of transmission

Let me know how I can generate a report for an interface on daily basis and send the same over an email?

Thanks.

[avinash_ayanala]

Hi Lalit,

you can create an custom adapter module and use it in the module chain  , so that when ever the interface executes custom module in the interface will collect the audit details and append it to a file at a particular location.

So that you can keep the track of the audit information of that interface with out the help of another interface.I guess it might help you.

Regards,

Avinash

[Former Member]

For messages failing in PI i guess you send alerts. I don't think you would be able to get message details from both systems together.

For IDOC report in ECC, a consolidation report can be created.

[Former Member]

Hi Lalit,

Thanks for the suggestion.

I understand for message failure we can create CBMA and send alert but here the requirement is to generate report for a particular interface which should include the count of IDoc received in PI, processed from PI and failed in PI, so with the count we also need to extract the Invoice# and few other fields as per the requirement and send it in an email.

Please let me know if there is any automated process to extract the count for a particular interface? nd also if there a way to extract the values from these messages which can be published in the report?

Regards,

Akshay

[Former Member]

Hello Akshay,

Did you check this

Generating a custom report on single-stack could be cumbersome :|.

Regards

Diptee

[Former Member]

Hi All,

Thanks for your response and sorry for not providing the complete details.

We are going to create Idoc based interface and we need to identify the no. of messages received and successfully sent to target system for this particular interface on daily basis and at the same time we need to also identify if there are any failure in PI then we need to document the same in report with the reason of failure and last requirement is to provide the Invoice numbers of the messages which has been successfully sent from PI. All these details needs to be documented in a report and send as an email.

Let me know if this is feasible to get such details from PI messages and then generate a report whcih can be sent over an email?

[Former Member]

Hello Akshay,

Did you check this blog

Regards,

Diptee

[Former Member]

This is applicable for dual stack PI installation i guess

[Former Member]

Hello Diptee,

As lalit said, I am trying to identify a way to create this report in PI single stack.

Thanks.

[Former Member]

Hi Akshay,

First get the XML of the report in a text file and create a java mapping or adapter module to create target structure in required format by using the input values.Then use the mail adapter in receiver side to send the mail.

Regards,

Priya

[Former Member]

Create an HTML body in the mapping and send over mail adapter..