2019122522PM-Local SMC Deployment for Financials

最新推荐文章于 2024-08-20 16:26:10 发布

johnny八块肌

最新推荐文章于 2024-08-20 16:26:10 发布

阅读量2.1k

点赞数 3

分类专栏： legacy 文章标签： fusion

本文链接：https://blog.csdn.net/johnny_niu/article/details/90295111

版权

legacy 专栏收录该内容

35 篇文章 0 订阅

订阅专栏

Prerequisites

Before deployment, we need ensure following prerequisites is ready:

A Linux virtual machine which will be used to deploy and run as Weblogic Server.
Database which we will be connected with deployed applications.
We will deploy following products:
1. Payables,Receivables,FinancialCommon,Ledger,: Standard product to Financials
2. FinancialsEss: ESS runtime for Financials
3. FSM (Fusion Setup Manager): Configure Fusion applications.
We will integrate BIP server for BIP based ESS to work.

Deployment Plan

In this guide, we will use following information to deploy SMC server.

Please plan this information before deploy server as you needed.

Variable	Value	Description
domainName	SLC11FRVSMCENV	Domain name
domainHost	slc11frv.us.oracle.com	Domain host
domainPort	7011	Domain port
soaPort	8011	SOA port
dbHost	slcak359.us.oracle.com	Database host
dbPort	1577	Database port
dbSID	ems10955	Database SID
db Template	PT_UCF_S546_HCC_REL13_SMC_CDRM_013117	SMC database template
bipDomain	slc10xki.us.oracle.com	BIP Domain host
bipPort	9704	BIP Domain port
releaseSeries	FUSIONAPPS_PT.V2MIBFIND_LINUX.X64	Label used to create domain
deployView	domain

It's recommended to use different machine to deploy BIP server. Single machine may cause VM overload.

Step by Step Guide

Basic Steps

Refresh Database using SMC database template

Go to http://emsprod.us.oracle.com/. Refresh your database using latest SMC database template.

Refresh DB Steps .xls
If the database template doesn't contain latest datamodel changes, you need to run fpr to patch the changes.

/ade_autofs/ade_infra/FATOOLS_MAIN_LINUX.rdd/LATEST/fatools/fre/bin/fpr -e ems10955 -s FUSIONAPPS_PT.V2MIBFIND_LINUX.X64_170416.0631.S -p V_OWNER_FAMILY=fin V_OWNER_PRODUCT=fa V_CONT_EQUIV=NO V_APPROVED_AUTOAPPLY=NO

It's recommended to patch datamodel by product. Full label patched may cause DB overload.
If you need to use 'Create Accounting', you also need to run fpr for gl, xla product.

Create Weblogic Domain

Set environment variables

setenv ADE_SKIP_HARDCODED_EXPANDS 0
env | grep ADE_SKIP_HARDCODED_EXPANDS
ADE_SKIP_HARDCODED_EXPANDS=0

Create View for Deployment
Create and use an ADE view based on label which want to deploy on.
ade createview -series ade useview

Prepare Properties File for Standalone WLS Creation

Copy properties file to local directory.
Copy the latest fusion_apps_wls.properties file from view to your specified directory, the default is $HOME.
cp $AVR/fatools/tools/wlsconfig/fadev/ps7st/fusion_apps_wls.properties $HOME
If you want to copy fusion_apps_wls.properties to another directory other than $HOME, you must specify "-p <properties_file_path>" when create WLS.

Modify properties file.
Change the properties and db details in fusion_apps_wls.properties file:

domainType=adminall
domainName=fusion_domain
listenPort=7011
soaPort=8011
wlName=weblogic
wlPassword=weblogic1
domainDir=/scratch/hruan/SLC11FRVSMCENV
ESSrunTime=yes
dbConnection=slcak359.us.oracle.com:1577:ems10955

The default domain directory is $MW_HOME/user_projects/domains, you can change it by adding following property in domain section:

e.g. /scratch/software/mw_local/FMWTOOLS_11.1.1.9.1_GENERIC_160712.1219_PATCHES4FA_11.1.13.0.0_PLATFORMS_JDK64/hruan/mw_home_standalone/user_projects/domains

domainDir=<existing_empty_directory>

Create Domain
Run following command to create domain:

ade expand $AVR/fusionapps/ -recurse
cd $AVR/fatools/tools/wlsconfig
sh ./wlsconfig.sh -i -p $HOME/fusion_apps_wls.properties

Known issue: Upgrade ESS Schema

unzip:  cannot find or open /ade/pkasturi_domain1810/biappsshiphome/shiphome/obiapps_installer_BIAPPSSHIPHOME111318100GENERIC1808202011-Release.zip, /ade/pkasturi_domain1810/biappsshiphome/shiphome/obiapps_installer_BIAPPSSHIPHOME111318100GENERIC1808202011-Release.zip.zip or /ade/pkasturi_domain1810/biappsshiphome/shiphome/obiapps_installer_BIAPPSSHIPHOME111318100GENERIC1808202011-Release.zip.ZIP.
... edq
... odi
... soa
... webcenter
... rcu
... pseudo translation files
... Validating installer repository ...
... Missing biappsshiphome installer file
    /scratch/software/mw_local/FMWTOOLS_11.1.1.9.1_GENERIC_170102.1405_PATCHES4FA_11.13.18.10.0_PLATFORMS_JDK64/pkasturi/mw_home_standalone/mw_stage/installers/biappsshiphome/Disk1/runInstaller
   Installer repsoitory is invalid
