Loan Create API (LNS_LOAN_PUB.CREATE_LOAN) giving Error For Multiple Records (Doc ID 2002593.1)

Last updated on AUGUST 24, 2016

Applies to:

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

Goal

We are running API (LNS_LOAN_PUB.CREATE_LOAN) to create ERS loans. Loan recreated successfully for the first record and giving error for remaining records.
(Invalid Value Passed for Attribute P_LOAN_PART_TBL(l_count).loan_participant_type: PRIMARY_BORROWER)

When we run the program again, the first record is successful and remaining is not successful.

Please find the error message and output below.

Trx Number 858585 Started
l_return_status S
l_msg_count 0
Success!
New loan_id: 2186461
New loan number: 858585

Trx Number 959595 Started
l_return_status E
l_msg_count 1
Errors:
Invalid Value Passed for Attribute P_LOAN_PART_TBL(l_count).loan_participant_type: PRIMARY_BORROWER
 

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