7.2 -> 7.3 Upgrade Scripts Error Out On Default_values_73.sql (Doc ID 1544110.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

While upgrading from 7.2.1->7.3->7.4->7.5, And while upgrading from 7.2.1->7.3 the below error is seen :

Error is: ORA-01422: exact fetch returns more than requested number of rows

Problem SQL is:

SELECT poid_id0
INTO v_service_poid
FROM service_t
WHERE poid_type = '/service/admin_client';

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