EBI9.2: Billing Invoice is Attached Twice Although BI_XMLPBURST Shows Only One Bill (Doc ID 2665384.1)

Last updated on JULY 29, 2024

Applies to:

Symptoms

When sending email, invoice is attached multiple/double times, while it should be sending invoice email once, together with supporting documents.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Log in as VP1 and populate Email Address and Preferred Communication field as "Emails and Print".
2. Following fields must be checked under Customers/ Contact Information  for Contact ID 10 (as an example).
3. Email Invoice as Attachment is selected for Document Code INVC.
4. Attach invoice image option is checked - under Billing Definition/Business unit 4.
5. Invoice Form is XMLPUB under Billing Options.
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 2.
8. Save the trace for BI_XMLPBURST as -TRACE 7 -TOOLSTRACEPC 4044-TOOLSTRACESQL 3.
9. Setup the URL.
10. Pick Active server is selected as ATTACHMENT_URL.
11. Create new invoice.
12. Go to Address and add Invoice Media as "Email Invoice as Attachment".
13. Add Supporting documentation.
14. Upload file for the invoice created previously.
15. Internal Only field is Not checked!
16. Save
17. Then change invoice status to RDY and Save the invoice and log out.
18. Log in as different user.
19. Create new Run Control and set Email Invoice Options as 'Email & Print".
20. Select Single Action Invoice option and click on Run process for the invoice created previously.
21. Process runs with success.
22. AET trace can be generated.
23. Invoice is successfully emailed, supporting documentation is also attached, but the invoice is emailed TWICE, when Invoice should have been emailed only ONCE.

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

Cause

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