Receipts Workbench Issue: When Lockbox is Run for Second Time the New GL Date Given In the Submission Window is Not Updated AR Payments (Doc ID 1548573.1)

Last updated on SEPTEMBER 16, 2014

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The GL Date Source has been setup as a constant date, but whenever Lockbox is submitted, the GL Date entered at the submission should be used for the payments processed by that run.
However, the system is not taking new GL Date for the earlier stuck receipts.

For example:
There are 10,000 AR Payment records to submit the Lockbox process.
Navigation: Interfaces > Lockbox > GL Date

The Lockbox process is submitted for the first time with GL DATE ‘30-NOV-2012.’
Only 3,000 records are successfully processed and 7,000 records were rejected due to some validations.

If Lockbox is submitted again in the next period, to re-process the 7,000 payments, a new GL Date is entered in the current open period during submission. 
This is not updated on the payments in the interface.

The GL Date Source has been setup to be Constant Date in Lockboxes.

Responsibility:  Receivables
Navigation: Lockboxes > Receipts > GL Date Source > Constant Date

Since November is closed, these records cannot be processed unless the GL Date is updated manually.

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