createInstRepos.sh: invalid_installer_repos
instmwhome.sh: invalid_installer_repos
wlsconfig.sh: MW_HOME did not install successfully. invalid_installer_repos

Solution:
ade mkprivate /ade/pkasturi_domain1810/biappsshiphome/shiphome/obiapps_installer_BIAPPSSHIPHOME111318100GENERIC1808202011-Release.zip

Start Weblogic Server

Starting WLS
Open a new tab in terminal, run following commands to start Admin server:
cd $DOMAIN_HOME/ e.g cd /scratch/hruan/SLC11FRVSMCENV/fusion_domain ./startWebLogic.sh -Xmx4096m -Xms1024m
If you've got OOM issue, try command below.
./startWebLogic.sh -Xmx4096m -Xms1024m -XX:MaxPermSize=3512M or ./startWebLogic.sh -Xmx4096m -Xms1024m -XX:PermSize=1024m -XX:MaxPermSize=4096M
If use remote debug:
./startWebLogic.sh -Xmx4096m -Xms1024m -XX:MaxPermSize=3512M -Xdebug -Xrunjdwp:transport=dt_socket,address=4004,server=y,suspend=n

Test Server Running
You can visit following URL to check whether server is running properly:
Console:
http://:/console

Enterprise Management Server:
http://:/em
Stopping WLS
Admin server can be stop by Ctrl+C in terminal window which server runs.

Deploy shared libraries and applications

Generate the environment details
Register WLS in FREDEM and generate the environment id (or) use sample deploy_config.xml

Sample

Deploy shared libs and apps from ADE view:

cd $AVR/fusionapps
setenv ANT_OPTS "`echo $ANT_OPTS | sed 's/Xmx1536M/Xmx3072M/g'`"
ant -Denvid= -DearsToDeploy=EarFinPayables,EarFinReceivables,EarFinancialCommon,EarFinLedger,EarFinancialsEss -DmergeJazn=true -DpreserveAppRoleGuid=true -DuploadConfig=true -Dmw.home=$MW_HOME j2eeConsolidatedDeploy |tee deploy.log

If you want BU,you need to add EarHcmCoreSetup to -DearsToDeploy.

ORA_FSCM_UIAPP failed to deploy
Found this exception in Weblogic Server log
weblogic.application.ModuleException: java.lang.ClassNotFoundException: oracle.apps.crmCommon.core.extnUpgrade.mbean.CrmExtnUpgradeMBeanImpl

Copy $AVR/fusionapps/jlib/AdfCrmCommonCoreExtnUpgrade.jar
to $AVR/smcapps/sharedLibs/deploy/oracle.apps.fa.model.ear/APP-INF/lib/AdfCrmCommonCoreExtnUpgrade.jar
Note that the destination folder will be purged in the beginning of build process, therefore the jar file should be copied in the middle of the build, check this folder periodically to see if other jars are copied before copying this jar.

Deployment failed
[fa:deploy] ================ Deployment Summary ================
[fa:deploy] oracle.apps.common.fatp.model------------[  DEPLOYED ]
[fa:deploy] oracle.apps.cso.common.adf---------------[  DEPLOYED ]
[fa:deploy] oracle.apps.fa.model---------------------[  DEPLOYED ]
[fa:deploy] oracle.apps.fa.rpx.model-----------------[  DEPLOYED ]
[fa:deploy] oracle.apps.fa.view----------------------[  DEPLOYED ]
[fa:deploy] oracle.apps.fatp.model-------------------[  DEPLOYED ]
[fa:deploy] oracle.apps.fatp.view--------------------[  DEPLOYED ]
[fa:deploy] ORA_FSCM_ESSAPP--------------------------[   FAILED  ]
[fa:deploy] ORA_FSCM_SERVICESAPP---------------------[  DEPLOYED ]
[fa:deploy] ORA_FSCM_UIAPP---------------------------[   FAILED  ]
[fa:deploy] ====================================================


[fa:deploy]
 INFO: <yutfeng_domain>: <yutfeng_domain>: Exception while 
performing deploySMC for application ORA_FSCM_UIAPP : 
java.lang.Exception: Deployment 
FAILED:weblogic.application.WrappedDeploymentException: MDSInstance, 
appName and the MAR checksum cannot be null
[fa:deploy] 
java.lang.Exception: Deployment 
FAILED:weblogic.application.WrappedDeploymentException: MDSInstance, 
appName and the MAR checksum cannot be null
[fa:deploy]     at oracle.deploy.operation.DeploySMCOperation.deployJSR88(DeploySMCOperation.java:81)
[fa:deploy]     at oracle.deploy.operation.DeployOperation.execute(DeployOperation.java:123)
[fa:deploy]     at oracle.deploy.wls.DomainThread.run(DomainThread.java:44)


Solution
cp
 $MW_HOME_STANDALONE/oracle_common/modules/oracle.mds_11.1.1/mdslcm.jar 
$MW_HOME_STANDALONE/oracle_common/modules/oracle.mds_11.1.1/mdslcm.jar.backup
cp
 
$MW_HOME_STANDALONE/oracle_common/.patch_storage/27511365_Mar_27_2018_19_54_46/files/modules/oracle.mds_11.1.1/mdslcm.jar
 $MW_HOME_STANDALONE/oracle_common/modules/oracle.mds_11.1.1/mdslcm.jar
Bounce server and deploy again.

