Master Program -- Process Billable Streams - Contracts Error (Doc ID 2108942.1)

Last updated on JUNE 09, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Agreement Modules

Program "Master Program -- Process Billable Streams - Contracts" completing with error below :

-----------------------------------------------------
Concurrent Manager encountered an error while attempting to start your immediate concurrent program OKL_STREAM_BILLING_MASTER. Routine &ROUTINE received a return code of failure.

Contact your support representative.
------------------------------------------------------

In the output its says "Unhandled Exception ORA-01427: single-row subquery returns more than one row"

 

ERROR
-----------------------
 "Unhandled Exception ORA-01427: single-row subquery returns more than one row"





STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Run program "Master Program -- Process Billable Streams - Contracts"



Changes

 

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