2015112919PM-FSM Deployment In Local Environment

Intention: FSM Deployment in local environment, and setting up ledger end points, so that you can run Ledger application related tasks from your local FSM setup.

Setting end points for ledger app in database using following script:

SET SERVEROUT ON;
DECLARE
  l_return_status VARCHAR2(100);
  l_msg_count     NUMBER;
  l_msg_data      VARCHAR2(2000);

  CURSOR get_module_list(c_app_short_name VARCHAR2) IS
  SELECT module_short_name,  module_name, context_root
    FROM ask_modules m, ask_enterprise_applications a
   WHERE m.enterprise_application_id = a.enterprise_application_id
     AND a.short_name = c_app_short_name;

  l_module get_module_list%rowtype;
  l_app_short_name ASK_ENTERPRISE_APPLICATIONS.SHORT_NAME%TYPE  := 'LedgerApp';
  l_app_host ASK_DEPLOYED_APPLICATIONS.HOST%TYPE := 'slc05aqn.us.oracle.com'; --change host name to your ledger app host and port to ledger app port number.
  l_app_port ASK_DEPLOYED_APPLICATIONS.PORT%TYPE := '7015';

BEGIN

   IF get_module_list%ISOPEN THEN
      CLOSE get_module_list;
   END IF;

   OPEN get_module_list(l_app_short_name);
   FETCH get_module_list INTO l_module;

   WHILE get_module_list%FOUND LOOP

      ASK_TOPOLOGY_MANAGER.populate_end_point (
         logical_module_short_name => l_module.module_short_name
       , deployed_protocol => 'http'
       , deployed_host => l_app_host
       , deployed_port => l_app_port
       , deployed_context_root => l_module.context_root
       , deployed_module_name => l_module.module_name
       , environment_short_name => NULL
       , x_return_status => l_return_status
       , x_msg_count => l_msg_count
       , x_msg_data => l_msg_data
      );

      IF (l_return_status = ASK_TOPOLOGY_MANAGER.G_RET_STS_SUCCESS) THEN
        DBMS_OUTPUT.PUT_LINE('SUCCESS: ' || l_msg_data);
      ELSE
        DBMS_OUTPUT.PUT_LINE('ERROR: ' || l_msg_data);
      END IF;

      FETCH get_module_list INTO l_module;
    END LOOP;
    CLOSE get_module_list;
END;
 

 

FSM Deployment Steps:

Step 1: a) In fusion_apps_properties.xml file. Set domain type as 'adminessadf' and ESSrunTime properties as 'Yes'. Create fresh domain for FSM. Bring up the admin server and ess_server1.
b) In weblogic console > Security Realms > myrealm > Providers > DefaultAuthenticator > Migration > Import > Import File on Server > $ADE_VIEW_ROOT/fatools/global/ldap/WLS_Users_and_Groups.ldift > Save

Step 2: FSMSetp ear is present under directory '$MW_HOME_STANDALONE/atgpf/fsm/modules/oracle.setup'.
Update property 'jps.policystore.migration' from OVERWRITE to MERGE in weblogic-application.xml file of Setup4Mat.ear and SetupEss4Mat.ear   

Update connection.xml (under adf/META-INF) file in Setup4Mat.ear file,

• Replace all occurrences of "${adfDomainConfig.oraclefusionapps.LedgerAppInternalProtocol}" with "http"
• Replace all occurrences of  "${adfDomainConfig.oraclefusionapps.LedgerAppInternalHost}" with Ledger App Hostname
• Replace all occurrences of "${adfDomainConfig.oraclefusionapps.LedgerAppInternalPort}" with Ledger App port

Use following command to open ear archive:  file-roller Setup4Mat.ear

Step 3:  Deploy Setup ear to Admin server:
Under Deployments > Install > $MW_HOME_STANDALONE/atgpf/fsm/modules/oracle.setup/Setup4Mat.ear > Deploy the ear as an application with name as 'SetupApp'. Make sure to select Target as Admin Server.

Step 4: Deploy SetupEss ear to Ess Server:

Under Deployments > Install > $MW_HOME_STANDALONE/atgpf/fsm/modules/oracle.setup/SetupEss4Mat.ear > Deploy the ear as an application with name as 'SetupEssApp'. Make sure to select Target as ess_server1

Step 5: Update roles in weblogic console
Security Realms > myrealm > Users and Groups > Customize the table to get APPLICATION_IMPLEMENTATION_CONSULTANT > Click on the User and under 'Groups' tab, add ASM_APPLICATION_IMPLEMENTATION_CONSULTANT_JOB, PER_EMPLOYEE_ABSTRACT, Administrators roles for this user > Save.

Step 6: Copy RTF scripts (just run following commands)

cd $MW_HOME_STANDALONE

mkdir scripts

cd scripts

cp -r /ade_autofs/ud21_fa/FSM_MAIN_GENERIC.rdd/LATEST/fsm/asm/noship/scripts/rtf/* .

sh setupConsumerKSS.sh $MW_HOME_STANDALONE/oracle_common/common/bin <certificate export directory> <host name> <port> <username> <password> $MW_HOME_STANDALONE/user_projects/domains/<domain name>

 

Sample command for exporting certificate:
sh setupConsumerKSS.sh $MW_HOME_STANDALONE/oracle_common/common/bin /scratch/andhiman/ slc00sro.us.oracle.com 7015 weblogic weblogic1 $MW_HOME_STANDALONE/user_projects/domains/fusion_domain_all

Step 7: Create New Authentication provider:

Navigate to "Security Realms (bottom of page) > myrealm > Providers (tab). Click 'Add' to add a new authentication provider. On the next screen enter Name as 'TrustServiceIdAsserter' and select a type as TrustServiceIdentityAsserter from the drop down. Restart the servers.

Step 8: Move .cer file from FSM server host to ledger app server host.

 

Steps to be performed on Ledger Server:

Step 1: Copy RTF scripts (just run following commands)

cd $MW_HOME_STANDALONE

mkdir scripts

cd scripts

cp -r /ade_autofs/ud21_fa/FSM_MAIN_GENERIC.rdd/LATEST/fsm/asm/noship/scripts/rtf/* .

sh setupProducerKSS.sh $MW_HOME_STANDALONE/oracle_common/common/bin <Certificate location of AdminServerclient.cer> <hostname> <port> <weblogic console username> <weblgic conosole password> $MW_HOME_STANDALONE/user_projects/domains/<domain name>

 

Sample command to import certificate:

sh setupProducerKSS.sh $MW_HOME_STANDALONE/oracle_common/common/bin /scratch/andhiman/AdminServerclient.cer slc05aqn.us.oracle.com 7011 weblogic weblogic1 $MW_HOME_STANDALONE/user_projects/domains/fusion_domain

Step2: Restart Sever

 

 

Known Issue:

If you face below error related to skin:
Remote Region error #1: Producer at "/ledger/rr/" does not have a skin that matches this consumer. Consumer skin information: {'id':'alta-v1.desktop','family':'alta','version':'v1','renderkit':'org.apache.myfaces.trinidad.desktop','documentId':'pc76z6', >

Then change skin to 'skyros' using following command:
UPDATE fnd_profile_option_values SET profile_option_value = 'skyros' WHERE profile_option_id IN (SELECT profile_option_id
 FROM fnd_profile_options WHERE profile_option_name LIKE 'FND_CSS_SKIN_FAMILY' );

 

 

Reference Links:

https://stbeehive.oracle.com/teamcollab/wiki/RTF+Documentation:Steps+to+create+local+standalone+test+cases+for+RTF+Testing