NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

Checking Forms Server is in Socket mode or Servlet Mode

No comments
We have certain ways through which we can check if the forms is in servlet mode or socket mode.

R12

$grep connectMode $FORMS_WEB_CONFIG_FILE
connectMode=servlet

or 


$ grep s_frmConnectMode $CONTEXT_FILE
                        <forms_connect oa_var="s_frmConnectMode">servlet</forms_connect>


11i

$ grep connectMode $FORMS60_WEB_CONFIG_FILE
connectMode=socket


or

$ grep s_frmConnectMode $CONTEXT_FILE
         <forms_connect oa_var="s_frmConnectMode">socket</forms_connect>

From Frontend

- Check "connectMode" in Jinitiator Console Window

No comments :

Post a Comment

FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508

No comments
Error:

FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508

Cause:
This may be occur while opening forms after clone or if the CUSTOM.pll and CUSTOM.plx files may be missing or got corrupted.
One more reasons may be that the forms path is not properly defined.


Solution:


Copy  the custom.pll and custom.plx files  from backup location to the $AU_TOP/resource directory structure.

Verify that the $FORMS60_PATH or FORMS_PATH has the correct path to the resource directory in the SID_HOSTNAME.env file in APPL TOP.

i.e
FORMS60_PATH=$AU_TOP/resource:$AU_TOP/forms/US:$AU_TOP/resource/US
export FORMS60_PATH

or

FORMS_PATH=$AU_TOP/resource:$AU_TOP/forms/US:$AU_TOP/resource/US
export FORMS_PATH

No comments :

Post a Comment

Finding Value Set name from Flex value

No comments
Below command can be used for finding the value set name from a know flex value.


select ff.flex_value_set_id ,ff.flex_value_set_name,fv.flex_value
from apps.fnd_flex_values fv , apps.fnd_flex_value_sets ff
where ff.flex_value_set_id = fv.flex_value_set_id
and (
upper(attribute1) like '%&&VALUE_SET_VALUE%'
or upper(attribute2) like '%&&VALUE_SET_VALUE%'
or upper(attribute3) like '%&&VALUE_SET_VALUE%'
or upper(attribute4) like '%&&VALUE_SET_VALUE%'
or upper(attribute5) like '%&&VALUE_SET_VALUE%'
or upper(attribute6) like '%&&VALUE_SET_VALUE%'
or upper(attribute7) like '%&&VALUE_SET_VALUE%'
or upper(attribute8) like '%&&VALUE_SET_VALUE%'
or upper(attribute9) like '%&&VALUE_SET_VALUE%'
or upper(attribute10) like '%&&VALUE_SET_VALUE%');

No comments :

Post a Comment

Creating Custom Top in Oracle Application

No comments
Below are the steps to create custom top in Oracle Application 

Step 1: Go to  APPL_TOP Dircetory in UNIX

Cd $APPL_TOP

Step 2: Create Custom Top Under APPL_TOP Dir

Mkdir CUSTNAME_TOP (Name of Directory)

Make sure all the files and Directories are same as Other Product Dir.

Step 3: Add Custom Top entry in APPLSYS.env file

Step 4: Login Oracle apps using SYSADMIN or AOL

Navigate: Applications->Register

Add your Custom top Entry Here

Application: CustomeApplication name

Short name: CUSTNAME

BasePath: CUSTNAME_TOP

Description: CustomApplication.

Step 5: Restart the Internal Concurrent Manager (ICM) for New Changes to take effect.

Step 6: Validate Custom Entry in

Select BASEPATH,PRODUCT_CODE,APPLICATION_SHORT_NAME

From fnd_application

Where application_Short_name like 'CUSTNAME_TOP%'

No comments :

Post a Comment

There was an error while opening the file store file “_WLS_ADMINSERVER000000.DAT”

No comments
If we are facing an error like 

<Error> <Store> <BEA-280061> <The persistent store “_WLS_AdminServer” could not be deployed: weblogic.store.PersistentStoreException: java.io.IOException: [Store:280021]There was an error while opening the file store file “_WLS_ADMINSERVER000000.DAT”


Solution

The may be *.lok and *.DAT files which need to be removed.

Command

find . -name "*.DAT" -print -exec rm {} \;
find . -name "*.lok" -print -exec rm {} \;


These has to be removed form $DOMAIN_HOME for Admin Server and Managed Server

No comments :

Post a Comment