PVXASLOG.SQL Errors While Applying Patch 3480000 (Doc ID 1072331.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Partner Management - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 15-Apr-2013***


Symptoms

The following error is reported applying patch3480000


FAILED: file pvxaslog.sql on worker 1

sqlplus -s APPS/***** @/home/DEV/devappl/pv/11.5.0/patch/115/sql/pvxaslog.sql

It errors as follows:
select pv_oppty_routing_logs_s.nextval into l_sequence from dual;
*
ERROR at line 331:
ORA-06550: line 331, column 14:
PL/SQL: ORA-02289: sequence does not exist
ORA-06550: line 331, column 7:
PL/SQL: SQL Statement ignored

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