Results 1 to 6 of 6

Thread: Bi Publisher email failure

  1. #1
    Member
    Join Date
    Aug 2005
    Location
    Atlanta
    Posts
    259

    Bi Publisher email failure

    We are on E1 and using the embedded BI publisher.

    We are trying for the first time to set up the embedded JDE BI/XML publisher to email. What we are working toward is bursting then emailing ACH remittances. To test things out and to see how it works, I am trying to do a simple testing in DEV.

    I have added in the BIP Burst/Deliver options on P95620 with a specific email address to use, mine. When we run the ACH remittance, it shows Communication Failure in the Output delivery details. Our jde.ini is set up with the correct outgoing email server and we are receiving emails like job completion emails from both production and development.

    In the log on the enterprise server there are the following messages.

    Fail to fetch Error Text 951S from Data Dictionary (951S does in fact exist though).
    Unable to get email subject.
    JDB_Fetch F95624 failed with rcode=0
    Send email failed with return code 6.

    Oracle has of yet to be of much help, so any thoughts would be appreciated.


  2. #2
    New Member
    Join Date
    Jan 2008
    Location
    Nieuw-Vennep, Netherlands
    Posts
    10

    Re: Bi Publisher email failure

    Please take a look to the follow Oracle Document : https://support.oracle.com/epmos/fac...09559518934319

    or search on the support.oracle.com site for Doc ID 1381348.1

    When i look in to my JD Edwards 9.1.2 (TR 9.1.3) i can acces the table but it seems that this table is not generated. When i try to acces the table via the databrowser i got the error message ORA-00942 Table or view does not exist.

  3. #3
    Member
    Join Date
    Aug 2005
    Location
    Atlanta
    Posts
    259

    Re: Bi Publisher email failure

    Thanks, reviewing the document, and putting in a from email address as it suggested got rid of the first three messages, but it still fails.

    Now the only error is..
    Send email failed with return code 6

  4. #4
    Member
    Join Date
    Aug 2005
    Location
    Atlanta
    Posts
    259

    Re: Bi Publisher email failure

    Email problem solved. The issue turned out to be missing Text in the data dictionary items 951S and 951T. These are error DD items for email subject and text. Once we populated the Text for these two items, emailing works.

  5. #5
    Member
    Join Date
    Jan 2010
    Location
    Karnataka
    Posts
    188

    Re: Bi Publisher email failure

    great!!
    Let me know the final results.
    Regards,

    Abhishek Chhajer

  6. #6
    Quote Originally Posted by jimmymac View Post
    email problem solved. The issue turned out to be missing text in the data dictionary items 951s and 951t. These are error dd items for email subject and text. Once we populated the text for these two items, emailing works.
    thanks!!!!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.