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 NOVEMBER 16, 2022
Applies to:
Oracle Project Portfolio Analysis - Version 12.1.3 and laterInformation 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 |