Unexpected Offset Request Results For Credit&Debit Invoices With Mixed Debit/Credit Bill Line Items

(Doc ID 2363687.1)

Last updated on FEBRUARY 22, 2018

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.6.0.0.0 to 2.6.0.0.0 [Release 2]
Information in this document applies to any platform.

Symptoms

On : ORMB 2.6.0.0.0 version, BI - Billing

Offset Request Is Producing Unexpected Results when Credit and Debit Invoice used have a mix of open debit and credit bill line items.

ACTUAL BEHAVIOR
---------------
On ORMB 2.6.0.0, we noticed that offset request is producing unexpected results when the Credit and Debit Invoices used in the request have a mix of open debit and credit bill line items within.

STEPS
-----------------------
Data Setup
Account has a credit invoice which consists of open credit and debit lines.
Account has a debit invoice which consists of open debit and credit lines.


Scenario 1: Use base match type for offset distribution
Offset Distribution Algorithm with match type referencing base Pay Bill Weighted Distribution by Priority and Period.
Create offset request for the credit and debit invoice.

Expected results:
  Balance of debit invoice reduced to $6075.78.
  Balance of credit invoice reduced to $0.00.
.
  Actual results – System Error


Scenario 2: Use CM match type for offset distribution
Update Offset Distribution Algorithm with match type referencing CM Pay Bill Weighted Distribution by Priority and Period.
Create offset request for the credit and debit invoice.

Expected results:
  Balance of debit invoice reduced to $6075.78.
  Balance of credit invoice reduced to $0.00.

Actual results do not match expected results.
Balance of debit invoice became $5743.58.
Balance of credit invoice became $664.40.

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