APPSINFODB – Information Technology Group

Finding Solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s data integrity

  • Blog Stats

    • 39,236 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    February 2018
    M T W T F S S
    « Dec    
  • Archives

  • Authors

Archive for the ‘E-Business Suite R12’ Category

Not able to cancel concurrent request & Unable to activate CM after cloning

Posted by appsinfo on August 20, 2012

Below are the two issues that I have faced after cloning from production

Q: How to terminate a concurrent request that cannot be cancelled

1.  Identify the request number to terminate.

2.  Shut down the concurrent managers and issue the following sql command as applsys:

            update fnd_concurrent_requests  set status_code = ‘E’, phase_code = ‘C’  where Request_id = <reqnum>; (reqnum = request number)

Q: A Manager is not activating.         

Check the count in sys.dual, system.dual, & apps.fnd_dual. There should only be one (1) row for each. 
If the count is greater, change to one only. This can be done from sqlplus as  follows:

    As user apps:
                   select * from SYS.DUAL;

    Any extra rows should be deleted.

                   delete rownum from SYS.DUAL; (rownum = the row number to delete)

    Any extra rows for apps.fnd_dual must be removed by performing the following SQL command:

                 delete from fnd_dual where rownum < (select max(rownum) from fnd_dual);

**For more on concurrent managers you can refer to FAQ (Concurrent Manager Unix specific Note ID: 105101.1)**


Posted in Cloning, E-Business Suite 11i, E-Business Suite R12, Troubleshooting | Tagged: | Leave a Comment »

Not able to Access the R12 Login Page After Cloning

Posted by appsinfo on June 6, 2010

Recently I have faced issue which was result of corrupt java class files under $COMMON_TOP/_pages


1. After cloning environement OA R12
– Cloning terminated OK
– Adconfig terminated OK
– Process Oracle application are launched without error
– Connection to database is OK

2. Trying to access the environment: Login Page not displayed (No Error Displayed)


1. Shut down the Application Tier

2.Run “” from $FND_TOP/patch/115/bin

perl –compile –flush -p 2

3. Run autoconfig on both db and apps tiers

4. Bring up the services and test login

Posted in E-Business Suite R12 | Tagged: | 2 Comments »

R12-FNDFS Error

Posted by appsinfo on May 19, 2010

An error occurred while attempting to establish an Applications File Server connection with the node FNDFS

Error: In R12, After running a request, while we view the Log and from that when we want to take the log using Tools –> Copy to the File, the following Error Occurs

An error occurred while attempting to establish an Applications File Server connection with the node FNDFS_. There may be a network configuration problem, or the TNS listener on node FNDFS_ may not be running. Please contact your system administrator.

Cause : The RRA is Not Enabled in the Profile Option.

Solution :

In the Profile Option –>system –> RRA ->RRA: Enabled is set as No in Site Level. Make it to Yes.

Save and Logout and Retest the Issue.

Posted in E-Business Suite R12 | 2 Comments »

To Change Oracle Logo in Forms

Posted by appsinfo on April 19, 2010

How to Change Standard Oracle Logo in R12 Forms?

Many times there will be request from client to change standard oracle logo in forms. You can change this logo by following below steps: 

1.- Open the file $INST_TOP/ora/10.1.2/forms/server/appsweb.cfg

2.- Check the baseHTML and baseHTMLJInitiator variables inside the file. They point to theappsbase.htm file used in the forms (ussually is the same file for both)

3.- Open the file(s) pointed by those variables

4.- Go to the “// Forms Applet Parameters” section related to the client browser you use

5.- Check if there’s a line that references to “PARAM”. An example of how that line mustbe for Internet Explorer is:

IEhtml += ‘<‘ + ‘PARAM value=”‘ + xlogo + ‘”>’;
add or change that line according to what you have and what you want.

6.- Go to the “// Oracle Applications default Parameters” section in the same file

7.- Add or edit the definition of xlogo variable. It must be:var xlogo = “%logo%”

8.- Save the file(s)

9.- Locate the variable “logo” in $INST_TOP/ora/10.1.2/forms/server/appsweb.cfg file at the “;Forms Server Information: servlet, port, machine name and domain” section. If it’s not there thenyou can create the line. The variable must point to the .gif file you want to add on the forms.You must put the .gif file in
and $OA_JAVA paths and point the “logo”variable to your file with:logo=

10.- Bounce Forms and Apache servers for the changes to take effect11.- Open a new browser window on your client desktop and test the forms.

Posted in E-Business Suite R12 | Leave a Comment »

Create Custom TOP in R12

Posted by appsinfo on January 27, 2010


For customizations you need to create custom top inorder to create all the custom objects and custom menus, responsibilities.

1. Create directory structure in $APPL_TOP