[fa:deploy] [2018-07-24 02:09:09.633]: <fusion_domain>: WLS AdminServer Log:Jul 24, 2018 02:09:09 PDT:Failure occurred in the execution of deployment request with ID '1824257643170279' for task '17'. Error is: 'weblogic.application.ModuleException: [HTTP:101216]Servlet: "oracle.apps.psc.techStack.opaIntegration.webServiceConnector.OpaDataServicePortType1225Impl" failed to preload on startup in Web application: "fscmPojoService".
[fa:deploy] java.lang.RuntimeException: Failed to load Endpoint bean class
[fa:deploy] Caused by: java.lang.ClassNotFoundException: oracle.apps.psc.techStack.opaIntegration.webServiceConnector.OpaDataServicePortType1225Impl

workaround : 
cp $AVR/fusionapps/psc/components/techStack/jlib/AdfPscTsOpaIntegWSConnector.jar $AVR/fusionapps/jlib/faglobal/

Deploy Root menu
For importing Root Menu, copy following files from fusionapps/atf/components/helpPortal/mds/resource/src/oracle/apps/menu from V2MIB or equivalent family series to a temporary folder (Ex: /tmp/menu_dir) preserving the folder structure (oracle/apps..) as below

/oracle/apps/menu/ResourcesAttrBundle.xlf
/oracle/apps/menu/pref_menu.xml
/oracle/apps/menu/root_menu.xml
Steps:
- mkdir -p /tmp/menu_dir/oracle/apps/menu
- cp /ade_autofs/ud62_fa/FUSIONAPPS_PT.V2MIB_LINUX.X64.rdd/LATEST/fusionapps/atf/components/helpPortal/mds/resource/src/oracle/apps/menu/* /tmp/menu_dir/oracle/apps/menu
- $MW_HOME/oracle_common/common/bin/wlst.sh
  - connect("weblogic","weblogic1","t3://:");
  - importMetadata(application='EarFscmUIApp',server='AdminServer',fromLocation='/tmp/menu_dir',docs='/**') //if this can't work, try below sentence or change application to 'ORA_FSCM_UIAPP'
  - importMetadata('ORA_FSCM_UIAPP','AdminServer','/ade_autofs/ud62_fa/FUSIONAPPS_PT.V2MIB_LINUX.X64.rdd/LATEST/fusionapps/atf/components/helpPortal/mds/resource/src/','/**')
  - exit();

Go to /smcapps/EarFscmUIApp.ear/EarUi.war/WEB-INF/web.xml

e.g. /scratch/hruan/SLC11FRVSMCENV/fusion_domain/smcapps/EarFscmUIApp.ear/EarUi.war/WEB-INF/web.xml
- Enable form based Login/Logout

Contents

~~replace~~
- ~~CLIENT-CERT,BASIC~~
- ~~Identity Assertion~~
~~with~~
- ~~CLIENT-CERT,FORM~~
- ~~Identity Assertion~~
- ~~/login.html~~
- ~~/error.html~~

- Enable Automation run : set following to true (default: false)
  - oracle.adf.view.rich.automation.ENABLED
  - org.apache.myfaces.trinidad.DISABLE_CONTENT_COMPRESSION

Run the following sql query

1. delete from fnd_grants where module_id in (select module_id from fnd_appl_taxonomy where product_code = 'FA')

And then from a view run the following after editing the DB details (note the order is very important):

2.
 java -cp
$MW_HOME/oracle_common/modules/oracle.odl_11.1.1/ojdl.jar:$MW_HOME/oracle_common/modules/oracle.xdk_11.1.0/xmlparserv2.jar:$ADE_VIEW_ROOT/fusionapps/jlib/AdfAtkQueryBuilderProtectedModel.jar:$ADE_VIEW_ROOT/fusionapps/jlib/AdfAtkQueryBuilderPublicService.jar:$JDEV_HOME/jdev/oaext/lib/oracle.apps.fnd.applseed-rt.jar
 oracle.apps.fnd.applseed.rt.loader.Loader -am
oracle.apps.fnd.applcore.dataSecurity.dataSecurityService.applicationModule.DataSecurityAM
 -dburl jdbc:oracle:thin:@slc08zag.us.oracle.com:1522:slc08zag -dbuser fusion -file $AVR/fusionapps/fin/fa/noship/cdrautoapply/db/data/Run_1_FndGrantsSD.xml

(password is fusion when prompted.)

3.
 java -cp
$MW_HOME/oracle_common/modules/oracle.odl_11.1.1/ojdl.jar:$MW_HOME/oracle_common/modules/oracle.xdk_11.1.0/xmlparserv2.jar:$ADE_VIEW_ROOT/fusionapps/jlib/AdfAtkQueryBuilderProtectedModel.jar:$ADE_VIEW_ROOT/fusionapps/jlib/AdfAtkQueryBuilderPublicService.jar:$JDEV_HOME/jdev/oaext/lib/oracle.apps.fnd.applseed-rt.jar
 oracle.apps.fnd.applseed.rt.loader.Loader -am
oracle.apps.fnd.applcore.dataSecurity.dataSecurityService.applicationModule.DataSecurityAM
 -dburl jdbc:oracle:thin:@slc08zal.us.oracle.com:1522:slc08zal -dbuser fusion -file $AVR/fusionapps/fin/fa/noship/cdrautoapply/db/data/R11_demo_FndGrantsSD.xml.

change dB name in above command.
(password is fusion when prompted.)

4.Script on DB

set serveroutput on
Declare
cnt number:= 0;
BEGIN
For i in (select rl.role_name, rl.role_guid from fnd_session_roles rl )
LOOP
Update fnd_grants set grantee_key = i.role_guid where role_name = i.role_name
and grantee_key != i.role_guid;
cnt := cnt + SQL%ROWCOUNT;
END LOOP;
dbms_output.put_line('update cnt '|| cnt);
END;

 After performing the above 3 steps bounce the server

Deploy Flex

Connect to DB from view
- sqlplus fusion/fusion@slcak359.us.oracle.com:1577/ems10955
- set head off
- spool deployFlex.py
- select 'deployFlex('''||key_flexfield_code ||''',''KFF'');' from fnd_kf_flexfields_b where deployment_status not like 'DEPLOYED';
- select 'deployFlex('''||descriptive_flexfield_code ||''',''DFF'');' from fnd_df_flexfields_b where deployment_status not like 'DEPLOYED' and flexfield_type = 'DFF';
- select 'deployFlex('''||descriptive_flexfield_code ||''',''EFF'');' from fnd_df_flexfields_b where deployment_status not like 'DEPLOYED' and flexfield_type = 'EFF';
- spool off
Edit deployFlex.py,delete sql and result message, add below line at top and "exit();" at bottom
- connect("weblogic","weblogic1","t3://:");
$MW_HOME/oracle_common/common/bin/wlst.sh deployFlex.py | tee deployFlex.log
Review deployFlex.log for any flexfield deployment errors
Know issues:
1) How to setup a Standalone SMC Server#FlexIssues
2) Fixed Assets - Local SMC Deployment Steps

3) Drop policy of your object which reported errors

select * from all_policies where object_name = 'PER_ADDRESSES_F'-- 'XLA_TRANSACTION_ENTITIES' 'PER_ADDRESS_PII_VPD'

declare

BEGIN

DBMS_RLS.DROP_POLICY('FUSION', 'PER_ADDRESSES_F', 'PER_ADDRESS_PII_VPD');

-- 'HCM_STATIC_VPD_BGID_POLICY');

end;

--replace the object name with yours

FSM WorkAround

Populate Topology ASK tables

SMCTopologyEndPoint.sql Change host to your host.

Provisioning the Financials Offering

insert into ask_deployed_provision_configs (ID,APPLICATION_CLOUD_ID,PROVISION_CONFIG_ID,OBJECT_VERSION_NUMBER,ENTERPRISE_ID,CREATION_DATE, CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,SELECTED) values (100000,(select id from ask_application_clouds ac inner join ask_topology_information ti on ac.short_name = ti.value where ti.name='ENVIRONMENT'), (select pc.provision_config_id from ask_provision_configurations pc inner join asm_filter_options_vl fo on pc.provision_config_shortname=fo.provision_config_short_name where fo.filter_id=(select filter_id from asm_filters_vl where filter_name like 'Financials')), 0,2,sysdate,'TEST_USER','TEST_USER',sysdate,null,'Y');

FSM KSS Setup (Client/Server)

Generate AdminServerclient.cer and Installing it.

mkdir -p $AVR/rtf && cd $AVR/rtf && cp -R /ade_autofs/ud62_fa/FSM_MAIN_GENERIC.rdd/LATEST/fsm/asm/noship/scripts/rtf .
cd rtf/
sh setupConsumerKSS.sh $MW_HOME/oracle_common/common/bin .   weblogic weblogic1 /scratch//fusion_domain
sh setupProducerKSS.sh $MW_HOME/oracle_common/common/bin AdminServerclient.cer   weblogic weblogic1 /scratch//fusion_domain

After that you can see one TrustServiceIdAsserter should got created under Providers i.e. Home >Summary of Security Realms >myrealm >Providers. You can see the screenshot below: (Refer to FSM Workaround)

Known issue:Unable to access tasks from FSM
Setup Export/Import:

Local deployment with SMC Topology#FSMExport/ImportSetu
~~The following modules must have URLs populated for testing Export/Import:~~
~~https://confluence.oraclecorp.com/confluence/display/FRE/Populating+Topology+Manager+Tables+for+Local+Testing~~

Run both pl/sql with below 2:

ORA_FSCM_SERVICE

ORA_FSCMPOJO
~~Queries to check on some of the updates in the below tables for your respective host, port and module names.~~

~~select * from ASK_ENTERPRISE_APPLICATIONS;~~
~~select * from ASK_DEPLOYED_APPLICATIONS;~~
~~select * from ASK_DEPLOYED_MODULES;~~
~~Restart server.~~

Caused by: oracle.wsm.security.SecurityException: WSM-00346 : There is no matching assertion found in the service side policy which can process the incoming message. Ensure that there is a compatible policy attached at the client side. Tokens found in the security header are:- null. Authentication mechanism found in the HTTP header:- null. The assertions found in the service side policy are:- WSSecurity SAML Token ,WSSecurity UserName Token .

Workaround:
Config GPA policy:
Disable below policies: Viewing and disable Policies as guidance https://confluence.oraclecorp.com/confluence/display/SE/PolicySets+Issue
ws-client
ws-service
sca-reference
ws-connection
ws-callback
sca-service
Add GPA policies in https://confluence.oraclecorp.com/confluence/display/~sudhakar.gottumukkala@oracle.com/Setting+Policies+for+Communicating+with+BIP
Don't delete all Policies, only disable above policies and add these new policies.

Reference for GPA Policy issues:
PolicySets Issue
Setting Policies for Communicating with BIP

4.rest

KSS Setup for working with JWT Tokens and Remote Regions

Integrate with BIP Server with ESS

BIP integration

Create XMLP Client Config
Create directory XMLPClientConfigDir under $HOME, and create a file with name xmlp-client-config.xml with following content:
- mkdir ~/XMLPClientConfigDir
- cd ~/XMLPClientConfigDir
- vi xmlp-client-config.xml
  
  < -?xml version="1.0" encoding="UTF-8"?>
  http://java.sun.com/dtd/properties.dtd">
  
  BIP Server Information
  http://slc10xki.us.oracle.com:9704/xmlpserver
  http://slc10xki.us.oracle.com:9704/xmlpserver
  ess.ws.epa">http://slc11frv.us.oracle.com:7011/ess/esswebservice
  remote
Make sure a data source is added to the BIP server connection.
To verify that, login to http:// :/xmlpserver/servlet/ with bi_admin/Welcome1.
Navigate to Administration -> JDBC Connection -> add data source.
Match the policy sets on both the Fusion Admin Server and BIP server.
The policies of the bip server and the ess server has to match. If they don't match, it might throw errors.
To resolve this run the following commands to recreate the policies - refer here.
Bounce server for changes to take effect
Verify Integration Result
We can verify the BIP and ESS integration by running job which submitted BIP report, like "General Ledger Trial Balance" report.
It should be completed successfully and output contains the correct results.

Proc Setup

If you refresh your view, you have to redo proc setup.

cd /scratch/, remove directory ess and all its sub-directories.
cd $ADE_VIEW_ROOT/fusionapps/fin/xla/noship/ess
ade mkprivate autoProCSetup.sh
gedit autoProCSetup.sh (replace USER_DIR_ESS="/tmp" with USER_DIR_ESS="/scratch/")
sh autoProCSetup.sh -p Welcome1 (this will read $HOME/fusion_apps_wls.properties to get domain and DB details and create environment.properties and required tns details for Pro C)
touch /scratch//ess/requestFileDirectory/tns_admin/wallet/ess_generated_11107 (As discussed with suresh.gopalan@oracle.com, this step creates 0 byte file ess_generated_11107 needed to skip wallet regeneration - which is resulting in "PreProcessing failed to generate wallet via ant" error for all Pro C jobs on local standalone)
In fusion_domain/bin/setDomainEnv.sh, add the content in bold to JAVA_OPTIONS line as JAVA_OPTIONS="${JAVA_OPTIONS} ${JAVA_PROPERTIES} -Dwlw.iterativeDev=${iterativeDevFlag} -Dwlw.testConsole=${testConsoleFlag} -Dwlw.logErrorsToConsole=${logErrorsToConsoleFlag} -Dess.config.dir=/scratch//ess/requestFileDirectory"
Bounce the server

Integrate with UCM

Config UCM Url

update files:

$DOMAIN_HOME/smcapps/EarFscmEssApp.ear/.ade_path/adf/META-INF/connections.xml

$DOMAIN_HOME/smcapps/EarFscmUIApp.ear/adf/META-INF/connections.xml

$DOMAIN_HOME=domainDir/domainName: refre to fusion_apps_wls.properties

e.g. /scratch/meiyu/SMCENV/fusion_domain/smcapps/EarFscmEssApp.ear/.ade_path/adf/META-INF/connections.xml
- Find the connection "FusionAppsContentRepository"
- Modify "oracle.stellent.jcr.configuration.server.web.url" content to use the URL as below:
  
            http://slc12ljs.us.oracle.com:16200/idcnativews
Add two permissions to System Jazn
- Navigate to $DOMAIN_HOME/config/fmwconfig/system-jazn-data.xml
- Under the tag of wsm-agent-core.jar,add entries for applications - ORA_FSCM_UIAPP, ORA_FSCM_ESSAPP
  e.g. common.components.home}/modules/oracle.wsm.agent.common_11.1.1/wsm-agent-core.jar
  
  file:${common.components.home}/modules/oracle.wsm.agent.common_11.1.1/wsm-agent-core.jar
  
  ...
  
  ...         custom
  
            1.0
  
      oracle.wsm.security.WSIdentityPermission
  
            resource=ORA_FSCM_UIAPP
  
           assert
  
          custom
  
         1.0
  
         oracle.wsm.security.WSIdentityPermission
  
         resource=ORA_FSCM_ESSAPP
  
         assert

Notes:If you want run "Load Interface File for Import",please finish "Proc setup" first.

Set policies for Fusion Domain - refer here.

Deploying changes to Standalone

Generate merged jar

We use merged jars in SMC, hence you need to generate the merged jar

generate the normal jar from jdev in your view (Note: Please deploy all the deployment profiles for the project else the changes do not get merged correctly into merged jar. Example: For Model if you have Adf, Svc*MiddleTier and Svc*Common deployment profiles to generate the respective jars, then generate all the 3 of them)
From command line generate the merged jar. For more options refer Steps to produce a Merged Jar File

- Sample command to generate merge jar:
  - ant produceMergedJar -DmergedJarLocation=$ADE_VIEW_ROOT/fusionapps –DjarTobeMerged=fin/components/ledger/jlib/AdfFinFunIntercoTransactionsModel.jar

Copy jars built from jdev to the jlib folder in the view which used to produce merged jar. Then run above command to generate merged jar.

e.g.

Copy all jars to /scratch/hruan/view_storage/hruan_wangx/fusionapps/jlib/fscm folder, then run below command to generate merged UI jar.

ant produceMergedJar -DmergedJarLocation=$ADE_VIEW_ROOT/fusionapps –DjarTobeMerged=/scratch/hruan/view_storage/hruan_wangx/fusionapps/jlib/fscm/AdfFinFaTrackAssetInquiryPublicUi.jar

Deploy merged jar

Copy the merged jar to the /smcapps/ to the respective ear and
Bounce the server

Config Domain for REST

Refer to How to create a REST resource and test on IWSL - 10. Deploy Standalone domain.

Setup SOA

Generate SOA shared mar file

cd $AVR/fusionapps
ant -f build.xml prepare_soa_shared_repository
Generate AppInfo.xml under $AVR/fusionapps

ant -f build.xml generateSOAEnvironment

Modify AppInfo.xml
Below is a code snippet from AppInfo.xml.

Replace with your soa-infra url, e.g. http://slc09yar.us.oracle.com:7012/soa-infra.
Replace ProductManagementSoa HOST/PORT with your SOA App Host Name & SOA PORT, e.g. host name: slc09yar.us.oracle.com, port: 7012.
Replace ProductManagement & ProductManagementCommon & ProductLifecycleManagement HOST/PORT with your ADF App Host Name and Port.

<?xml version="1.0" encoding="UTF-8"?>
<EnvironmentInfo>
    <TargetServerInfo serverUrl="" user="weblogic" password="weblogic1" />
    <ApplicationInfo application="ProductManagementCommon" host="" port="<PORT>" protocol="http" />
    <ApplicationInfo application="ProductManagement" host="" port="<PORT>" protocol="http" />
    <ApplicationInfo application="ProductLifecycleManagement" host="" port="<PORT>" protocol="http" />
    <ApplicationInfo application="ProductManagementSoa" host="" port="<SOAPORT>" protocol="http" />
EnvironmentInfo>

Generate Deploy Plan by AppInfo.xml under the same folder

ant -f build.xml generateSOADeployPlan -Ddeploy.appinfo=AppInfo.xml
Start SOA managed server

cd $MW_HOME_STANDALONE/user_projects/domains/<DOMAIN_NAME>/bin
./startManagedWebLogic.sh ESS_SOAServer_1

Deploy SOA shared zip

ant -f $JDEV_HOME/bin/ant-sca-deploy.xml -DserverURL=http://slc08yla.us.oracle.com:8011 -DsarLocation=$ADE_VIEW_ROOT/fusionapps/jlib/soa_shared.zip -Duser=weblogic -Dpassword=weblogic1 -Dtimeout=100000000

import metadata

$MW_HOME/oracle_common/common/bin/wlst.sh
connect("weblogic","weblogic1","t3://slc11frv.us.oracle.com:7011");

importMetadata(application='ORA_FSCM_UIAPP',server='AdminServer',fromLocation='/scratch/xuanwan/view_storage/xuanwan_smcdomain08/fusionapps/soa_shared/soa-infra/apps',docs='/oracle/apps/financials/expenses/entry/shared/flex/**')
importMetadata(application='ORA_FSCM_UIAPP',server='AdminServer',fromLocation='/scratch/xuanwan/view_storage/xuanwan_smcdomain08/fusionapps/soa_shared/soa-infra/apps',docs='/oracle/apps/financials/generalLedger/accounts/codeCombinations/publicFlex/**')
importMetadata(application='ORA_FSCM_UIAPP',server='AdminServer',fromLocation='/scratch/xuanwan/view_storage/xuanwan_smcdomain08/fusionapps/soa_shared/soa-infra/apps',docs='/oracle/apps/hcm/people/core/personService/**')
importMetadata(application='ORA_FSCM_UIAPP',server='AdminServer',fromLocation='/scratch/xuanwan/view_storage/xuanwan_smcdomain08/fusionapps/soa_shared/soa-infra/apps',docs='/oracle/apps/hcm/people/core/flex/**')

Deploy Change Management Composites

Be careful with the name and path of Deploy Plan file. It's located under $AVR/fusionapps and named as deployPlan.xml.

ant -f $JDEV_HOME/bin/ant-sca-deploy.xml deploy -DserverURL=http://slc08yla.us.oracle.com:8011 -Duser=weblogic -Dpassword=weblogic1 -Doverwrite=true -DforceDefault=true -Dconfigplan=deployPlan.xml -DsarLocation=fin/deploy/sca_FinExmWorkflowExpenseApprovalComposite.jar ant -f $JDEV_HOME/bin/ant-sca-deploy.xml deploy -DserverURL=http://slc08yla.us.oracle.com:8011 -Duser=weblogic -Dpassword=weblogic1 -Doverwrite=true -DforceDefault=true -Dconfigplan=deployPlan.xml -DsarLocation=fin/deploy/sca_FinApInvTransactionsInvoiceApprovalComposite.jar ant -f $JDEV_HOME/bin/ant-sca-deploy.xml deploy -DserverURL=http://slc08yla.us.oracle.com:8011 -Duser=weblogic -Dpassword=weblogic1 -Doverwrite=true -DforceDefault=true -Dconfigplan=deployPlan.xml -DsarLocation=fin/deploy/sca_FinCollActivityManagementComposite.jar ant -f $JDEV_HOME/bin/ant-sca-deploy.xml deploy -DserverURL=http://slc08yla.us.oracle.com:8011 -Duser=weblogic -Dpassword=weblogic1 -Doverwrite=true -DforceDefault=true -Dconfigplan=deployPlan.xml -DsarLocation=fin/deploy/sca_FinGlJrnlEntriesApprovalComposite.jar

Where to find domain log

1. Review the incident log to find the errors and warnings.

Path: /servers/AdminServer/adr/diag/ofm/fusion_domain/AdminServer/incident//readme.txt

e.g. /scratch/hruan/SLC11FRVSMCENV/fusion_domain/servers/AdminServer/adr/diag/ofm/fusion_domain/AdminServer/incident/incdir_14/readme.txt

2. Ess log Path: /scratch/hruan/SLC11FRVSMCENV/fusion_domain/servers/AdminServer/logs/ess_request

Troubleshooting

This section collects all issue and solutions which may met during deployments.

Issue:

With FUSIONAPPS_PT.V2MIBFIND_LINUX.X64 and 013117 DB template, if you hit RuntimeStoreCompatibilityException: Runtime store compatibility check failed; check version: 2.0.0.1_0.0, runtime store version: 2.0.0.0_0.8, schema name: FUSION_ORA_ESS (in server log and deploy log).

Root Cause:

Mismatch of ESS schema between App and DB.

Resolution:

Upgrade ESS Schema

Issue:

For FA, Book LOV is null in the assets landing page

Resolution:

Run the following sql query
  
1. delete from fnd_grants where module_id in (select module_id from fnd_appl_taxonomy where product_code = 'FA')
  
And then from a view run the following after editing the DB details (note the order is very important):
  
2.
 java -cp
$MW_HOME/oracle_common/modules/oracle.odl_11.1.1/ojdl.jar:$MW_HOME/oracle_common/modules/oracle.xdk_11.1.0/xmlparserv2.jar:$ADE_VIEW_ROOT/fusionapps/jlib/AdfAtkQueryBuilderProtectedModel.jar:$ADE_VIEW_ROOT/fusionapps/jlib/AdfAtkQueryBuilderPublicService.jar:$JDEV_HOME/jdev/oaext/lib/oracle.apps.fnd.applseed-rt.jar
 oracle.apps.fnd.applseed.rt.loader.Loader -am
oracle.apps.fnd.applcore.dataSecurity.dataSecurityService.applicationModule.DataSecurityAM
 -dburl jdbc:oracle:thin:@slc08zag.us.oracle.com:1522:slc08zag -dbuser fusion -file $AVR/fusionapps/fin/fa/noship/cdrautoapply/db/data/Run_1_FndGrantsSD.xml
  
(password is fusion when prompted.)
  
3.
 java -cp
$MW_HOME/oracle_common/modules/oracle.odl_11.1.1/ojdl.jar:$MW_HOME/oracle_common/modules/oracle.xdk_11.1.0/xmlparserv2.jar:$ADE_VIEW_ROOT/fusionapps/jlib/AdfAtkQueryBuilderProtectedModel.jar:$ADE_VIEW_ROOT/fusionapps/jlib/AdfAtkQueryBuilderPublicService.jar:$JDEV_HOME/jdev/oaext/lib/oracle.apps.fnd.applseed-rt.jar
 oracle.apps.fnd.applseed.rt.loader.Loader -am
oracle.apps.fnd.applcore.dataSecurity.dataSecurityService.applicationModule.DataSecurityAM
 -dburl jdbc:oracle:thin:@slc08zal.us.oracle.com:1522:slc08zal -dbuser fusion -file $AVR/fusionapps/fin/fa/noship/cdrautoapply/db/data/R11_demo_FndGrantsSD.xml.
  
(password is fusion when prompted.)
  
After performing the above 3 steps bounce the server

Issue:

Out of Memory issues

Resolution:

1. ./startWebLogic.sh –Xmx4096m –Xms1024m

2. IMP: Please do these steps from the terminal where the apps needs to installed

Check current max heap size
echo $ANT_OPTS
-Xmx1536M -XX:MaxPermSize=384M
Increase max heap size

setenv ANT_OPTS "`echo $ANT_OPTS | sed 's/Xmx1536M/Xmx3072M/g'`"
Check updated max heap size

Issue:

Cannot find '$MW_HOME/oracle_common/common/bin/wlst.sh' command

Resolution:

Remove FMWTOOLS:

e.g.

cd /scratch/software/mw_local/

rm -r FMWTOOLS_11.1.1.9.1_GENERIC_160712.1219_PATCHES4FA_11.1.13.0.0_PLATFORMS_JDK64

Issue:

sh: /tmp/ess/requestFileDirectory/bin/./XLAENG: No such file or directory

Resolution:

Redeploy ProC

Issue:

If your console shows ORA_FSCM_UIAPP and you are unable to access tasks from FSM even after performing all the needed setup.

Root Cause:

The fusion_domain/smcapps/EarFscmUIApp.ear/adf/META-INF/connections.xml contains ORA_FSCM_UIAPPInternalProtocol / ORA_FSCM_UIAPPInternalHost / ORA_FSCM_UIAPPInternalPort.The MDS does not contain these entries.

Resolution:

1. replace: ${adfDomainConfig.oraclefusionapps.ORA_FSCM_UIAPPInternalProtocol}://${adfDomainConfig.oraclefusionapps.ORA_FSCM_UIAPPInternalHost}:${adfDomainConfig.oraclefusionapps.ORA_FSCM_UIAPPInternalPort} with the specific host

under your domain home /smcapps/EarFscmUIApp.ear/adf/META-INF/connections.xml

2. Refer Fixing Multi Domain DB Issue And Fix SMC FSM Taskflows to export from MDS, add missing ORA_FSCM_UIAPPInternalProtocol / ORA_FSCM_UIAPPInternalHost / ORA_FSCM_UIAPPInternalPort to adf-domain-config.xml and import back to MDS to resolve the issue.

Replace application from 'EarFscmUIApp' to 'ORA_FSCM_UIAPP'.

e.g.

exportMetadata(application='ORA_FSCM_UIAPP',server='AdminServer',toLocation='/scratch/mds_dumps',docs='/oracle/adf/META-INF/**')

importMetadata(application='ORA_FSCM_UIAPP',server='AdminServer',fromLocation='/tmp/mdsmenu.zip',docs='/**')

Issue:

FPR failed with AM not found errors.

Root Cause:

The AM is new created and not copied to the fpr server.

Resolution:

How to copy Jars to FPR server machine

You can generate an ear and copy to fpr server.

Generate ear command:

e.g. ant build -f build-ledger.xml | tee fullbuild.log

ant ear -f build-ledger.xml | tee earbuild.log

Issue:

CSV import/export don't work. Naviagate to Manage Task Lists and Tasks page will pop up ORA-00904: "LOOKUPPEO"."TAG": invalid identifier error message.

Root Cause:

FND_LOOKUP_VALUES_VL table misses TAG column.

Resolution:

How-to Alter a View in DB

"Error 500--Internal Server Error

oracle.jbo.NoXMLFileException: JBO-29114 ADFContext is not setup to process messages for this exception. Use the exception stack trace and error code to investigate the root cause of this exception. Root cause error code is JBO-26001. Error message parameters are {0=/dummybindings/DataBindings.cpx}"

The following workaround has been suggested

1) Create folder /tmp/dummybindings and copy the attached file to this folder.

DataBindings.cpx

2) Upload it to the db importMetadata(application= 'ORA_FSCM_UIAPP' ,server= 'AdminServer' ,fromLocation= '/tmp' ,docs= '/dummybindings/DataBindings.cpx')

3) Bounce the server

Issue:

Run open period, ess job has error.

/scratch/xuanwan/ess/requestFileDirectory/bin/./GLOOAP: error while loading shared libraries: libgl.so: cannot open shared object file: No such file or director

Root Cause:

That is due to stale libgl.so

Resolution:

Refresh view associated with your standalone and check that fusionapps/lib/linuxx64 contains a valid libgl.so

Issue:

REST: client lov keeps loading.

Domain log:

WARNING: WSM-00442 The jwt token found in the request,
Encoded token: http:// eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsIng1dCI6IjZHQWwwUmZyVHdzM0gwSnlGNVNQX2kzQ3VrSSIsImtpZCI6InRydXN0c2VydmljZSJ9.eyJleHAiOjE1MjgxMDI5NDcsInN1YiI6IkZJTl9VU0VSMSIsImlzcyI6Ind3dy5vcmFjbGUuY29tIiwicHJuIjoiRklOX1VTRVIxIiwiaWF0IjoxNTI4MDg4NTQ3fQ.Dr5aXOu6extutJcOmNMWmdqtgFp8HnXAQJIUv20vaBplbl2xlH1Up3QV1uypSJmagcAKZt8BvYFCKyckE3TwxxQmXzBvPRGt3-4SwhxUUxipLEXiJMxSV9z2xd-I4aMgRvfZfoO-v7Pna1E-0SKPgS93NhaQVjbMixTd887NHSk
Decoded token: [ JWT:-
Header Segment:-
{"alg":"RS256","typ":"JWT","x5t":"6GAl0RfrTws3H0JyF5SP_i3CukI","kid":"trustservice"}
Claim Segment:-
{"exp":1528102947,"sub":"FIN_USER1","iss":"www.oracle.com","prn":"FIN_USER1","iat":1528088547} ]
is invalid and token authentication failed
INFO: WSM-00328 Incoming request did not have a valid authentication token. Service will send a 401 Challenge in response to the client with WWW-Authenticate header.

Root Cause and Resolution:

http://myforums.oracle.com/jive3/thread.jspa?threadID=2598005&tstart=45

Issue:

fpr error

/ade_autofs/ade_infra/FATOOLS_MAIN_LINUX.rdd/LATEST/fatools/fre/bin/fpr -e ems9169 -s FUSIONAPPS_PT.V2MIBFPHDEV_LINUX.X64_190128.1700.S -p V_OWNER_FAMILY=fin V_CONT_EQUIV=NO V_APPROVED_AUTOAPPLY=NO
Can't load '/tmp/par-xuanwan/temp-16712/f05jdPfTjc.none' for module Math::BigInt::GMP: libgmp.so.3: cannot open shared object file: No such file or directory at /central/fusioncommon/RELEASE/stage/frePerl/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at /central/fusioncommon/RELEASE/stage/frePerl/lib/perl5/site_perl/5.8.8/PAR/Heavy.pm line 109
Compilation failed in require at fprRemoteConnection.pm line 155.
BEGIN failed--compilation aborted at fprRemoteConnection.pm line 155.
Compilation failed in require at fprInstanceValidation.pm line 28.
BEGIN failed--compilation aborted at fprInstanceValidation.pm line 28.
Compilation failed in require at script/fpr line 261.
BEGIN failed--compilation aborted at script/fpr line 261.

Root cause:

It looks like only have 64bit files doesn't work.

/usr/lib64/libgmp.so.3
/usr/lib64/libgmp.so.3.5.0

resolution¿

No matter libgmp.so.3 or libgmp.so.1 are missing, just copy one from other vm.

In this case, copied libgmp.so.3 and libgmp.so.3.5.0 from other vm to local /usr/lib/

Issue:

BIP: Cannot run report.

Root Cause and Resolution:

The report is not allowed to run. Edit the report and go into its properties, check the 'Run Report Online' option and save. Return to the Catalog, the report could be run with the open action.

Necessary verification after deployment: