Recreate the Oracle E-Business Suite (EBS) WLS (WebLogic Server) Domain

In order to have the EBS WLS domain recreated please do the following after taking a full backup of your environment:

1. In the Database Tier do the following:

    1.1. Log into the database tier.
    1.2. Source the environment.

    1.3  Ensure that database and listener are up and running. 

2. In the Applications Tier do the following:

    2.1. Source the RUN file system environment.
    2.2. Stop all middle tier services using $ADMIN_SCRIPTS_HOME/adstpall.sh.
    2.3. Ensure that no process is running from RUN file system.
    2.4. Take a backup of the context file.  Update s_adminservertimeout context variable value to 4000 and run AutoConfig.

    2.5. Execute below command:

        $ $FND_TOP/bin/txkrun.pl -script=ChkEBSDependecies -server=ALL_SERVERS

   Below prompts are shown by the script:

Enter the full path of Applications Context File [DEFAULT - ]: Complete path of the RUN context file
Enter the server start mode for the domain [DEFAULT - prod]: prod
Enter the APPS schema password :
Enter weblogic admin server password :

    Output(example):- 

      SUCCESS: VALID FMW HOME /u03/oracle/PROD/fs1/FMW_Home
      SUCCESS: VALID OHS HOME /u03/oracle/PROD/fs1/FMW_Home/webtier
      SUCCESS: VALID Node Manager Port 5553

      SUCCESS: VALID Node Manager Type plain
      SUCCESS: VALID Admin Server Port 7001
      SUCCESS: VALID OACORE Managed Server Port 7201
      SUCCESS: VALID FORMS Managed Server Port 7401
      SUCCESS: VALID OAFM Managed Server Port 7605
      SUCCESS: VALID FORMS-C4WS Managed Server Port 7807
      SUCCESS: VALID JRF TEMPLATE /u03/oracle/PROD/fs1/FMW_Home/oracle_common/common/templates/applications/jrf_template_11.1.1.jar
      SUCCESS: VALID EM TEMPLATE /u03/oracle/PROD/fs1/FMW_Home/oracle_common/common/templates/applications/oracle.em_11_1_1_0_0_template.jar
      SUCCESS: VALID EM EBS PLUGIN TEMPLATE /u03/oracle/PROD/fs1/FMW_Home/Oracle_EBS-app1/common/templates/applications/oracle.emai_ebs_template_11.1.1.jar
      SUCCESS: VALID UIX LIBRARY /u03/oracle/PROD/fs1/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix11.war
      SUCCESS: VALID PORTLET TEMPLATE /u03/oracle/PROD/fs1/FMW_Home/oracle_common/common/templates/applications/oracle.portlet_component_template_11.1.1.jar
      SUCCESS: VALID OWSM TEMPLATE /u03/oracle/PROD/fs1/FMW_Home/oracle_common/common/templates/applications/oracle.wsmpm_template_11.1.1.jar

    2.6. Recreate the domain by following below steps:  

        $ cd $FND_TOP/patch/115/bin
        $ perl txkEBSDomainConfig.pl

    2.7. Start the services and check the WLS domain is fine. 

Note:- when running txkEBSDomainConfig.pl you will be prompted "Enter the server start mode for the domain [DEFAULT - prod]:".Choose the default value of prod. Oracle Web Logic Server can be run in two different modes, either prod or dev, and the recommended option is to choose prod as it is safer. The dev mode allows to deploy unsigned java classes but is quicker than prod.

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only

Not able to login EBS Application || ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_WEB_SEC"

    Not able to login EBS application after applying Oct CPU patch 

SYMPTOMS

After apply Oct 2022 CPU patch, user not able to change user password through FNDCPASS  

 APP-FND-01564: ORACLE error 4063 in check_apps_parm

ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_WEB_SEC"

The SQL statement being executed at the time of the error was: begin :r := nvl(fnd_web_sec.get_op_value(:u,:p),'**##_NuLl_##**'); end; and was executed from the file &ERRFILE.

CHANGES

Applying patch OCT 2022 CPU to Release 12.2.4

CAUSE

FND_WEB_SEC package body is invalid

OWNER                          OBJECT_NAME                    OBJECT_TYPE                    STATUS
------------------------------ ------------------------------ ------------------------------ -------

APPS                           FND_WEB_SEC                    PACKAGE BODY                   INVALID
                          

Package body compiled with below error:

QL> alter package FND_WEB_SEC compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY FND_WEB_SEC:

LINE/COL ERROR
-------- -----------------------------------------------------------------
27/15 PL/SQL: Item ignored
27/30 PLS-00201: identifier 'DBMS_CRYPTO' must be declared
214/2 PL/SQL: Statement ignored
214/31 PLS-00201: identifier 'DBMS_CRYPTO' must be declared
216/2 PL/SQL: Statement ignored
216/31 PLS-00201: identifier 'DBMS_CRYPTO' must be declared
SQL>

Execute privilege on DBMS_CRYPTO to apps is missing due to which package body is invalid.

SOLUTION

1. grant execute on DBMS_CRYPTO to apps;

2. Compile the package body

alter package APPS.FND_WEB_SEC compile body;