-1 Bank_chg In Xla Tables When Not Using Bank Charges - Lockbox (Doc ID 1387337.1)

Last updated on DECEMBER 28, 2011

Applies to:

Oracle Receivables - Version: 12.1.3 and later   [Release: 12.1 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

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