Lockbox Line Level Cash Application is Not Working as Expected - AR_TRANSMISSIONS_ALL.COUNT is Doubled and the STATUS = OOB

(Doc ID 2173480.1)

Last updated on MAY 08, 2018

Applies to:

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

Symptoms

On : 12.1.3 version, Receipts Related

You are using a Line Level Cash Application hook and Line Level Cash Application is enabled at the Lockbox level.
The Receipts get created, but the Execution report shows the Transmission Record Count incorrectly.
It shows the count as twice the Record Count.
Because of this, AR_TRANSMISSIONS_ALL has incorrect Record Counts, and the Amount and Status is OOB.

Data file includes 8 records, however Lockbox Execution Report output shows:

Transmission Record count=16 (Incorrect)
AR_TRANSMISSIONS_ALL.count=16 and Status = OOB (Incorrect)

This happens only when the Line Level Cash Application is enabled at Lockbox.

Business Impact:
Due to this the Users are getting confused about the record count, they are not able to rely on this report as they are not sure how many Receipts got created.
The report is incorrectly printed and also the Transmission status shows incorrectly.

The Transmission Record Count and Records Transferred to Date does not match.

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