Skip to Content
author's profile photo Former Member
Former Member

create a report in PI and send it in an email

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2014 at 10:03 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2014 at 10:53 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2014 at 11:10 AM

    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?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2014 at 11:14 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 23, 2014 at 03:55 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.