My Oracle Support Banner

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 MAY 21, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.