My Oracle Support Banner

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

Last updated on JANUARY 25, 2018

Applies to:

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


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
New loan_id: 2186461
New loan number: 858585

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


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.