My Oracle Support Banner

LNS: Billing Program Errors With Invoice API Throws Exception Message (Doc ID 2253070.1)

Last updated on JULY 18, 2018

Applies to:

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


When running LNS: Billing, or using the 'Bill Next Installment' option, the billing errors with the following:

Invoice API timing: 0 sec
Invoice API throws exception!
No AR errors found.

The FND Debug shows an error on the flexfield:
EXCEPTION : Get_Cursor()
p_context_index = 0
p_table_name = RA_CUSTOMER_TRX_LINES
EXCEPTION : arp_invoice_validate_flex.unique_flex
Invoice API timing: 1 sec
sid:339219665: Invoice API timing: 1 sec
Invoice API throws exception!
sid:339219665: Invoice API throws exception!
No AR errors found.

Steps to Reproduce:

Responsibility: Loan Agent
: Submit Request

  1. Submit LNS: Billing program for any or all loans.


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.