Thursday, 24 May 2012

Where are profile options stored

 

Tables of  Profile Options:


FND_PROFILE_OPTIONS
FND_PROFILE_OPTION_VALUES
FND_PROFILE_OPTIONS_TL
Posted by at No comments:

Wednesday, 23 May 2012

Responsibility Not Visible to user in the list of responsibilites assigned to User:

Recently came to know that though the system adminstrator is given the responsibility access to users, users are not able to view the responsibilities in the list of responsibilities assigned.

1. Check if the responsibility is not end dated.
2. Run the request " Syn responsibility role data into the WF table".
3. Run the request " Synchronize WF LOCAL tables" enter the paramters
- Orig System: ALL
- Parallel Process:0
- Logging Mode: LOGGING (Logging Activated)
- Temporary Tablespace : Blank
- Riase Errors: Yes
4. Run the request "Workflow Directory Services User/Role Validation" enter the paramters
- p_BatchSize:10000
- Fix dangling user/roles : Yes
- Add missing user/role assignments : Yes
- Update WHO columns in WF tables: Yes
5. Log off and login back and verify that the responsibility appears.

That should resolve the issue.

If the problem is not resolved still ask the sysadmin to start the following servives
Navigation: System Administrator > Workflow > Oracle application manager > Workflow Manager
- Workflow Deffered Notification Agent Listner
- Workflow Error Agent Listner
- Workflow Java Deffered Agent Listner
- Workflow Java Error Agent Listner.
In case still there is a issue please raise a Service request with Oracle.
Posted by at 1 comment:

Monday, 21 May 2012

Error:  Viewing CM log files – “File server could not verify its initialization parameters” – Oracle Apps 11i

Some times we face following error while viewing CM log files from Concurrent Manager Administer screen.

               ‘File server could not verify its initialization parameters’

Cause:

The issue is because of the syntax error in listener.ora file on appmgr side.
If you check the parameter APPLFSTT in listener.ora on appmgr side (cd $TNS_ADMIN),
you will see there is a space between the value.

Example:

APPLFSTT=PQP10MS6_806_BALANCE; PQP10MS6_FO; PQP10MS6_BALANCE; PQP10MS6

FNDFS cannot interpret the space between the value

Workaround:

Remove the space between the values and bounce apps listener.

Permanent Fix:

As per metalink note ID 304568.1, apply patch 4244610 to the environment.
Posted by at No comments:
Scenario: Enable FRD(Forms Runtime Diagonostic) Trace


Solution:

1. Login into SYSADMIN --> System Administrator --> Profile --> System
Search the profile option for "ICX Forms Launcher" and Make sure Site and User leave has been checked.

2. Set the value following values at user level only according to the version

3. For R12, http://url:/OA_HTML/frmservlet?record=collect

4. For 11i, http://url:/dev60cgi/f60cgi?&record=collect&log=<>

5. Get the FRD trace from $FORMS_TRACE_DIR path at OS Level
Posted by at No comments:

APP-FND-01542 : This Application Server is not authorized to access this system

Scenario:
======= When you are trying to access the Front end URL it is not giving some error. So , you are using http://hostname:port/dev60cgi/f60cgi and trying to login to the server which gives the following error.

Error:
=====
“APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your System Administrator. ”

Solution:
=======
Step 1 : Edit the Context file ie) $APPL_TOP/admin/SID_hostname.xml.
Step 2 : Change the Variable : s_appserverid_authentication to be OFF.Step
3 : Run Autoconfig $ cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME$ sh adautocfg.sh

Now, you can test the application login.

Note :
=====

There are three modes of authentication you can configure your applications by setting the parameter
s_appserverid_authentication to ON :
s_appserverid_authentication to Partial
s_appserverid_authentication to SECURE : activates full server security (SECURE mode)
s_appserverid_authentication to OFF : deactivates server security
By default in 11.5.10, this is set to SECURE. In previous 11i versions, this wasset to OFF.
Posted by at No comments:
Scenario:

=========

While applying a big patch, suddenly it has been failed due to some prereq patch is missing.

Solution:

1. Shutdown the workers using "adctrl" utility.

a. adctrl 

-- It will ask some prompts and enter those


Select option "Tell worker to shutdown/quit"


2. Backup the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema


a. sqlplus applsys/

