How to change the apps password in Oracle E-Business Suite R12.2

Below steps to change the apps password in Oracle E-Business Suite R12.2

Step 1:

Shut down all the application services by using below script.
$INST_TOP/admin/scripts/adstpall.sh

Step 2:
Change the APPLSYS password by using FNDCPASS
$FNDCPASS apps/<appspwd> 0 Y system/manager SYSTEM APPLSYS WELCOME

Step 3:
Run autoconfig with the newly changed password.

Step 4:
Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh script. (Do not start any other application tier services).

Step 5:
Change the "apps" password in WLS Datasource as follows:

a) Log in to WLS Administration Console.
b) Click Lock & Edit in Change Center.
c) In the Domain Structure tree, expand Services, then select Data Sources.
d) On the "Summary of JDBC Data Sources" page, select EBSDataSource.
e) On the "Settings for EBSDataSource" page, select the Connection Pool tab.
f) Enter the new password in the "Password" field.
g) Enter the new password in the "Confirm Password" field.
h) Click Save.
i) Click Activate Changes in Change Center.

Step 6:
Start all the application tier services using the below script
$INST_TOP/admin/scripts/adstrtal.sh

Step 7:
Verify the WLS Datastore changes as follows:

a) Log in to WLS Administration Console.
b) In the Domain Structure tree, expand Services, then select Data Sources.
c) On the "Summary of JDBC Data Sources" page, select EBSDataSource.
d) On the "Settings for EBSDataSource" page, select Monitoring > Testing.
e) Select "oacore_server1".
f) Click Test DataSource
g) Look for the message "Test of EBSDataSource on server oacore_server1 was successful".

weblogic.nodemanager.common.ConfigException: Identity key store file not found: DemoIdentity.jks (SOA 12c)

We are getting below error while starting Node-manager in weblogic 12c server. Below is the steps to resolve the issue.

Error Message:

+ /usr/java/jdk1.8.0_112/bin/java -server -Xms32m -Xmx200m -Dweblogic.RootDirectory=/u01/soa_12c/Middleware/MW_Home/wlserver/../oracle_common/common/nodemanager -Dcoherence.home=/u01/soa_12c/Middleware/MW_Home/wlserver/../coherence -Dbea.home=/u01/soa_12c/Middleware/MW_Home/wlserver/.. -Xverify:none -Djava.system.class.loader=com.oracle.classloader.weblogic.LaunchClassLoader -Djava.security.policy=/u01/soa_12c/Middleware/MW_Home/wlserver/server/lib/weblogic.policy -Dweblogic.nodemanager.JavaHome=/usr/java/jdk1.8.0_112 weblogic.NodeManager -v

<Nov 29, 2016 9:25:18 AM IST> <INFO> <Loading domains file: /u01/soa_12c/Middleware/MW_Home/oracle_common/common/nodemanager/nodemanager.domains>

<Nov 29, 2016 9:25:18 AM IST> <WARNING> <Domains file not found: /u01/soa_12c/Middleware/MW_Home/oracle_common/common/nodemanager/nodemanager.domains>

<Nov 29, 2016 9:25:22 AM IST> <INFO> <Loading identity key store: FileName=/u01/soa_12c/Middleware/MW_Home/oracle_common/common/nodemanager/security/DemoIdentity.jks, Type=jks, PassPhraseUsed=true>

<Nov 29, 2016 9:25:22 AM IST> <SEVERE> <Fatal error in NodeManager server>

weblogic.nodemanager.common.ConfigException: Identity key store file not found: /u01/soa_12c/Middleware/MW_Home/oracle_common/common/nodemanager/security/DemoIdentity.jks

        at weblogic.nodemanager.server.SSLConfig.loadKeyStoreConfig(SSLConfig.java:225)

        at weblogic.nodemanager.server.SSLConfig.access$000(SSLConfig.java:33)

        at weblogic.nodemanager.server.SSLConfig$1.run(SSLConfig.java:118)

        at java.security.AccessController.doPrivileged(Native Method)

        at weblogic.nodemanager.server.SSLConfig.<init>(SSLConfig.java:115)

        at weblogic.nodemanager.server.NMServer.<init>(NMServer.java:143)

        at weblogic.nodemanager.server.NMServer.main(NMServer.java:527)

        at weblogic.NodeManager.main(NodeManager.java:31)

+ status=1

+ set +x

Fix:

Copy the file <domainhome>/security/DemoIdentity.jks to  <domainhome>/nodemanager/security/DemoIdentity.jks

Copy the file <domainhome>/security/DemoIdentity.jks to  <MW_Home>/oracle_common/common/nodemanager/security/DemoIdentity.jks

How to find weblogic server version in E-Business Suite R12.2.5

Below steps to find the Weblogic server version in E-Business Suite R12.2.5

Step 1:

Goto $FMW_HOME

[applmgr@test26 FMW_Home]$ pwd
/u01/app/applmgr/TEST/fs1/FMW_Home

[applmgr@test26 FMW_Home]$ grep -I version registry.xml

<?xml version="1.0" encoding="UTF-8"?><bea-product-information xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:gpr="http://www.bea.com/ns/cie/gpr">

        <component name="Common Infrastructure Engineering" version="7.4.0.0" InstallDir="">

        <component name="WebLogic Server" version="10.3.6.0" InstallDir="/u01/app/applmgr/BODHTREE/fs1/FMW_Home/wlserver_10.3">

        <component name="Oracle Configuration Manager" version="10.3.5.0" InstallDir="">

Step 2:

Login to http://<server_name>:port/console

BI AppS ETL fails with the 'ORA-01792: maximum number of columns in a table or view is 1000' Error Message

We are getting below error while loading the data into BI APPS server .

Error:

Caused By: java.sql.SQLSyntaxErrorException: ORA-01792: maximum number of columns in a table or view is 1000

                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
                at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
                at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
                at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
                at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
                at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
                at oracle.jdbc.driver.T4CPreparedStatement.executeForRows => ORA-20942:

Fix:

The workaround is to set "_fix_control"='17376322:OFF'

SQL> alter session set "_fix_control"='17376322:OFF';

or at system level :

SQL> alter system set "_fix_control"='17376322:OFF';

 

OR

Apply Patch 19509982 if available for your DBVersion and Platform

Weblogic Server 12.1.2 Performance Issue Due To weblogic.socket.NIOSocketMuxer

Weblogic server 12.1.2 in a runnable state consuming high CPU resources.

Error:

