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

Last updated on APRIL 07, 2017

Applies to:

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

Symptoms

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

Calling AR_INVOICE_API_PUB.CREATE_INVOICE...
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
Navigation
: Submit Request

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

Cause

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