Core Workflow - EBS (MOSC)

MOSC Banner

error when run wfctqrec.sql

edited Aug 3, 2016 5:00AM in Core Workflow - EBS (MOSC) 1 commentAnswered

Hi

we performed work below in R12.1.3 environment.

Note# 418238.1 OATM migration leaves WF_CONTROL objects in the old tablespace


1. Stop Workflow services like WF Mailer Agent, WF listener, etc.
2. Run following SQL :
sqlplus <apps_user>/<apps_pwd> @$FND_TOP/patch/115/sql/wfctqrec.sql <applsys_user> <applsys_pwd>


we stopped AP Tier service,and run the SQL above and encounter the error below


$ sqlplus apps/apps @$FND_TOP/patch/115/sql/wfctqrec.sql applsys apps

SQL*Plus: Release 10.1.0.5.0 - Production on Tue Jul 26 10:00:11 2016

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center