"LDAPConnThread-579 ldaps://ldapserver.us.oracle.com:636" daemon prio=10 tid=0x00000000041f6800 nid=0x56d7 runnable [0x00007f9b6b9f8000]
java.lang.Thread.State: RUNNABLE
at sun.nio.ch.IOUtil.drain(Native Method)
at sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:90)
- locked <0x000000078a2f6e48> (a java.lang.Object)
at sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:87)
- locked <0x000000078a2f6b48> (a sun.nio.ch.Util$2)
- locked <0x000000078a2f6b38> (a java.util.Collections$UnmodifiableSet)
- locked <0x000000078a2f6910> (a sun.nio.ch.EPollSelectorImpl)
at sun.nio.ch.SelectorImpl.select(SelectorImpl.java:98)
at weblogic.socket.NIOSocketMuxer$NIOInputStream.readInternal(NIOSocketMuxer.java:815)
at weblogic.socket.NIOSocketMuxer$NIOInputStream.read(NIOSocketMuxer.java:759)
at weblogic.socket.NIOSocketMuxer$NIOInputStream.read(NIOSocketMuxer.java:742)
at weblogic.socket.JSSEFilterImpl.readFromNetwork(JSSEFilterImpl.java:462)
at weblogic.socket.JSSEFilterImpl.read(JSSEFilterImpl.java:424)
at weblogic.socket.JSSESocket$JSSEInputStream.read(JSSESocket.java:64)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x000000079c2dc630> (a java.io.BufferedInputStream)
at netscape.ldap.ber.stream.BERElement.getElement(Unknown Source)
at netscape.ldap.LDAPConnThread.run(Unknown Source)
at java.lang.Thread.run(Thread.java:745)


Fix:

In this case, as customer was using Linux x86-64, changing the MuxerClass from weblogic.socket.NIOSocketMuxer to weblogic.socket.PosixSocketMuxer worked.

In WLS Admin Console

Go to Environment > Servers > Server Name > Tuning, under Advanced, set the Muxer Class based on the OS and Reboot the server.

Solaris/HP-UX Native Muxer : weblogic.socket.DevPollSocketMuxer
POSIX Native Muxer : weblogic.socket.PosixSocketMuxer
Windows Native Muxer : weblogic.socket.NTSocketMuxer

Java Muxer : weblogic.socket.JavaSocketMuxer

You may also set the above in the Weblogic startup scripts via the JAVA_OPTIONS:
-Dweblogic.MuxerClass=weblogic.socket.PosixSocketMuxer

Weblogic console page is not coming up after server reboot

We have bounced the server and restarted the weblogic services. After restating the services we are unable to access the console page.

Cause:

We found that Linux firewalls are enabled the server. When we rebooted the server, by detault iptables got restarted.

To check the status of your firewall and all rules, enter:
# iptables -L -n (as root user)

Fix:

Stop the ipchains service(as root user):
# service ipchains stop

Stop the iptables service:
# service iptables stop

Stop the ipchains service from starting when you restart the server:
# chkconfig ipchains off

Stop the iptables service from starting when you restart the server:
# chkconfig iptables off

Ora-12547: tns:lost contact 12c

We are unable to access the jdbc url and sql developer after configuring E-Business suite R12.2.5

Error:

I/O Error: Connection Reset
ora-12547: tns:lost contact 12c

Fix:

Backup the sqlnet.ora file from both DB and Apps side and comment the below parameters.

#tcp.validnode_checking = yes
#tcp.invited_nodes=(hostname)

libmawt.so: libXi.so.6: cannot open shared object file: No such file or directory

We are getting below error while installing BI APPS rcu.

Error:

[oracle@test-krishna bin]$ ./rcu
Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/Softs/weblogic/rcu_obi/jdk/jre/lib/i386/xawt/libmawt.so: libXi.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1807)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1703)
at java.lang.Runtime.load0(Runtime.java:770)
at java.lang.System.load(System.java:1003)
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1807)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1724)
at java.lang.Runtime.loadLibrary0(Runtime.java:823)
at java.lang.System.loadLibrary(System.java:1028)
at sun.security.action.LoadLibraryAction.run(LoadLibraryAction.java:50)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Toolkit.loadLibraries(Toolkit.java:1605)
at java.awt.Toolkit.<clinit>(Toolkit.java:1627)
at com.jgoodies.looks.LookUtils.isLowResolution(LookUtils.java:484)
at com.jgoodies.looks.LookUtils.<clinit>(LookUtils.java:249)
at com.jgoodies.looks.plastic.PlasticLookAndFeel.<clinit>(PlasticLookAndFeel.java:135)
at oracle.sysman.assistants.rcu.ui.InteractiveRCUModel.<init>(InteractiveRCUModel.java:117)
at oracle.sysman.assistants.rcu.Rcu.execute(Rcu.java:307)
at oracle.sysman.assistants.rcu.Rcu.main(Rcu.java:363)


Fix:

[root@test-krishna Desktop]# yum install libXtst.i686

Resolving Dependencies
--> Running transaction check
---> Package libXtst.i386 0:1.0.1-3.1 will be updated
---> Package libXtst.i686 0:1.2.2-2.1.el6 will be an update
--> Processing Dependency: libXi.so.6 for package: libXtst-1.2.2-2.1.el6.i686
--> Running transaction check
---> Package libXi.i686 0:1.7.4-1.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
 Package                                 Arch                                 Version                                        Repository                            Size
========================================================================================================================================================================
Updating:
 libXtst                                 i686                                 1.2.2-2.1.el6                                  base                                  19 k
Installing for dependencies:
 libXi                                   i686                                 1.7.4-1.el6                                    base                                  37 k

Transaction Summary
========================================================================================================================================================================
Install       1 Package(s)
Upgrade       1 Package(s)

Total download size: 55 k
Is this ok [y/N]: Y
Downloading Packages:
(1/2): libXi-1.7.4-1.el6.i686.rpm                                                                                                                |  37 kB     00:00
(2/2): libXtst-1.2.2-2.1.el6.i686.rpm                                                                                                            |  19 kB     00:00
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                    55 kB/s |  55 kB     00:01
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
  Installing : libXi-1.7.4-1.el6.i686                                                                                                                               1/3
  Updating   : libXtst-1.2.2-2.1.el6.i686                                                                                                                           2/3
  Cleanup    : libXtst-1.0.1-3.1.i386                                                                                                                               3/3
  Verifying  : libXi-1.7.4-1.el6.i686                                                                                                                               1/3
  Verifying  : libXtst-1.2.2-2.1.el6.i686                                                                                                                           2/3
  Verifying  : libXtst-1.0.1-3.1.i386                                                                                                                               3/3

