My Oracle Support Banner

Print Receivables Transactions ESS Process Is Not Marking Invoices As Printed (Doc ID 2668699.1)

Last updated on APRIL 19, 2023

Applies to:

Oracle Fusion Receivables Cloud Service - Version and later
Information in this document applies to any platform.


1. Print Receivables Transactions ESS process is completing with error
2. Duplicate emails are being sent to the customer with the same invoices every day.
3. Out of complete lot only few email are sent and there is a big lot of invoices which are not being sent to the customer
4. Print flag is not updating on the invoices which has been sent to the customer and therefore same invoices are being sent everyday.
5. Whenever the invoice having issue is getting processed the program is completing with unexpected error and user do not know which emails are sent and which are not sent.

error update_print_status: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "FUSION.AR_BPA_PRINT_INVOICE", line 395

The issue is occurring when system is trying to process the invoice which does not have the contact updated but associated customer has multiple contact and system is not able to select one contact point to send the email

The issue can be reproduced at will with the following steps:
1. Run Print Receivables Transactions




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

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