LNS: Billing fails with the following error: Call to AR_INVOICE_API_PUB.CREATE_INVOICE failed with error message (Doc ID 2242345.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

LNS: Billing fails with the following error:


Cause: FDPSTP failed due to ORA-01086: savepoint 'BILL_LOANS_PVT' never established in this session or is invalid
ORA-06512: at "APPS.LNS_BILLING_BATCH_PUB", line 5684
ORA-01086: savepoint 'PROCESS_SINGLE_LOAN_PVT' never estab 09-MAR-2017 09:46:35

Calling AR_INVOICE_API_PUB.CREATE_INVOICE...
IBY_FNDCPT_TRXN_PUB.get_default_mandate: Exception occured when retrieving Mandate id for l_payer_id: 190669l_assign_id:1972519
IBY_FNDCPT_TRXN_PUB.get_default_mandate: SQLCODE: 100
IBY_FNDCPT_TRXN_PUB.get_default_mandate: SQLERRM: ORA-01403: no data found
IBY_FNDCPT_TRXN_PUB.get_default_mandate: Returning NULL for Mandate id
Invoice API timing: 0 sec
l_return_status: S
l_msg_data:
l_batch_id:
Transaction completed successfully

Call to AR_INVOICE_API_PUB.CREATE_INVOICE failed with error message:

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