"ORA-01917: User Or Role 'SEC_SCHEMA_NAME' Does Not Exist" When Installing Patch 16708145 (Doc ID 1570362.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

On : 7.5 PS4 (16429299) + patch_16853710 + patch_17008935

When attempting to install a pre-requisite patch 16708145 for patch 17056563, by following the Post Installation Instructions:

Run $PIN_HOME/sys/dd/data/device_framework_primary_schema_75ps4.sql
$PIN_HOME/sys/dd/data/device_framework_secondary_schema_75ps4.sql in Primary Schema and run
$PIN_HOME/sys/dd/data/device_framework_secondary_schema_75ps4.sql in secondary schema.

the following error occurs.

ERROR
-----------------------


There are tables indicated in the file that does not exist in the system, one example is ORDER_VOUCHER_T. It seems like the error is because, Voucher Manager, an optional component, is not installed on this system.
It should not prompt this error if the optional component is not installed. Or is it required to have the optional component?

The system does not use multi-schema.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. install patch 16708145
2. SQL> @$PIN_HOME/sys/dd/data/device_framework_primary_schema_75ps4.sql


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