Enable Click Here for Exception Details after login to EBS 12.1.3 instead of Homepage

After cloning the EBS Application, we faced issue while trying log in to the application. Log in information is validated, but instead of the Home page a blank screen appears and also the error message is not thrown. Generally in EBS Click Here for Exception Details will appear. On clicking the button we'll able to see the error stack and we plan for some workaround. In my case that Click Here message itself is not displayed. To bring that message, need to enable the Profile Option FND:Diagnostics = YES. Since we can't login to the application we'll achieve that form backend.


Step 1:

DECLARE
stat boolean;
BEGIN
dbms_output.disable;
dbms_output.enable(100000);
stat := FND_PROFILE.SAVE('FND_DIAGNOSTICS', 'YES', 'SITE');
IF stat THEN
dbms_output.put_line( 'Stat = TRUE - profile updated' );
ELSE
dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
END IF;
commit;
END;
/


Step 2:

Re-attempt to login and click on "here" link to generate stack trace.

Step 3:

Go through the error message and based on that we can search for a solution.


****************************நன்றி****************************

exec () : 0509-036 Cannot load program sqlplus because of the following errors :

Recently in our environment we've upgraded our OS from AIX 6.1 to AIX 7.1. OS up-gradation activity completed  successfully. We tried to bring our DB and APPS services online and faced this new issue while starting the DB listener. Below is the issue and the solution for the same.

The problem is due to I/O Communication ports either not enabled or not installed.

To check whether IOCP is installed run the following command.

 #lslpp -l bos.iocp.rte 

As shown above IOCP is installed and available in AIX. To check whether IOCP is enabled or not, run the following UNIX command

# lsdev -Cc iocp

It showed "Defined", which means not enabled. The output should show "Available" instead of "Defined". To change the status from Defined to Available, use the UNIX Smitty commad as follows

#smitty iocp

Select Change / Show characteristics of I/O Completion Ports

Change configured state at system, restart to change form Defined to Available

Run lsdev command to confirm the same

Perform a system restart (Server Reboot) to make the changes permanent.

After the reboot, check listener status and connect to sqlplus as shown below.

****************************நன்றி****************************

Weblogic Server 12.2.1.3 Installation

In this post we'll see the Installation and configuration of Weblogic Server 12.2.1.3 version in a detailed step by step process. Also here I've configured WLS for ADF. Below are the required setup files.

Installing JDK:

Untar the jdk file by using the below command

tar -zxvf <jdk file name>

Installing Weblogic Server :

This 12.2. version of Weblogic Server is bit different in the Installation process in compared with the earlier releases. Here we need to run the Infrastructure installer. Let us see the steps in detail.

Now the Installation of the Infrastructure is completed. Next we need to create the required schema's, repository and configure the Base Domain to start the WLS.

Schema Creation:

To create schema we need to create a user at DB level and assign him DBA privileges.

Follow the below steps to accomplish the above said step.

create user as below

sqlplus '/as sysdba'

SQL> create user TEST identified by <password>;

then,

Repository Creation :

Now we'll see the repository creation using the RCU utility.

Make a note of the schema prefix given in this step. This schema owner name is needed in the coming steps

Configuring the Base Domain :

Now we need to create and configure a new domain to be used in the Weblogic server. Default name for the new domain will be base domain. Here I've kept the name as it is. You can change the name of the domain as per your requirement.

Now in this below step enter the Schema prefix you've noted in the previous step.

Now the Domain is configured. You are all set to go with the Weblogic Server. You can start the Weblogic Server as below

****************************நன்றி****************************