b. create table fnd_Install_processes_back as select * from fnd_Install_processes;

c. The 2 tables should have the same number of records. select count(*) from fnd_Install_processes_back; select count(*) from fnd_Install_processes;


3. Backup the AD_DEFERRED_JOBS table.


a. sqlplus applsys/

b. create table AD_DEFERRED_JOBS_back as select * from AD_DEFERRED_JOBS;

c. The 2 tables should have the same number of records. select count(*) from AD_DEFERRED_JOBS_back; select count(*) from AD_DEFERRED_JOBS;


4. Backup the .rf9 files located in $APPL_TOP/admin/restart directory.

At this point, the adpatch session should have ended and the cursor should be back at the Unix prompt.


a. cd $APPL_TOP/admin/

b. mv restart restart_orig

c. mkdir restart


5. Drop the FND_INSTALL_PROCESSES table and the AD_DEFERRED_JOBS table.


a. sqlplus applsys/

b. drop table FND_INSTALL_PROCESSES;

c. drop table AD_DEFERRED_JOBS;


6. Apply the new patch.


7. Restore the .rf9 files located in $APPL_TOP/admin//restart_back directory.


a. cd $APPL_TOP/admin/

b. mv restart restart_

c. mv restart_orig restart


8. Restore the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema.


a. sqlplus applsys/

b. create table fnd_Install_processes as select * from fnd_Install_processes_back;

c. The 2 tables should have the same number of records. select count(*) from fnd_Install_processes; select count(*) from fnd_Install_processes_back;


9. Restore the AD_DEFERRED_JOBS table.


a. sqlplus applsys/passwd

b. create table AD_DEFERRED_JOBS as select * from AD_DEFERRED_JOBS_back;

c. The 2 tables should have the same number of records. select count(*) from AD_DEFERRED_JOBS_back; select count(*) from AD_DEFERRED_JOBS;


10. Re-create synonyms


a. sqlplus apps/apps

b. create synonym AD_DEFERRED_JOBS for APPLSYS.AD_DEFERRED_JOBS;

c. create synonym FND_INSTALL_PROCESSES FOR APPLSYS.FND_INSTALL_PROCESSES;
Posted by at No comments:
Scenario: While exporting file from front-end, got error like below:

fndgfm.jsp error :  Java Exception<pre>java.lang.NullPointerException      at _fndgfm.getExportFileExtn(_fndgfm.java:275)      at _fndgfm.downloadBlob(_fndgfm.java:187)      at _fndgfm._jspService(_fndgfm.java:585)      at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)      at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)      at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)      at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)      at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)      at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)      at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)      at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)      at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)      at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)      at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)      at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)      at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)      at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)      at java.lang.Thread.run(Thread.java:619)</pre>



Solution:


Export To Excel failed, fndgfm.jsp Error [ID 1364656.1]

Modified 05-OCT-2011     Type PROBLEM     Status PUBLISHED

In this Document
  Symptoms
  Cause
  Solution
  References
Applies to:
Oracle Application Object Library - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.
Symptoms
Export to Excel errors for all type data



=== ERROR Message in Excel file ===

fndgfm.jsp error : Java Exception
<pre>
java.lang.NullPointerException
at _fndgfm.getExportFileExtn(_fndgfm.java:287)
at _fndgfm.downloadBlob(_fndgfm.java:188)
at _fndgfm._jspService(_fndgfm.java:591)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
</pre>
Cause
Either Patch:12675589 is needed
or JSPs are out of sync.
Solution
  1. Please make sure that Patch:12675589
                   - ONE-OFF: FORMS INLINE ATTACHMENT which contains fndgfm.jsp 120.17.12010000.10
    is applied
  2. Please re-compiled all JSP's.
    For details, please see     Note:783094.1 - Compile jsp files at Application R12 at Windows


References
NOTE:1356402.1 - EBS Export Creates File Fndgfm.Jsp With java.lang.NullPointerException
NOTE:464469.1 - Export To Excel: How To Activate Debugging?
NOTE:783094.1 - Compile JSP Files Fail on Oracle Application R12 At Windows
NOTE:870221.1 - How To Export Purchase Order (PO) Header And Line Data For Multiple POs From iSupplier?



Posted by at No comments:

Tuesday, 8 May 2012

ORA-04030: out of process memory

