My Oracle Support Banner

BANK_CHG Created In Xla Tables When Not Using Bank Charges In Lockbox (Doc ID 1387337.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
Executable:ARLPLB - Process Lockboxes


Symptoms

If there is no Bank Charges setup in the Receipt Method, the value of FACTOR_DISCOUNT_AMOUNT in AR_CASH_RECEIPT_HISTORY_ALL should be null and not 0 (zero).

If you create a receipt manually using a Receipt Method with no Bank Charges, the value of this column is null, and everything is fine. But if you create a receipt using Lockbox (with the same Receipt Method as before), the value of this column is 0 (zero).

The Lockbox receipt accounting failed when applying to a transaction, also the create accounting/post to GL fails for these receipts.

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
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.