My Oracle Support Banner

R12: XTR: Loan Decrease Transactions Being Skipped And With Wrong Calculations (Doc ID 2894605.1)

Last updated on SEPTEMBER 14, 2022

Applies to:

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


Loan decrease transactions being skipped and with wrong calculations

Loan transactions for some of the periods is skipped and associated interest and principal amount calculated for given period is wrong.

Resulting other scheduled payment transactions are also calculated wrong.  As these loan are booked for long term, this will result in wrong calculation for future life cycle of the loan transaction.


For most of these Deals, the "Wholesale Term Money" screen does not show the expected transactions.

Steps to reproduce:

  1. Log into Oracle Applications using an Oracle Treasury custom responsibility.
  2. Open the "Wholesale Term Money" screen
    (N) Money Market Transactions > Wholesale Term Money
  3. Query by Deal Number (Deal with the issue)
  4. Click on [Transaction Details]  
    You may NOT find expected Transaction
  5. Scroll down to a row with the issue.



 Customer created custom Treasury responsibility associated to custom DB Schema.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.