My Oracle Support Banner

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

Last updated on MARCH 12, 2021

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"



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!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.