`– 12.0.0

    |– admin

    |   |– driver

    |   |– odf

    |   |– sql

    |   `– template

    |– bin

    |– forms

    |   `– US

    |– help

    |– html

    |– java

    |– lib

    |– log

    |– mds

    |– media

    |– mesg

    |– out

    |– patch

    |– reports

    |   `– US

    `– sql

 2) Add the custom module into the environment


 vi customtest_appsvis1.env


export XXRLT_TOP

source the environment file ( /sandb1/oracle/TEST/apps/apps_st/appl/APPSTEST_pkgtest.env )

 Make entry to context file



 cd $INST_TOP/admin/install


 Open new session, source environment file, and stop middle tier services, run autoconfig

Open new session, source environment file, check for custom top in topfile.txt in $APPL_TOP/admin, start the middle tier services.

 3) Create Tablespace

  create tablespace XXRLT datafile ‘/sandb1/oracle/TEST/db/apps_st/data/xxrlt01.dbf’ size 500M

 4) Create USER

  create user xxrlt identified by xxrlt

default tablespace xxrlt

temporary tablespace temp1

quota unlimited on xxrlt

grant connect, resource to xxrlt;

 5) Register your Oracle Schema

 Login to Applications with System Administrator responsibility

Navigate to Application–>Register

Application = XXRLT Custom Application

Short Name = XXRLT

Basepath = XXRLT_TOP

Description = XXRLT Custom Application

 6) Register Oracle User

 Naviate to Security–>Oracle–>Register

Database User Name = XXRLT

Password = XXRLT

Privilege = Enabled

Install Group = 0

Description = XXRLT Custom Application User

 7) Add Application to a Data Group

 Navigate to Security–>Oracle–>DataGroup

Data Group = XXRLTGroup

Description = XXRLT Custom Data Group

Click on “Copy Applications from” and pick Standard data Group, then add the following entry.

Application = XXRLT Custom

Oracle ID = APPS

Description = XXRLT Custom Application

 8) Create custom request group

 This will act as a placeholder for any custom reports we wish to make available for the Custom Responsibility (which is defined at a later stage)

Navigate to Security–>responsbility–>Request

Group = XXRLT Request Group

Application = XXRLT Custom

Code = XXRLT

Description = XXRLT Custom Requests

We will not define any requests to add to the group at this stage, but you can add some now if required.

 9) Create custom menu

 This will act as a placeholder for any menu items we wish to make available for the Custom Responsibility (which is defined at a later stage). We will create

 two menus, one for Core Applications and one for Self Service.

Navigate to Application–>Menu


User Menu Name = XXRLT Custom Application

Menu Type =

Description = XXRLT Custom Application Menu

Seq = 100

Prompt = View Requests

Submenu =

Function = View All Concurrent Requests

Description = View Requests

 Seq = 110

Prompt = Run Requests

Submenu =

Function = Requests: Submit

Description = Submit Requests


User Menu Name = XXRLT Custom Application SSWA

Menu Type =

Description = XXRLT Custom Application Menu for SSWA

 10) Create new responsibility. One for Core Applications and One for Self Service (SSWA)

 Navigate to Security–>Responsibility–>Define

Responsibility Name = XXRLT Custom

Application = XXRLT Custom

Responsibility Key = XXRLTCUSTOM

Description = XXRLT Custom Responsibility

Available From = Oracle Applications

Data Group Name = XXRLTGroup

Data Group Application = XXRLT Custom

Menu = XXRLT Custom Application

Request Group Name = XXRLT Request Group

 Responsibility Name = XXRLT Custom SSWA

Application = XXRLT Custom

Responsibility Key = XXRLTCUSTOMSSWA

Description = XXRLT Custom Responsibility SSWA

Available From = Oracle Self Service Web Applications

Data Group Name = XXRLTGroup

Data Group Application = XXRLT Custom

Menu = XXRLT Custom Application SSWA

Request Group Name = XXRLT Request Group

 11) Add responsibility to user

 Navigate to Security–>User–>Define

Add XXRLT Custom responsibility to users as required.

 12) Other considerations

 You are now ready to create your database Objects, custom Reports, Forms, Packages, etc

 Create the source code files in the XXRLT_TOP directory appropriate for the type of object. For example forms would be located in $XXRLT_TOP/forms/US or

 package source code in $XXRLT_TOP/admin/sql for example.

 Database Objects, such as tables, indexes and sequences should be created in the XXRLT schema, and then you need to

a) Grant all privilege from each custom data object to the APPS schema.

For example : logged in as XXRLT user

grant all privileges on myTable to apps;

 b) Create a synonym in APPS for each custom data object

For example : logged in as APPS user

create synonym myTable for XXRLT.myTable;

 13) Login to sysadmin, Application Developer Responsibility

 Application > Form ( Register the form )

Application > Funtion ( Add the form to a function )

Application > Menu ( Attach the function to a menu )

 Menu that is added to a particular responsbility is given to specific user

Security > User > Define

Posted in E-Business Suite R12 | 4 Comments »