My Oracle Support Banner

R12 Project Portfolio Upgrade From 12.1.3 to 12.2.8 fpamain.sql Error ORA-03114 ORA-33290 (Doc ID 2545322.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle Project Portfolio Analysis - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When migrating from 12.1.3 to 12.2.8 the following error occurs.

ERROR
-----------------------
sqlplus -s APPS/***** @/u01/---------/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/---------/fs1/EBSapps/appl/fpa/12.0.0/patch/115/sql/fpamain.sql &un_fpa'
Connected.

PL/SQL procedure successfully completed.

declare
*
ERROR at line 1:
ORA-33290: Analytic workspace FPA.FPAPJP cannot be attached in the mode you
requested because another user has it attached in an incompatible mode

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply Pre-requisite patches for Upgrading from 12.1.3 to 12.2.8.
2. Try running the Update driver Patch, see the error mentioned

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.