My Oracle Support Banner

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

Last updated on JUNE 04, 2020

Applies to:

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

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

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.