Dependency Installed:
  libXi.i686 0:1.7.4-1.el6

Updated:
  libXtst.i686 0:1.2.2-2.1.el6

Complete!

Script to find the number of active users in oracle R12 application

select 'Number of user sessions : ' || count( distinct session_id) How_many_user_sessions from icx_sessions icx where disabled_flag != 'Y'
and PSEUDO_FLAG = 'N'
and (last_connect + decode(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'), NULL,limit_time, 0,limit_time,FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT')/60)/24) > sysdate and counter < limit_connects;

How to Configuring Node Manager to Start Managed Servers

If a Managed Server contains other Oracle Fusion Middleware products, such as Oracle SOA Suite, Oracle WebCenter Portal, or Oracle JRF, the Managed Servers environment must be configured to set the correct classpath and parameters. This environment information is provided through the start scripts, such as startWebLogic and setDomainEnv, which are located in the following directory:

$DOMAIN_HOME/bin

If the Managed Servers are started by Node Manager (as is the case when the servers are started by the Oracle WebLogic Server Administration Console or Fusion Middleware Control), Node Manager must be instructed to use these start scripts so that the server environments are correctly configured. Specifically, Node Manager must be started with the property StartScriptEnabled=true.

There are several ways to ensure that Node Manager starts with this property enabled. As a convenience, Oracle Fusion Middleware provides the following script, which adds the property StartScriptEnabled=true to the nodemanager.properties file:

$ORACLE_COMMON_HOME/common/bin/setNMProps.sh.

For example, on Linux, execute the setNMProps script and start Node Manager:

ORACLE_COMMON_HOME/common/bin/setNMProps.sh
MW_HOME/wlserver_n/server/bin/startNodeManager.sh

When you start Node Manager, it reads the nodemanager.properties file with the StartScriptEnabled=true property, and uses the start scripts when it subsequently starts Managed Servers. Note that you need to run the setNMProps script only once.

Also note that when the StartScriptEnable property is set to true, the Node Manager reads the startWebLogic script, which in turns reads the setDomainEnv script. As a result, you must make any tuning changes by editing the setDomainEnv script. Any changes that are performed using the command line or Administration Console will not be implemented when Node Manager starts the servers. For example, if you use the Administration Console to change the server start arguments, those changes are written to config.xml, but the Node Manager ignores these settings and uses those in setDomainEnv.

Oracle E-Business Suite 12.2.6 Now Available

Oracle E-Business Suite Release 12.2.6 is now available.

Instructions for downloading and applying this latest release update pack (RUP) for the EBS 12.2 codeline can be found here:


Oracle E-Business Suite 12.2.6 Readme (Doc ID 2114016.1)

What Does Release 12.2.6 Include?

• Official release announcement
• EBS 12.2.6 highlights video with Cliff Godwin, Senior Vice President of Application Development 

As a consolidated suite-wide patchset, this RUP includes new features, statutory and regulatory updates, and enhancements for stability, performance, and security.

Release 12.2.6 is cumulative. That means that as well as providing new updates for this release, it also includes updates that were originally made available as one-off patches for earlier 12.2 releases.

For a complete list of new features, refer to:
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (Doc ID 1302189.1)

RCU/jdk/jre/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory

I got this error while installing RCU on OEL6.

$ ./rcu
Exception in thread "main" java.lang.UnsatisfiedLinkError:
/Installation/rcu/rcuHome/jdk/jre/lib/i386/xawt/libmawt.so:
libXtst.so.6: cannot open shared object file: No such file or directory
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1778)
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1674)
        at java.lang.Runtime.load0(Runtime.java:770)
        at java.lang.System.load(System.java:1003)
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1778)
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1695)
        at java.lang.Runtime.loadLibrary0(Runtime.java:823)
        at java.lang.System.loadLibrary(System.java:1028)

Cause: 
libXtst rpm for 32 bit is missing.

Fix:
Please check that the libXtst-xx.el6.i686.rpm (32 bit) installed.
rpm -qa |grep libXtst
If it is not installed the need to install:
rpm -ivh libXtst-xx.el6.i686.rpm

ORA-01654: unable to extend index APPLSYS.AD_PATCH_COMMON_ACTIONS_U2 by 16 in tablespace APPS_TS_TX_IDX

While applying an NLS Patch getting ORA-1654 errors occurred due to space issues.

Error:

ORA-01654: unable to extend index APPLSYS.AD_PATCH_COMMON_ACTIONS_U2 by 16 in tablespace APPS_TS_TX_IDX

ORA-01654: unable to extend index APPLSYS.AD_PROGRAM_RUN_TASK_JOBS_N1 by 16 in tablespace APPS_TS_TX_IDX

After fixing the ORA-1654 errors by setting the APPS_TS_TX_IDX datafile to autoextend, reapplying the same NLS patch gives the following warning message and the patch is skipped:

Fix:

1. Resolve the ORA-1654 error per any of the available methods.

2. Test reapplying the patch using following option:

adop phase=apply apply_mode=downtime patches=19676458 options=forceapply restart=no abandon=yes

3. Confirm the patch applied successfully using the above command.

INST-08109: An ORACLE_HOME environment variable should not be defined

I got the below error while installing Oracle BI 11.1.1.9 on Linux 5.7.

Error :

INST-08109: An ORACLE_HOME environment variable should not be defined

Fix:

unset ORACLE_HOME and try to re-install.

INST-08109: An ORACLE_HOME environment variable should not be defined

I got the below error while installing Oracle BI 11.1.1.9 on Linux 5.7.

Error :

INST-08109: An ORACLE_HOME environment variable should not be defined

Fix:

unset ORACLE_HOME and try to re-install.

Error in invoking target client_sharedlib of makefile

I am getting below error while installing Oracle Database 12c in OEL6. 

Error:

Fix:

Step 1:
Edit /etc/sysctl.conf file and entry followings.
#vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144

Step 2:

Create the below soft links.

ln -s /etc /etc/rc.d
ln -s /usr/bin/awk /bin/awk
ln -s /usr/bin/basename /bin/basename
ln -s /usr/bin/rpm /bin/rpm
ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libc_nonshared.a /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /usr/lib64/

Issue resolved after done all the above steps/changes.

Error in invoking target 'client_sharedlib' of makefile

I am getting below error while installing Oracle Database 12c in OEL6. 

Error:

Fix:

