Report Manager Troubleshooting (Doc ID 858505.1)

Report Manager Troubleshooting (Doc ID 858505.1)

 

NOTE:780081.1 - R12: Java Heap Errors when Running An FSG NOTE:1161333.1 - How To Run The Report Manager Excel Template Editor Without Allowing Active X Unsigned Controls?NOTE:827288.1 - Poor Performance In HTML Due To FO GeneratorNOTE:1084826.1 - Cannot view Report Manager Output in ExcelNOTE:1404433.1 - How To Prepare Internet Explorer and Excel For Interaction With Report Manager?NOTE:803014.1 - Repository Maintenance Program Deletes Menus and FunctionsNOTE:1312156.1 - WebADI - Web Applications Desktop Integrator BNE_UIX_PHYSICAL_DIRECTORY is not configured Error in Release 11i and R12NOTE:365409.1 - FRM: in Report Manager Submitting a Standard or Variable Report throws Error with 'Incorrect Validation Type'NOTE:726774.1 - Report Manager - Master NoteNOTE:603169.1 - WebADI and Report Manager Webcasts for EBS 11i/R12 -- Replay is Now AvailableNOTE:1077728.1 - Using Microsoft Office 2007 and 2010 with Oracle E-Business Suite 11i and R12NOTE:726958.1 - Report Manager (FRM) List of PatchesNOTE:1064022.1 - Report Manager: What Controls the Number of Items That Can Be Seen in the Expansion Value LOV?BUG:8576580 - FRENCH : EXCEL OUTPUT DOES NOT GENERATE DATANOTE:1521253.1 - Report Manager Profile Options
 

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

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.

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

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".

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 'Java.Lang.Unsatisfiedlinkerror: Jmisc' While Integrating Oid With Ebs R12 (Doc ID 833433.1) 

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

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

ORA-03135: connection lost contact

ORA-03135: connection lost contact
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.

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