-
Titre
Cannot migrate to both editions for schema and file objects -
Description
Stat archiving and migration would comp/err right away as soon as user drag and drop an archive set that contain schema object or oracle apps file object to both edition. Run edition appear to be working fine. -
Cause
Database is missing context file of patch edition. -
Résolution
Run this query against the Oracle Ebiz instance that is having a problem. Make sure to replace the following query with the correct context_name.
select EXTRACTVALUE(XMLType(TEXT),'//file_edition_name'), EXTRACTVALUE(XMLType(TEXT),'//APPL_TOP[@oa_var="s_at_adconfig"]'), EXTRACTVALUE(XMLType(TEXT),'//ORACLE_HOME[@oa_var="s_tools_oh"]'), EXTRACTVALUE(XMLType(TEXT),'//TWO_TASK[@oa_var="s_tools_twotask"]'), EXTRACTVALUE(XMLType(TEXT),'//APPLFENV'), path, EXTRACTVALUE(XMLType(TEXT),'//APPLTMP'), EXTRACTVALUE(XMLType(TEXT),'//APPLREP'), EXTRACTVALUE(XMLType(TEXT),'//LD_LIBRARY_PATH[@oa_var="s_tools_ldlib"]'), EXTRACTVALUE(XMLType(TEXT),'//NE_BASE[@oa_var="s_ne_base"]'), EXTRACTVALUE(XMLType(TEXT),'//patch_jdbc_connect_alias[@oa_var="s_apps_patch_alias"]'), EXTRACTVALUE(XMLType(TEXT),'//JAVA_TOP'), EXTRACTVALUE(XMLType(TEXT),'//oa_context_name[@oa_var="s_contextname"]'), EXTRACTVALUE(XMLType(TEXT),'//jdbc_url[@oa_var="s_apps_jdbc_connect_descriptor"]'), EXTRACTVALUE(XMLType(TEXT),'//patch_jdbc_url[@oa_var="s_apps_jdbc_patch_connect_descriptor"]') from FND_OAM_CONTEXT_FILES where NAME not in ('TEMPLATE','METADATA','config.txt') and CTX_TYPE='A' and (status is null or upper(status) in ('S','F')) and EXTRACTVALUE(XMLType(TEXT),'//oa_context_name[@oa_var="s_contextname"]') = ‘enter_context_name’
There should be two rows of data return. One for fs1 and one for fs2. If there is no row for fs2 then that's explain why Stat cannot go to both edition. In this case, user will need to have their DBA address the ebiz configurations.
-
Informations supplémentaires
If the object is custom make sure the OA base directory has the context pattern value in place.