Friday, August 23, 2013
Report Manager Troubleshooting (Doc ID 858505.1)
How to find the XML file created by the FSG?
How to find the XML file created by the FSG?
SELECT OUTFILE_NODE_NAME, OUTFILE_NAME
FROM APPLSYS.FND_CONCURRENT_REQUESTS
WHERE REQUEST_ID= :fsg_request_id
FROM APPLSYS.FND_CONCURRENT_REQUESTS
WHERE REQUEST_ID= :fsg_request_id
How to get Setup information?
How to get Setup information?
There is a Functional Setup Test available to review setup and version information.
This information is shown by running the BNE Admin Servlet.
It shows the BNE Code Level, Java Version and Log Information sections.
There is also a link to clear the BNE Cache. At the bottom of the page you should see 'Cache Cleared' after clicking on the link.
The BNE Admin Servlet can also be used to set the BNE:log-level and to monitor the size and location of your log file.
More information can be found here:
On the Middle Tier file system where the BNE resides, check the webadi.properties under $BNE_TOP/conf.
Check all the path's are correct in the BNE properties file.
Log in to the Applications as the System Administrator and
- Navigate to Applications - Function,
- Query the %BNE%
- Check the Function BNE_CREATE_DOCUMENT and
make sure the correct Web HTML call is to the Servlet BneApplicationService and
that the Web Host is set to the correct host.
There is a Functional Setup Test available to review setup and version information.
This information is shown by running the BNE Admin Servlet.
BNE ADMIN Servlet for 11i
http://hostname:portnumber/oa_servlets/oracle.apps.bne.framework.BneAdminServlet
BNE ADMIN Servlet for 12
http://hostname:portnumber/OA_HTML/BneAdminServlet
http://hostname:portnumber/oa_servlets/oracle.apps.bne.framework.BneAdminServlet
BNE ADMIN Servlet for 12
http://hostname:portnumber/OA_HTML/BneAdminServlet
It shows the BNE Code Level, Java Version and Log Information sections.
There is also a link to clear the BNE Cache. At the bottom of the page you should see 'Cache Cleared' after clicking on the link.
The BNE Admin Servlet can also be used to set the BNE:log-level and to monitor the size and location of your log file.
More information can be found here:
On the Middle Tier file system where the BNE resides, check the webadi.properties under $BNE_TOP/conf.
Check all the path's are correct in the BNE properties file.
Log in to the Applications as the System Administrator and
- Navigate to Applications - Function,
- Query the %BNE%
- Check the Function BNE_CREATE_DOCUMENT and
make sure the correct Web HTML call is to the Servlet BneApplicationService and
that the Web Host is set to the correct host.
APP-FND-01564: ORACLE Error 6550 In changepassword With Portal/Login Server/SSO After Patch
APP-FND-01564: ORACLE Error 6550 In changepassword With Portal/Login Server/SSO After Patch
APP-FND-01564: ORACLE error 6550 in changepassword
Cause: changepassword failed due to ORA-06550: line 1, column 7:
PLS-00201: identifier 'FND_SSO_REGISTRATION.IS_OPERATION_ALLOWED' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "APPS.FND_LDAP_WRAPPER", line 1190
Soln:
For instances integrated with Portal 3.0.9 from ATG_PF.H.RUP3 and above the profile option Applications SSO LDAP Synchronization (APPS_SSO_LDAP_SYNC) needs to be set to "Disabled".
Cause: changepassword failed due to ORA-06550: line 1, column 7:
PLS-00201: identifier 'FND_SSO_REGISTRATION.IS_OPERATION_ALLOWED' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "APPS.FND_LDAP_WRAPPER", line 1190
Soln:
For instances integrated with Portal 3.0.9 from ATG_PF.H.RUP3 and above the profile option Applications SSO LDAP Synchronization (APPS_SSO_LDAP_SYNC) needs to be set to "Disabled".
Monday, August 12, 2013
Error 'Java.Lang.Unsatisfiedlinkerror: Jmisc' While Integrating Oid With Ebs R12
When attempting to register OID with E-Business Suite R12 on IBM AIX environment, the following error occurs.
ERROR
java.lang.UnsatisfiedLinkError: jmisc (A file or directory in the path name does
not exist.)
at java.lang.ClassLoader.loadLibraryWithPath(ClassLoader.java:993)
at java.lang.ClassLoader.loadLibraryWithClassLoader(ClassLoader.java:962)
at java.lang.System.loadLibrary(System.java:465)
at oracle.security.misc.C05.c(C05)
at oracle.security.misc.Checksum.SHA(Checksum)
at oracle.ias.repository.IASSchema$Enc.d(IASSchema.java:3076)
at oracle.ias.repository.IASSchema.getDirectoryWriter(IASSchema.java:1263)
at oracle.ias.repository.IASSchema.makeNewOIDEntry(IASSchema.java:1381)
at oracle.ias.repository.SchemaManager.makeNewOIDEntry(SchemaManager.java:820)
at oracle.apps.fnd.txk.ias.oid.Instance.register(Instance.java:916)
at oracle.apps.fnd.txk.ias.Instance.main(Instance.java:91)
Issue happens with both JDK 6 and JDK 5
Soln:
OSSO Task 1: Install E-Business Suite OSSO 10g Integration Patch
Note: If you are integrating Oracle 10gAS OSSO/OID with AIX based Oracle E-Business Suite Release 12, then OID registration will fail. Apply patch 5855635 to AS 10.1.3 ORACLE_HOME of Release 12 if you are using JDK 1.5. If you have upgraded to JDK 1.6, you will need to apply patch 7634476 and 7315871 (for AS 10.1.3.4 and up) instead. Refer Known Issues section and patch readme for more details.
For more details follow the below doc.
ERROR
not exist.)
at java.lang.ClassLoader.loadLibraryWithPath(ClassLoader.java:993)
at java.lang.ClassLoader.loadLibraryWithClassLoader(ClassLoader.java:962)
at java.lang.System.loadLibrary(System.java:465)
at oracle.security.misc.C05.c(C05)
at oracle.security.misc.Checksum.SHA(Checksum)
at oracle.ias.repository.IASSchema$Enc.d(IASSchema.java:3076)
at oracle.ias.repository.IASSchema.getDirectoryWriter(IASSchema.java:1263)
at oracle.ias.repository.IASSchema.makeNewOIDEntry(IASSchema.java:1381)
at oracle.ias.repository.SchemaManager.makeNewOIDEntry(SchemaManager.java:820)
at oracle.apps.fnd.txk.ias.oid.Instance.register(Instance.java:916)
at oracle.apps.fnd.txk.ias.Instance.main(Instance.java:91)
Issue happens with both JDK 6 and JDK 5
Soln:
OSSO Task 1: Install E-Business Suite OSSO 10g Integration Patch
Note: If you are integrating Oracle 10gAS OSSO/OID with AIX based Oracle E-Business Suite Release 12, then OID registration will fail. Apply patch 5855635 to AS 10.1.3 ORACLE_HOME of Release 12 if you are using JDK 1.5. If you have upgraded to JDK 1.6, you will need to apply patch 7634476 and 7315871 (for AS 10.1.3.4 and up) instead. Refer Known Issues section and patch readme for more details.
For more details follow the below doc.
Sso_forced_auth In SSO After Inactivity In R12 EBS After Upgrade From 11i
Sso_forced_auth In SSO After Inactivity In R12 EBS After Upgrade From 11i
After 11i to R12 upgrade login pafte is facing the below error.
Error: sso_forced_auth
Product Version: 12.1.3 version, OID SSO Technologies
Solution:
It is recomended not to change default behaviour but if you want to change SSO Paranoid need to be disabled following steps will help.
Steps to disable SSO Paranoid mode:
Update the Context File as given below:
1.1. Login to Oracle E-Business Suite as the sysadmin user .
1.2. System Administration (responsibility) > Oracle Applications Manager >Autoconfig
1.3. Edit Parameters for Applications Tier row
1.4. Search bar select OA_VAR then enter 's_oacore_jvm_start_options' in the search field and click Go
1.5. Add following text to the end of the current value: ' -Doracle.apps.fnd.sso.forcedAuth=false'
1.6. Save
Run autoconfig in all application tiers
Restart all application tier services.
For more info follow below doc.
Error: Sso_forced_auth In SSO After Inactivity In R12 EBS After Upgrade From 11i (Doc ID 1512429.1)
Error While using the Microsoft Internet Explorer 8 or IE 8 to access your Release 12.1.x E-Business-Suite Instances
Error While using the Microsoft Internet Explorer 8 or IE 8 to access your Release 12.1.x E-Business-Suite Instances
Giving the below error
....
Unable to authenticate session
...
When we going to use multiple instance in a browser. Mainly after logging out form production and logging into Developemnt or Test instance.
Soln.
To retain the use of multiple sessions to the same Oracle E-Business Suite environment with IE8 and higher please use one of the workarounds below to ensure each browser session remains independent;
1.Open a new explorer window using its own session cookie by selecting File -> New Session from the Menu Bar in an existing browser window. (IE9 Users may have to enable the Menu Bar first by right clicking the browser header frame and selecting Menu Bar.)
2.Run from the command line adding the -noframemerging parameter e.g. Start -> Run -> iexplore -noframemerging
3.Create a new IE8 icon adding the -noframemerging parameter e.g.
4.Start -> Program Files
5.Right click on the Internet Explorer icon and select Properties
6.Add -noframemerging to the end of the link in the Target field e.g."C:\Program Files\Internet Explorer\iexplore.exe" -noframemerging
7.Click the OK button to close the window
8.This icon may then be copied to the desktop if desired
2.Run from the command line adding the -noframemerging parameter e.g. Start -> Run -> iexplore -noframemerging
3.Create a new IE8 icon adding the -noframemerging parameter e.g.
4.Start -> Program Files
5.Right click on the Internet Explorer icon and select Properties
6.Add -noframemerging to the end of the link in the Target field e.g."C:\Program Files\Internet Explorer\iexplore.exe" -noframemerging
7.Click the OK button to close the window
8.This icon may then be copied to the desktop if desired
How to generate DBC file in R12 EBS
How to generate DBC file in EBS R12?
java oracle.apps.fnd.security.AdminAppServer apps/apps ADD FNDNAM=apps GWYUID=applsyspub/pub TWO_TASK=DATABASE_NAME SECURE_PATH=$FND_TOP/secure GUEST_USER_PWD=guest/oracle APPS_JDBC_DRIVER_TYPE=THIN DB_HOST=db_host_name DB_PORT=db_port
java oracle.apps.fnd.security.AdminAppServer apps/apps ADD FNDNAM=apps GWYUID=applsyspub/pub TWO_TASK=DATABASE_NAME SECURE_PATH=$FND_TOP/secure GUEST_USER_PWD=guest/oracle APPS_JDBC_DRIVER_TYPE=THIN DB_HOST=db_host_name DB_PORT=db_port
Saturday, August 10, 2013
ORA-03135: connection lost contact
ORA-03135: connection
lost contact
Process ID: 12750
Session ID: 133 Serial number: 37557
Solutions:
Process ID: 12750
Session ID: 133 Serial number: 37557
Solutions:
ORA-03135: connection lost contact error will come due to two
reasons.
1) Server unexpectedly terminated or was forced to terminate.
2) Server timed out the connection.
2) Server timed out the connection.
S.No
|
File Name
|
Parameter
|
New Value
|
|
1
|
Sqlnet.ora
|
Expire_time
|
30
|
|
2
|
Sqlnet.ora
|
inbound_connect_timeout
|
0
|
|
3
|
listener.ora
|
inbound_connect_timeout_listenername
|
0
|
How to check mwa.cfg file in R12 EBS
How to check mwa.cfg file in R12 EBS
[oratest@EBS-TEST-APP1 ~]$ cd $INST_TOP/admin/install/
[oratest@EBS-TEST-APP1 install]$ strings -a mwa.cfg | grep Log################## Logging ######################################
# Log directory. Should be pointing to the standard
# System Log file name.
mwa.SystemLog=system.log
# LogLevel: Different log levels can be set for obtaining
mwa.LogLevel=error
mwa.EnableLogRotation=Yes
# when log file exceeds MaxLogFileSize
mwa.MaxLogFileSize=10000000
[oratest@EBS-TEST-APP1 install]$
REP-57054: In-process job terminated:Finished successfully but output is voided
REP-57054: In-process job terminated:Finished successfully but output is voided
This error happens while running a reports in R12 EBS.
Follow the below steps to resolve the issue.
1. Apply patch 8602992 in order to avoid cache file growth and/or being clobbered by Autoconfig.
See Doc ID 859255.1, "This change will be lost when Autoconfig is run. Apply patch 8602992 as soon as it becomes available."
2. Add the "noVoidedOutputError" property name and value to the file $INST_TOP/ora/10.1.2/reports/conf/rwbuilder.conf
See Doc ID 859255.1, "This change will be lost when Autoconfig is run. Apply patch 8602992 as soon as it becomes available."
2. Add the "noVoidedOutputError" property name and value to the file $INST_TOP/ora/10.1.2/reports/conf/rwbuilder.conf
Subscribe to:
Posts (Atom)
Command to do active duplicate for Oracle Database
1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...
-
Srvctl is not able to start database [oracle@orcldb-n2 ~]$ srvctl start database -d orcl PRCR-1079 : Failed to start resource ora.orcl.d...
-
Getting below error in EBS R12.1.3 in Oracle Database SMTP Error. Getting below error while trying to send email in XXXXXXX instance ...
-
Oracle R12 application and getting following error when trying to launch General Ledger Account Hierarchy Manager Java Plug-in 1.6.0_07 Us...