SQL> alter package apps.XLA_00200_AAD_S_000010_PKG COMPILE BODY;
alter package apps.XLA_00200_AAD_S_000010_PKG COMPILE BODY
*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 4108 bytes (PLS
non-lib hp,pdzgM64_New_Link)
Solution1.SQL>select object_name,object_type from dba_objects where status='INVALID';
OBJECT_NAME OBJECT_TYPE
----------------------------------- -------------------
XLA_00200_AAD_S_000010_PKG PACKAGE BODY
XLA_00200_AAD_S_000011_PKG PACKAGE BODY

2. SQL> alter system set plsql_optimize_level =0;
System altered.
3.SQL> alter package apps.XLA_00200_AAD_S_000010_PKG COMPILE BODY;
Package body altered.

4.SQL> alter package apps.XLA_00200_AAD_S_0000011_PKG COMPILE BODY;
Package body altered.

5.SQL> alter system set plsql_optimize_level =2;
System altered.
Posted by at No comments:

Enable Trace in Oracle E-Business Suite R12

Debugging tool for HTTP, OC4J and OPMN in E-Business Suite R12

How To Enable and Collect Debug for HTTP, OC4J and OPMN
Shutdown the http server, oc4j and opmn services

adapcctl.sh stop
adoacorectl.sh stop
adformsctl.sh stop
adoafmctl.sh stop
adopmnctl.sh stop

Enable http ODL logging
-----------------------
$ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf/httpd.conf
OraLogMode oracleOraLogSeverity TRACE:32OraLogDir $LOG_HOME/ora/10.1.3/Apache/oracle


Please use the full path to $LOG_HOME e.g. OraLogDir /u01/inst/apps/JCB_atg/logs/ora/10.1.3/Apache/oracle

mkdir $LOG_HOME/ora/10.1.3/Apache/oracle
Increase OC4J logging for oacore
-------------------------------
edit j2ee-logging.xml adjust the following in file:

$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/config/j2ee-logging.xml


Posted by at No comments:

How To License A New Product in Oracle Applications

1. After purchasing a license for an Application Product/Module, the first thing is to use license manager to record that the product/module is now licensed.  License manager can be run 2 ways:
a. log in through Oracle Application Manager (OAM) and select Site Map -> Administration tab -> License Manager
b. run adlicmgr.sh  from AD_TOP/bin
Using both methods you can license by Module or by individual Product. Select the check box for the Module/Product to be licensed and Save/Next
2. The Products are now licensed but not ready to be used as none of the Forms/Packages etc would have been compiled and loaded into the Database for these new Products.  Use adadmin to generate the files for the new Product/s
a. run adadmin
b. Select Generate Application Files menu
c. Select all of the following Menu options:
- Generate message files
- Generate forms files
- Generate report files
- Generate graphic files
- Generate product JAR files
d. Back to Main Menu
e. Select Compile/Reload Applications Database Entities menu
f. Select all of the following Menu options:
- Compile APPS schema
- Compile menu information
- Compile flexfields
3.  Once complete, check that the Forms/JSPs for the new Products licensed now work.  The Products are now ready to be configured.
4. Run autoconfig.
Posted by at No comments:

Monday, 7 May 2012


CUSTOM_TOP CREATION in R12: Creation of XVIJ_TOP Application

Details :
Application Name : XVIJ Application
Base Path : $XVIJ_TOP
Schema Name : TTS
Tablespace Name (Data) : XXVIJ_TS_TX_DATA
Tablespace Name (Index) : XXVIJ_TS_TX_IDX

è Login as database OS user to create TTS schema for XVIJ Application.

è Set the environment. (if not set in Bash Profile)
è Login into ‘sqlplus as sysdba’



è Create Tablespace for data for TTS Schema as XXVIJ_TS_TX_DATA

create tablespace XXVIJ_TS_TX_DATA datafile '/d01/R12DEMO/oracle/db01/db/apps_st/data/xvij_data1.dbf ' size 500M autoextend on next 100m maxsize 1024m extent management local segment space management auto;

Note: Can give tablespace size based on our environment


è Create Tablespace for Index for TTS Schema as XXVIJ_TS_TX_IDX.


è Create Temporary tablespace for TTS Schema as XXVIJ_TS_TX_TEMP



è Now Create schema named as TTS with the below details:

Username: TTS
Password: tts
Default Tablespace: XXVIJ_TS_TX_DATA
Temporary Tablespace : XXVIJ_TS_TX_TEMP



è Login as OS application user.

è Set the environment if it has not been set in Bash profile.

è Change Directort to $APPL_TOP

è Make the directory structure like below under $APPL_TOP
mkdir xvij
mkdir -p xvij/12.0.0
mkdir -p xvij/12.0.0/ bin
mkdir -p xvij/12.0.0/ out
mkdir -p xvij/12.0.0/log
mkdir -p xvij/12.0.0/admin
mkdir -p xvij/12.0.0/html
mkdir -p xvij/12.0.0/patch
mkdir -p xvij/12.0.0/mds
mkdir -p xvij/12.0.0/reports/US
mkdir -p xvij/12.0.0/sql/ddl
mkdir -p xvij/12.0.0/media
mkdir -p xvij/12.0.0/java
mkdir -p xvij/12.0.0/forms/US
mkdir -p xvij/12.0.0/help
mkdir -p xvij/12.0.0/lib
mkdir -p xvij/12.0.0/mesg


è Change the Directory to $INST_TOP/appl/admin for .xml location and back up the .XML file.

è Edit the original XML file and add the XVIJ top entry as below along with the standard product list

<XVIJ_TOP oa_var="s_xvijtop" oa_type="PROD_TOP"
oa_enabled="FALSE">/d01/R12DEMO/oracle/app01/apps/apps_st/appl/xvij/12.0.0</XVIJ_TOP>


è Change Directory to $ADMIN_SCRIPTS_HOME and execute
adautocfg.sh apps/<apps_pwd>

è After completed autoconfig successfully start the applications.


è Login to applications as “sysadmin” user and select system administrator responsibility.




è Now register our custom application with below details:

Application Name : XVIJ Application
Short Name : XVIJ
Basepath : XVIJ_TOP
Description : XVIJ Application for custom requirement

Navigation: After login system administrator responsibility,

Application->Register (click on Register and enter above details in the form  and save it)


è Register the TTS Schema in the applications. Navigate to

 Security → ORACLE → Register

               

Add the Oracle Schema Details as below and save the information
Database User name : TTS
Password : tts
Privilege : Enabled
Install Group : 1
Description : XVIS Application for custom requirement.



è Now add the Created application in the Standard Datagroup
Navigate to Security → ORACLE → DataGroup


Now Query the Data group as Standard.


Add the application details as below in the data groups form
Application : XVIJ Application
Oracle ID : Apps
Description: XVIJ Application for custom requirement


è Create the Custom Menu
Navigate to  Application-> Menu ( To → Create Custom Menu )

Create the Custom Menu with the following details as below
(Note : The Menu to be created is to provide the facility to run and View Requests only )


Enter the following details and save:

Menu Name : XXVIJ_CUSTOM_MENU
User Menu Name : XXVIJ Custom Menu
Description : XXVIJ Custom Menu For Custom Requirement
Seq = 100
Prompt = View Requests
Function = View All Concurrent Requests
Description = View Requests

Seq = 110
Prompt = Run Requests
Function = Requests: Submit
Description = Submit Requests


After saving we got window like below:


Ensure that the menu has been compiled or not by checking the request id has been completed normal.


è Create A Custom Request Group
Navigate to Security ->Responsibility-> Request
Note : Not required to add any reports to the request group. Based on the requirements the reports can be added to the request group only.

Create the new custom request group as “XXVIJ Request Group” with the
following details:

Group : XXVIJ Request Group
Application : XVIJ Application
Description : XXVIJ Request Group for Custom Requirement
---------Requests Tab can be left blank


è Create A Custom Responsibility for XVIJ Application

Navigate to Security-> Responsibility->Define

Create new custom responsibility as “XTTS Custom Responsibility” with the details as below:

Responsibility Name : XTTS Custom Responsibility
Application Name : XVIJ Application
Responsibility Key : XTTS_CUSTOM_RESP
Description : XTTS Custom Responsibility
Available from : Oracle Applications

Datagroup
Name : Standard
Application : XVIJ Application
Menu : XXVIJ Custom Menu
Request Group
Name : XXVIJ Request Group
Application : XVIJ Application



è Create one user and assign this responsibility to that particular user.

Navigate to Security->User->Define























Posted by at No comments:
Subscribe to: Posts (Atom)