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

Last updated on APRIL 19, 2023

Applies to:

Symptoms

Issue:
----------------------
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
-----------------------
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


Observation:
-------------------------
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



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

Changes

Cause

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