When You Import a Loan Using the API Can You Start at a Payment Number Other Than 1? (Doc ID 1384119.1)

Last updated on NOVEMBER 01, 2016

Applies to:

Oracle Loans - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Goal

When passing parameter P_LOAN_CUST_SCHED_TBL, customer is starting from Payment Number 6 :

L_LOAN_CUST_SCHED_TBL(1).PAYMENT_NUMBER := 6;
L_LOAN_CUST_SCHED_TBL(1).DUE_DATE := SYSDATE + 2 ;
L_LOAN_CUST_SCHED_TBL(1).PRINCIPAL_AMOUNT := 100;
L_LOAN_CUST_SCHED_TBL(1).INTEREST_AMOUNT := 10;

L_LOAN_CUST_SCHED_TBL(2).PAYMENT_NUMBER := 7;
L_LOAN_CUST_SCHED_TBL(2).DUE_DATE := SYSDATE + 30 ;
L_LOAN_CUST_SCHED_TBL(2).PRINCIPAL_AMOUNT := 100;
L_LOAN_CUST_SCHED_TBL(2).INTEREST_AMOUNT := 10;

L_LOAN_CUST_SCHED_TBL(3).PAYMENT_NUMBER := 8;
L_LOAN_CUST_SCHED_TBL(3).DUE_DATE := SYSDATE + 60 ;
L_LOAN_CUST_SCHED_TBL(3).PRINCIPAL_AMOUNT := 100;
L_LOAN_CUST_SCHED_TBL(3).INTEREST_AMOUNT := 10;

However the Payment Numbers in Amortization schedule start from 1 irrespective of the start value to parameter P_LOAN_CUST_SCHED_TBL(1).PAYMENT_NUMBER.


Solution

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