EAR9.2: AR Payment Upload Process AR_EXCL_EDIT Fails When The Customer Does Not Have Open AR Items (Doc ID 2146163.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

On : 9.2 version, Payment Processing

When attempting to load deposits using the AR_EXCL_EDIT process for customers which does not have any open items, the following error occurs.

ERROR
-----------------------

Customer Remit Customer ID Invalid


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

  1. Setup the Excel file and upload the data. Choose customer which does not have any open items.
  2. Run the AR_EXCL_EDIT process to send the data from the staging tables to the application tables. 
  3. The deposit will be flagged in error with “Customer Remit Customer ID Invalid”.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms