"ORA-00942 : table or view does not exist" When Adding Table In VPD Profile

(Doc ID 2325703.1)

Last updated on NOVEMBER 07, 2017

Applies to:

Oracle Transportation Management Cloud Service - Version 6.4.1 and later
Oracle Transportation Management - Version 6.4.1 and later
Oracle Transportation Intelligence Cloud Service - Version 6.4.1 and later
Information in this document applies to any platform.

Symptoms

When you are adding tables into VPD Profiles (which are the same tables that are already in the default SERVPROV VPD Profile) you receive the following error after saving :


The same error is received when uploading via CSV into the external_predicate table.


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