Step 1:
Edit /etc/sysctl.conf file and entry followings.
#vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144

Step 2:

Create the below soft links.

ln -s /etc /etc/rc.d
ln -s /usr/bin/awk /bin/awk
ln -s /usr/bin/basename /bin/basename
ln -s /usr/bin/rpm /bin/rpm
ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libc_nonshared.a /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /usr/lib64/

Issue resolved after done all the above steps/changes.

Error in invoking target 'client_sharedlib' of makefile

I am getting below error while installing Oracle Database 12c in OEL6. 

Error:

Fix:

Step 1:
Edit /etc/sysctl.conf file and entry followings.
#vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144

Step 2:

Create the below soft links.

ln -s /etc /etc/rc.d
ln -s /usr/bin/awk /bin/awk
ln -s /usr/bin/basename /bin/basename
ln -s /usr/bin/rpm /bin/rpm
ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libc_nonshared.a /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /usr/lib64/

Issue resolved after done all the above steps/changes.

Insufficient free space in /tmp while installing SOA 12c

$JAVA_HOME/java -jar fmw_12.1.3.0.0_soa_quickstart.jar

Insufficient free space in /tmp/orcl4316142800341622207.tmp to extract the installer.  Actual 365 MB.  Required 3053 MB.

In my case we don't have free space under /tmp mount. So i have created /tmp directory under different location.

Fix:

1. mkdir -p /u01/tmp
2. chmod -R 777 /u01/tmp
3. export _JAVA_OPTIONS="-Djava.io.tmpdir=/u01/tmp"
4. java -jar fmw_12.1.3.0.0_soa_quickstart.jar

CXF Error Deploying Updated p6ws.war File

Getting below error message while deploying the p6ws.war File

Error:

Servlet: "cxf" failed to preload on startup in Web application: "p6ws.war".
java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.apache.cxf.wsdl.WSDLManager' defined in URL [zip:/home/weblogic/Oracle/Middleware/user_projects/domains/iALM/servers/AdminServer/tmp/_WL_user/p6ws/nmdpik/war/WEB-INF/lib/cxf-bundle.jar!/META-INF/cxf/cxf.fixml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: javax/wsdl/WSDLException

Cause:

The wsdl4j-1.6.2.jar is missing from the p6ws.ear/p6ws.war file.

Fix:

1. In the <P6 Web Services Home Directory> edit the updateWSWar.cmd or updateWSWar.sh file. Ensure the CXF_HOME path is set to the folder where wsdl4j-1.6.2.jar has been copied.
2. Save and execute the updateWSWar file to update the p6ws.ear/p6ws.war file.
3. Redeploy the p6ws.ear/p6ws.war file.

Oracle.DataAccess.Client.OracleException: ORA-06550: line 1, column 15

Error:

We are getting below error while installing UPK Server and Client on windows server 2012 R2.

UPK client / server Installation fails with a Library Loader log:

