My Oracle Support Banner

Third Party Billing Import does not Perform Rollback or Fail in Case of Error (Doc ID 1598217.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Lease and Finance Management - Version 12.1.2 and later
Information in this document applies to any platform.


Find that when Third Party Billing Import is run and it encounters an error (e.g. in BILLING_CHARGES due to 0 amount invoice, or missing stream from financial product and SGT), the job does not perform a rollback or end in error. It ends in Completed status, and when viewing the log, you see there is an error that has occurred.

*=>ERROR: User-Defined Exception
1: You must enter a value for SOURCE_ID.
2: ORA-01086: savepoint 'EXTERNAL_BILLING_CHARGES_PVT' never established in this session or is invalid
ORA-06512: at "APPS.OKL_API", line 73
ORA-06510: PL/SQL: unhandled user-defined in Package OKL_EXT_BILLING_CHARGES_PUB Procedure BILLING_CHARGES

Expect the Third Party Billing Import process to error out when there is an error and not process all the other records.

Customer has a business process that when errors occur, they fix them and re-insert the same batch in the interface table. This causes duplication of AR records for the processed records.

The issue can be reproduced at will with the following steps:
1. Insert data into interface table OKL_EXT_BILLING_INTF_ALL
Create an invoice to be loaded via Third Party Billing Import with a stream that is not on that product's SGT (Stream Generation Template), or try to import a 0.00 amount invoice.
2. Run Third Party Billing Import program


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.