LNS: Billing Program Returning Incorrect Invoice Line Description (Doc ID 2149915.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Loan Information

ACTUAL BEHAVIOR
---------------
LNS: Billing program returning incorrect invoice line description

The LNS: Billing program, while generating the AR invoices for loan interest and principal, is generating incorrect description on the AR invoice lines.

The incorrect description is being picked up for the transaction distribution code combination segment "Entity".
The Entity code "378" is the same number that has been defined recently for a Fund - the description of the Fund flex value is being returned instead of the Entity flex value description.
Technical investigation appears to reveal incorrect SQL - please see attached document for detail.

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