@ System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]:
@ ORA-06550: line 1, column 15:
@ PLS-00905: object ODSERVER_11.PART_EXISTS is invalid
@ ORA-06550: line 1, column 7:
@ PL/SQL: Statement ignored (Fault Detail is equal to An ExceptionDetail,
@ likely created by IncludeExceptionDetailInFaults=true, whose value is:
@ Oracle.DataAccess.Client.OracleException: ORA-06550: line 1, column 15:
@ PLS-00905: object ODSERVER_11.PART_EXISTS is invalid
@ ORA-06550: line 1, column 7:
@ PL/SQL: Statement ignored

Fix:

Stop the installer before running Library Loader and manually add grant permissions.

Steps:

• Drop the tablespace and users.  Start a fresh installation.
• Create a setupdiag.ini

Locate the ..\setup\Branding\UPK\Installer folder

Create a new notepad file called setupdiag.ini

Open the file and enter the following:

[SetupDebug]

Stopbeforelibraryloader=1

Save and close the file.

• Create a setupdiag.ini
• Start installer and enter credentials desired to be created
• Installer pauses 
• Grant the execute privileges

• Log in as SYSDBA, run the the following queries:

grant execute on sys.dbms_lob to ODSERVER;

grant execute on sys.dbms_lob to ODSERVER_APP;

•  Log into Oracle with the credentials of the schema created (i.e.,ODSERVER)

• Run the following query:

select object_name, object_type from obj where status !='VALID';

returned two FUNCTIONS:

ADD_PART

PART_EXISTS

•  Recompile the invalid objects

alter compile;

example: alter FUNCTION ADD_PART compile;

example: alter FUNCTION PART_EXISTS compile;

• Let installer continue

• Click Finish

ORA-20008 When Running "adop phase=prepare"

Error while running command: adop phase=prepare

ERROR at line 1:
ORA-20008: No Concurrent Manager is defined that can run concurrent program ADZDPATCH
ORA-6512: at "APPS.AD_ZD_ADOP", line 240

Fix:

Set the Run filesystem / environment and run command:

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $AD_TOP/patch/115/import/US/adzdpatch.ldt - CUSTOM_MODE=FORCE

[ERROR]: The value of s_file_edition is not set correctly in at least one of the context files

When attempting to run adop phase=prepare, the following error occurs.

[ERROR]: JDK TOP (or FMW JDK TOP) is not set up correctly.
[WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.
[ERROR]: Some of the ports specified for the patch file system are not available.
[ERROR]: The value of s_file_edition is not set correctly in at least one of the context files
[ERROR]: The values of s_current_base and s_other_base are not set correctly on both RUN and PATCH filesystems

Fix:

Delete duplicate context files and run autoconfig to create new ones.

1.Please backup FND_OAM_CONTEXT_FILES

SQL>create table FND_OAM_CONTEXT_FILES_BK as select * from FND_OAM_CONTEXT_FILES;

2.Please clear data from FND_OAM_CONTEXT_FILES table.

SQL>delete from FND_OAM_CONTEXT_FILES;

3.Please execute autoconfig from all nodes.

cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh

4.Please confirm the new data from FND_OAM_CONTEXT_FILES;

SQL>select * from FND_OAM_CONTEXT_FILES;

5.Please execute the adop again.


Note: The patch file system context file is needed for adop to complete. Enoking the patch edition and running autoconfig on it should resolve that issue.

FRM-92101:There was a failure in the forms server during startup.

After upgrading to EBS 12.1.3 the following error appears when launching forms:

FRM-92101:There was a failure in the forms server during startup.

CAUSE:

Incorrect soft link to ldflags.

The ldflags softlink pointed to an incorrect file :
ls -atlr $ORACLE_HOME/lib32/ldflags

$ORACLE_HOME/lib32/ldflags ===> Patch Directory/RUP4XB6/apps/tech_st/10.1.2/lib/ldflags

SOLUTION:

Please execute the following steps to resolve the issue:

• Point the link to $ORACLE_HOME/lib/ldflags.

• Change into $ORACLE_HOME/forms/lib32 directory.

• Relink Forms : (make -f ins_forms.mk install)

• Restart the Forms-Server and retest the login.

"adop phase=finalize" Fails As ADOP Cannot Detect Any Application Tier Nodes In FND_NODES table. Ensure ICM is running and run autoconfig on all nodes

When attempting to perform "adop phase=finalize" the following error occurs.

ERROR
[UNEXPECTED]adop cannot detect any application tier nodes in FND_NODES table. Ensure ICM is running and run autoconfig on all nodes
[UNEXPECTED]Error while checking if this is a multi node instance

The issue occurs due to a null value for the concurrent/admin node status column in table FND_NODES.

More details are available via the following unpublished defect:
Bug 18533116 - AD:ADOP IN HOTPATCH FAILED FOR R12.TXK.C.DELTA.5

"In AD.Delta.4+one off patches we have a dependency on FND_NOTES.STATUS column

The column will be automatically set to 'Y' when ICM is up.

When the ICM is down the query will not detect any nodes with status 'Y',  and adop proceeds with only the current/admin node (inserts rows into AD_ADOP_SESSIONS for current/admin node only."

Fix:

To resolve the issue, test the following steps in a development instance and migrate accordingly:
Test the following steps:

    A. Set the "run" Application Tier environment
    B. Start ICM
    C. Run "adop phase=finalize" again.

Ref: (Doc ID 1904735.1)

After Upgrading EBS 12.2.5, Users Are Unable To Login And Receive The Following Error: "URL Validation Failed"

After an E-Business Suite 12.2 upgrade, user login fails with the following error:

Error

URL validation failed. The error could have been caused through the use of the browser's navigation buttons ( the browser Back button or refresh, for example). If the error persists, Please contact system administrator.

Fix:

Disable maintenance mode for the system to work as intended.

To resolve the issue, test the following steps in a development instance and migrate accordingly:

1. Check if maintenance mode is enabled via th following sql:

select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;

2. If the status of the above select does not return 'NORMAL', then maintenance mode is enabled. In this case disable it via the following sql:

sqlplus <APPS_Schema name>/<APPS Password>@adsetmmd.sql | DISABLE

Ref: (Doc ID 1592363.1)

Issues While Re-starting 12.2.4 RUP Patch 17919161 Failed With ORA-04063, ORA-06508, ORA-06512 on FND_CONC Package Invalid

When applying Oracle E-Business Suite 12.2.4 Release Update Pack Patch 17919161 on the run edition application environment, using downtime mode getting the error below:

$ adop phase=apply apply_mode=downtime patches=17919161 restart=yes

Error:

SQL> select ad_zd_adop.is_icm_alive() from dual
  *
ERROR at line 1:
ORA-04063: package body "APPS.FND_CONC" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_CONC"
ORA-06512: at "APPS.AD_ZD_ADOP", line 1635
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[UNEXPECTED] Error occurred

Cause:

An invalid FND_CONC package.

The error in the adop log file shows the following object is invalid and it needs to be validated so the patch can continue:

ERROR at line 1:
ORA-04063: package body "APPS.FND_CONC" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_CONC"
ORA-06512: at "APPS.AD_ZD_ADOP", line 1635


Fix:

1. Run the script $FND_TOP/patch/115/sql/AFCPDIGB.pls to validate the FND_CONC package:

sqlplus apps/<appspwd> @$FND_TOP/patch/115/sql/AFCPDIGB.pls

2. Re-run adop.

Ref: (Doc ID 1926427.1)

BEA-000383 A critical service failed. The server will shut itself down

I am facing the below issue while starting the weblogic server after configuring the OBIEE application.

Error:
weblogic.security.providers.authentication.LDAPAtnLoginModuleImpl.login(LDAPAtnLoginModuleImpl.java:261)
        at com.bea.common.security.internal.service.LoginModuleWrapper$1.run(LoginModuleWrapper.java:110)
        at java.security.AccessController.doPrivileged(Native Method)
        at com.bea.common.security.internal.service.LoginModuleWrapper.login(LoginModuleWrapper.java:106)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        Truncated. see log file for complete stacktrace

May 29, 2016 11:30:55 AM PDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FAILED>
<May 29, 2016 11:30:55 AM PDT> <Error> <WebLogicServer> <BEA-000383> <A critical service failed. The server will shut itself down>
<May 29, 2016 11:30:55 AM PDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN>

Fix:

Create the boot.properties file under $DOMAIN_HOME/servers/AdminServer/security/

[obiee@obiee security]$ pwd
/u0/u01/obiee/product/FMW_HOME/user_projects/domains/bifoundation_domain/servers/AdminServer/security

[obiee@obiee security]$ vi boot.properties
[obiee@obiee security]$ cat boot.properties
username=weblogic
password=welcome123

[ERROR]: Some of the ports specified for the patch file system are not available.

When attempting to run "adop phase=fs_clone" command the following error occurs:

ValidatePatchFSPortPool:
[ERROR]: Some of the ports specified for the patch file system are not available.

In my case here 7002 is run file system weblogic console port and 7001 is patch file system port.

This issue is caused by a port used by WLS Admin Server on the run file system which is not free (e.g port 7001).

Note:
The following command gives the current port used by the WLS Admin Server :
$ grep s_wls_adminport $CONTEXT_FILE

Cause:

In my case both Run and Patch file system admin servers are running.

Solution:

In my case both Run and Patch file system weblogic console ports are running.

To implement the solution, please execute the following steps:

1. Shutdown all apps services on RUN and PATCH file systems.

. /EBSapps.env R
cd $INST_TOP/admin/scripts
adstpall.sh apps/apps

. /EBSapps.env P
cd $INST_TOP/admin/scripts
adstpall.sh apps/apps

2. make sure that port used by the WLS Admin Server is free and no processes are running from your Patch file system via the following command

$ netstat -a | grep 7001
$ ps -eaf | grep 7001

replace 7001 by the port listed in the autoconfig s_wls_adminport parameter and in the error message (e.g. 7001, 7002, ...)
Note: The above commands should returns no activity on the related ports

3. On the RUN file system, start up adadmin server via the following command

. /EBSapps.env run
cd $INST_TOP/admin/scripts
$ adadminsrvctl.sh start

4. Start fs_clone from the beginning  

For Single Node
$ adop phase=fs_clone allnodes=no force=yes

For Multi Node
$ adop phase=fs_clone force=yes

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  2926472 bytes
Variable Size            1392511096 bytes
Database Buffers          738197504 bytes
Redo Buffers               13848576 bytes
Database mounted.
Database opened.

SQL> SELECT name FROM v$parameter WHERE isdeprecated = 'TRUE';

NAME
--------------------------------------------------------------------------------
lock_name_space
instance_groups
resource_manager_cpu_allocation
active_instance_count
buffer_pool_keep
buffer_pool_recycle
log_archive_start
standby_archive_dest
parallel_server
parallel_server_instances
fast_start_io_target

NAME
--------------------------------------------------------------------------------
serial_reuse
rdbms_server_dn
max_enabled_roles
remote_os_authent
sec_case_sensitive_logon
global_context_pool_size
cursor_space_for_time
plsql_v2_compatibility
plsql_debug
background_dump_dest
user_dump_dest

NAME
--------------------------------------------------------------------------------
commit_write
sql_trace
parallel_automatic_tuning
parallel_io_cap_enabled

26 rows selected.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oracle@rysigo04 ~]$ oerr ora 32004
32004, 00000, "obsolete or deprecated parameter(s) specified for %s instance"
// *Cause:  Obsolete or deprecated parameters for this instance type
//          were specified in the SPFILE or the PFILE on the server side.

// *Action: See alert log for a list of parameters that are obsolete
//          or deprecated. Remove them from the SPFILE or the server
//          side PFILE.

How to install and uninstall weblogic bsu patches

Install .bsu patch in weblogic:

bsu.sh -install -patch_download_dir=/u002/app/applmgr/RYSAAV3/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=FCX7 -prod_dir=/u002/app/applmgr/RYSAAV3/fs1/FMW_Home/wlserver_10.3

Uninstall .bsu patch in weblogic:

bsu.sh -remove -patchlist=BLTG -prod_dir=/u002/app/applmgr/RYSAAV3/fs1/FMW_Home/wlserver_10.3

bsu.sh -remove -patchlist=FCX7 -prod_dir=/u002/app/applmgr/RYSAAV3/fs1/FMW_Home/wlserver_10.3

adop utility cannot be used when a previous patching cycle is incomplete

Checking for existing adop sessions.
        Session Id            :   2
        Prepare phase status  :   NOT APPLICABLE
        Apply phase status    :   ATLEAST ONE PATCH IS ALREADY APPLIED
        Cutover  phase status :   NOT APPLICABLE
        Abort phase status    :   NOT APPLICABLE
        Session status        :   FAILED
    [UNEXPECTED]The adop utility cannot be used when a previous patching cycle is incomplete
    [UNEXPECTED]Ensure there is no existing patching cycle before trying to apply more patches
    [UNEXPECTED]Unrecoverable error occurred. Exiting current adop session.

[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.


adop exiting with status = 2 (Fail)

$adop phase=abort

$adop phase=cleanup cleanup_mode=full

Run the following statement to find out the session that is in running state:
SQL>select adop_session_id from ad_adop_sessions where status='R';

Set the status to 'C' (Completed) for that session, to re-try the phase that was interrupted:

SQL>update ad_adop_sessions set status='C' where status='R;

SQL>commit;

ADOP apply phase options ABANDON and RESTART

Abandon:

adop phase=apply patches=22123818 hotpatch=yes abandon=yes

Used to specify whether to restart the previous run of adop. May be useful if the previous action had an error.
Note: If there was an error in the previous run, and 'abandon' is not set to 'yes', the same parameters will be re-used that were used in the failed run.

If you give a value for the 'restart' parameter, it cannot be the same as the value given for this parameter.

Restart:

adop phase=apply patches=22123818 hotpatch=yes restart=yes

Used to specify whether to restart the previous run of ADOP. May be useful if the previous action had an error. If you give a value for the 'abandon' parameter, it cannot be the same as the value given for this parameter.

Utility /Script To Check The Techstack Component Versions (Forms, Http Server, JDK, Framework, Database, etc)

Below steps to know How to find the versions of technology stack components (Forms, iAS, Framework, JDK, OJSP, Database, etc.)?

Script:

$ADPERLPRG $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -contextfile=$CONTEXT_FILE -appspass=apps -outfile=$APPLTMP/Report_App_Inventory.txt -reporttype=text

Output:

Report file location:  /u002/app/applmgr/RYSAAV3/fs1/inst/apps/RYSAAV3_rysigo04/appltmp/Report_App_Inventory.txt gene   rated successfully.

TXK Technology Inventory Report for EBS Release 12

  Date :Thu May 19 21:09:22 2016
  Hostname :krishna.apps
  Enabled Services:Root Service, Web Administration, Web Entry Point
  Services, Web Application Services, Batch Processing Services
  Instance :TEST
  Platform :LINUX 64-bit
  Tier :APPS
  OS release :2.6.32-300.39.2.el5uek
  DB Host :krishna.apps
  Context File
  :/u002/app/applmgr/TEST/fs1/inst/apps/*******/appl/admin/*******_04.xml (120.401.12020000.9.1202010.10)
  Report File
  :/u002/app/applmgr/TEST/fs1/inst/apps/********/appltmp/Report_
  App_Inventory.txt
  XML Definition
  File:/u002/app/applmgr/TEST/fs1/EBSapps/appl/fnd/12.0.0/html/txkInvent
  ory.xml (120.13.12020000.2)

Weblogic Service Properties :
  Oracle Weblogic Server version                   10.3.6.0
  JDK version on Weblogic Server node              1.7.0_85 (64-Bit)
  Oracle Smart Update version on FMW Home          3.3.0.0
  OCM version on FMW Home (utils)                  Not Configured

HTTP Service Properties:
  Oracle HTTP Server version                       11.1.1.9.0
  Sun JDK client version                           1.6.0_27
  JDK version on HTTP server node                  1.7.0_85
  Oracle JDBC driver version using JAVA API        11.2.0.3.0
  (oracle.jdbc.driver.OracleDriver)
  Oracle AOLJ version                              Roll Up Patch J
  Oracle BC4J version                              10.1.3.43.6
  Oracle BiBeans version                           3.1.1.10
  Oracle HTTP client version                       10h
  Java object cache                                11.1.1.2.0
  Oracle JRAD libraries version                    10.1.3
  Oracle MDS version                               9.0.6.0.0_50
  OA Framework version                             12.2.0
  Oracle help web version                          2.0.13
  Oracle XML driver version                      
  Oracle UIX version                               11_1_1_7_0
  OPatch version on Oracle HTTP Server Oracle Home 11.1.0.12.9
  OCM version on Oracle HTTP Server Oracle Home    Not Configured
  OPatch version on Oracle Common Oracle Home      11.1.0.12.9

Forms Service Properties:
  Developer 10g version                            10.1.2.3.0
  DB client (RSF) library version in 10.1.2        10.1.0.5.0
  oracle home
  JDK version used by AD utilities on forms node   1.7.0_85
  Oracle Application Server patchset version       10.1.2.3.0
  OPatch version on 10.1.2 Oracle Home             1.0.0.0.64
  OCM version on 10.1.2 Oracle Home                Not Configured
  JDK version used by Developer 10g                1.7.0_85-b15

Concurrent Processing Service Properties:
  JDK on concurrent processing node                1.7.0_85
  JDK version used by AD utilities on CP node      1.7.0_85

Code Inventory of Weblogic Server Home:
(/u002/app/applmgr/RYSAAV3/fs1/FMW_Home/wlserver_10.3):
  Oracle WebLogic Sever overlay patch for          -
  10.3.6.0.7 which requires WLS10.3.6.0.7 PSU
  (Patch Number : 17572726 , Patch ID : FCX7) in
  the environment
  S8H6                                             -
  1LRI                                             -
  BLTG                                             -
  TTEM                                             -
  CW9T                                             -
  Oracle WebLogic Sever overlay patch for          -
  10.3.6.0.7 which requires WLS 10.3.6.0.7 PSU
  (Patch Number: 17572726 , Patch ID :FCX7) in
  the environment
  7FC9                                             -
  Y5AP                                             -
  YVDZ                                             -
  YHJK                                             -
  32I2                                             -
  FCX7                                             -
  S9MN                                             -
  Oracle WebLogic Sever overlay patch for          -
  10.3.6.0.7 which requires WLS10.3.6.0.7 PSU
  (Patch Number: 17572726 , Patch ID :FCX7) in
  the environment
  VKXF                                             -
  2GYW                                             -
  Oracle WebLogic Sever overlay patch for          -
  10.3.6.0.7 which requires WLS10.3.6.0.7 PSU
  (Patch Number: 17572726 , Patch ID :FCX7) in
  the environment.
  CIH8                                             -

Code Inventory of OHS Oracle Home:
(/u002/app/applmgr/TEST/fs1/FMW_Home/webtier):
  7663342                                          Wed May 18 15:18:23 PDT 2016
  7572595                                          Wed May 18 16:03:27 PDT 2016
  7427144                                          Wed May 18 15:17:57 PDT 2016
  20922780                                         Wed May 18 16:02:23 PDT 2016
  6599470                                          Wed May 18 15:17:49 PDT 2016
  13417321                                         Wed May 18 16:03:04 PDT 2016
  7707476                                          Wed May 18 15:18:13 PDT 2016
  6750400                                          Wed May 18 15:18:56 PDT 2016
  7695070                                          Wed May 18 16:02:48 PDT 2016
  6845838                                          Wed May 18 15:19:12 PDT 2016
  7393921                                          Wed May 18 15:18:32 PDT 2016

Code Inventory of Oracle Common Oracle Home:
(/u002/app/applmgr/TSET/fs1/FMW_Home/oracle_common):
  17284368                                         Wed May 18 16:04:11 PDT 2016
  20484781                                         Wed May 18 16:03:54 PDT 2016

Code Inventory of C-Oracle Home:
(/u002/app/applmgr/TEST/fs1/EBSapps/10.1.2)
  5261796                                          Thu Nov 15 23:30:46 PST 2012
  11780669                                         Thu Nov 15 23:49:04 PST 2012
  12848228                                         Thu Nov 15 23:59:32 PST 2012
  14825718                                         Wed May 18 16:16:44 PDT 2016
  16778382                                         Wed May 18 16:21:11 PDT 2016
  9974899                                          Thu Nov 15 23:46:06 PST 2012
  12898423                                         Thu Nov 15 23:52:39 PST 2012
  13417321                                         Wed May 18 16:26:37 PDT 2016
  16241466                                         Wed May 18 16:11:11 PDT 2016
  15900214                                         Wed May 18 16:23:08 PDT 2016
  7695070                                          Thu Nov 15 23:50:49 PST 2012
  8943095                                          Wed May 18 16:23:38 PDT 2016
  3559326                                          Thu Mar 26 08:42:23 PDT 2009
  5651245                                          Thu Dec 09 15:03:33 PST 2010
  12887068                                         Thu Nov 15 23:52:13 PST 2012
  8339196                                          Thu Nov 15 23:29:45 PST 2012
  5394728                                          Thu Mar 26 08:42:47 PDT 2009
  8557019                                          Thu Nov 15 23:37:31 PST 2012
  8300196                                          Wed May 18 16:20:42 PDT 2016
  5917053                                          Thu Mar 26 08:41:08 PDT 2009
  17653437                                         Wed May 18 16:10:25 PDT 2016
  17645157                                         Wed May 18 16:11:54 PDT 2016
  12379038                                         Thu Nov 15 23:49:45 PST 2012
  12434128                                         Thu Nov 15 23:42:23 PST 2012
  8528194                                          Wed May 18 16:22:16 PDT 2016
  10152652                                         Wed May 18 16:12:43 PDT 2016
  16271876                                         Wed May 18 16:09:41 PDT 2016
  14353879                                         Wed May 18 16:14:13 PDT 2016
  8447875                                          Thu Nov 15 23:45:14 PST 2012
  5604120                                          Wed May 18 16:21:36 PDT 2016
  16209520                                         Wed May 18 16:17:06 PDT 2016
  7140405                                          Thu Mar 26 08:42:04 PDT 2009
  16275529                                         Wed May 18 16:19:01 PDT 2016
  6400501                                          Sun Dec 12 22:26:47 PST 2010
  7016961                                          Thu Mar 26 08:40:17 PDT 2009
  17907988                                         Wed May 18 16:24:17 PDT 2016
  18620223                                         Wed May 18 16:24:54 PDT 2016
  9273888                                          Thu Nov 15 23:45:40 PST 2012
  19434967                                         Wed May 18 16:25:55 PDT 2016
  14374587                                         Wed May 18 16:13:52 PDT 2016
  4047619                                          Wed May 18 16:19:57 PDT 2016
  5659594                                          Wed May 18 16:22:39 PDT 2016
  12828135                                         Thu Nov 15 23:44:19 PST 2012
  6371228                                          Thu Mar 26 08:41:41 PDT 2009

Ref: (Doc ID 601736.1)

How to Completely Remove Forms (formsapp) from WLS_FORMS and Redeploy the forms in WLS_FORMS

There may be times when the existing Forms application in a managed WLS_FORMS server becomes corrupted and cannot be fixed. Removing it and installing the default Forms application can resolve issues like this.

Removing Forms from WLS:

1. Go to the WLS Console and choose deployments.
2. Ensure "Lock and Edit" is chosen.
3. Check the formsapp (11.1.2) and choose Stop.  Choose either "When work completes" or "Force Stop Now" depending on the concern for user impact.
4. Once it is stopped, its "State" will change to "Prepared".
5. Select the formsapp (11.1.2) again, choose "Delete" and confirm the deletion.
6. You will be prompted to "Activate Changes".
7. You will note that formsapp (11.1.2) no longer appears as a Deployment in the deployed applications list.

Redeploying Forms into WLS:

1. Go to the WLS Console and choose deployments.
2. Ensure "Lock and Edit" is chosen.
3. Click on the "Install" Button.
4. Choose your formsapp.ear from ORACLE_HOME\forms\j2ee and choose Next.
5. Take the default option of "Install this deployment as an application" and choose Next.
6. You will next see target options.  In most cases you will want to choose "cluster_forms" as shown but other options are available.
7. Next a screen will appear showing "General", "Security", "Source Accessibility" options.  Take the defaults which should be: (Name:  formsapp, DD Only: Use only roles and policies that are defined in the deployment descriptors, Source accessibility: Use the defaults defined by the deployment's targets).
8. Click on next.
9. The next screen will give "Additional Configuration" options.
10. Take the default selection: "Yes, take me to the deployment's configuration screen. The  "Summary" selection will show the previous choices made.
11. Click "Finish" and then "Save".
12. Click on "Activate Changes".
13. Choose "Deployments" again and you should see "formsapp (11.1.2) in a "Prepared" state.  Check formsapp (11.1.2) and  choose "Start (Servicing All Requests)." It should become "Active".

Update the Deployment Plan for the formsapp (plan.xml):

1. Go to the WLS Console and choose deployments.
2. Ensure "Lock and Edit" is chosen.
3. Check the formsapp (11.1.2) and choose "Update".
4. You will note that the "Deployment plan path:" is not chosen. Click on the "Change Path" button and choose DOMAIN_HOME\deployments-plans\formsapp\11.1.2\plan.xml
5. Click "Next" and choose: "Update this application in place with new deployment plan changes. (A deployment plan must be specified for this option)".
6. Choose "Finish".
7. Click "Activate Changes".
8. Restart WLS_FORMS and test using:  http://hostname:port/forms/frmservlet to bring up the test form and this should work.

Ref: (Doc ID 2030914.1)

oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.fnd.wf.worklist.server.NotificationsAM'.

In Production, all of a sudden users started getting: Could not load application module

In most jsp's users are getting the following error:
oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.fnd.wf.worklist.server.NotificationsAM'.

## Detail 0 ##
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_TRANSACTION_ID.

The users can login ok and are able to navigate through forms as well.

Fix:

icx_transactions table needs to be cleared.

Please follow the below steps to schedule a concurrent request to purge the inactive sessions periodically (once in a week for high traffic instances):

1.  Login using sysadmin
2.  Navigate to Requests ---> Run
3.  In the Form that opens run/schedule "Purge Inactive Sessions" request.

A job should be scheduled to run this request at least weekly.

Ref: (Doc ID 1577877.1)

Steps to change the APPS, APPLSYS, and APPS_NE password using FNDCPASS or AFPASSWD for EBS 12.2

Whenever using FNDCPASS or AFPASSWD to change the APPS, APPLSYS, and APPS_NE password, we must also perform the following actions:

1. Shut down the application tier services using the below script:

$INST_TOP/admin/scripts/adstpall.sh

2. Change the APPLSYS password using

A. FNDCPASS:
For example, the following command changes the APPLSYS password to 'WELCOME':

FNDCPASS apps/<appspwd> 0 Y system/manager SYSTEM APPLSYS WELCOME

B. AFPASSWD:

AFPASSWD is an enhanced version of FNDCPASS, and includes the following features:

• AFPASSWD only prompts for passwords required for the current operation, allowing separation of duties between applications administrators and database administrators. This also improves interoperability with Oracle Database Vault. In contrast, the FNDCPASS utility currently requires specification of the APPS and the SYSTEM usernames and corresponding passwords, preventing separation of duties between applications administrators and database administrators.
• When changing a password with AFPASSWD, the user is prompted to enter the new password twice to confirm.
• In Oracle E-Business Suite Release 12.2.3 and higher, you can also use the AFPASSWD utility to migrate Oracle E-Business Suite user passwords to a password hashing scheme.

Syntax for using AFPASSWD:
 AFPASSWD [-c <APPSUSER>[@<TWO_TASK>]] -s <APPLSYS>

3. Run autoconfig with the newly changed password.

4. Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh script. Do not start any other application tier services.

5. Change the "apps" password in WLS Datasource as follows:

• Log in to WLS Administration Console.
• Click Lock & Edit in Change Center.
• In the Domain Structure tree, expand Services, then select Data Sources.
• On the "Summary of JDBC Data Sources" page, select EBSDataSource.
• On the "Settings for EBSDataSource" page, select the Connection Pool tab.
• Enter the new password in the "Password" field.
• Enter the new password in the "Confirm Password" field.
• Click Save.
• Click Activate Changes in Change Center.

6. Start all the application tier services using the below script

$INST_TOP/admin/scripts/adstrtal.sh

7. Verify the WLS Datastore changes as follows:

• Log in to WLS Administration Console.
• In the Domain Structure tree, expand Services, then select Data Sources.
• On the "Summary of JDBC Data Sources" page, select EBSDataSource.
• On the "Settings for EBSDataSource" page, select Monitoring > Testing.
• Select "oacore_server1".
• Click Test DataSource
• Look for the message "Test of EBSDataSource on server oacore_server1 was successful".

Ref: (Doc ID 1674462.1)