My Oracle Support Banner

EBI9.2: ERROR_STATUS_BI is '1441' and Not Reset To Blank or Spaces even though Invoices Were Successfully Emailed to Customers (Doc ID 2669859.1)

Last updated on MAY 13, 2020

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The Billing Workbench flagged emailed invoices with the error "Email Attachment Failed", although except for one invoice, all the other were in fact successfully emailed with attachments to customers.

REPLICATION STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in as VP1
2. Go to Customers/ Contact Information for Contact ID A and populate Email Address and Preferred Communication fields
Email Invoice as Attachment is selected
Email address is correctly populated
3. Go to Customers/ Contact Information for Contact ID B and populate Email
Address and Preferred Communication fields
Email Invoice as Attachment is selected
Email address is intentionally incorrectly populated
4. Attach invoice image option is checked under Billing Definition page
5. Invoice Form is XMLPUB under Billing Options page
6. Invoice Form is XMLPUB for Bill Type MSC under Bill Type page
7. Attach Invoice Image Option is selected as Attach Invoice Image for Bill Type MSC under Bill Type page
8. Save the trace for BI_XMLPBURST under Peopletools/ Process Scheduler/ Processes - select Parameter List as Append and set the trace
9. Setup the URLs under Peopletools/ Utilities/ Administration/ URLs
10. Pick Active Server the URL previously created
11. Go to Standard Billing page and create new invoice
12. Invoice Media is selected as Email Invoice as Attachment
13. Create another invoice with the incorrect email address
14. Email invoice as Attachment is again selected, but email address is on purpose incorrect this time
15. Change invoices' statuses la RDY
16. Go to Billing/ Generate Invoices/ Non-Consolidated/Finalize and Print Invoices - Print options tab - Email Invoice Options is selected as Email & Print
17. Run Finalize and Print BIJOB01 process
18. Process runs successfully
  2 invoices processed
  1 email failed
19. Review Invoice Errors page under Billing/Review Processing Results/ Review Invoice Errors- both invoices are listed there as "Email Attachment Failed" Invoice Error status
20. Invoice is successfully emailed where the email address is correct
21. Also, when checking PS_BI_HDR for both invoices, ERROR_STATUS_BI is logged as '1440' for both invoices although one of the invoices has been successfully emailed.

For the replication steps, please review GI-OSS- Replication_document.pdf.

NOTE: In the  attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.