Showing posts with label R12-Issue. Show all posts
Showing posts with label R12-Issue. Show all posts

Monday, July 20, 2009

FRM-92050 Error with Internet Explorer-8


While using oracle applications R12 with Internet Explrer 8 an Form Server related error is encountered (FRM-92050: Failed to connect to the server).To, avoid this problem Disable the XSS Filter option in IE8.

Tools--> Internet options--> Security-->Security level for this zone --> Custom level-->Disable XSS filter

Now there is no issue with Error FRM-92050

Sunday, July 12, 2009

ORA-12701: CREATE DATABASE character set is not known

While Starting the database, I had faced the error - ORA-1092 signalled during: ALTER DATABASE OPEN...
then check in the Alert.log it shows the messages like below:
ORA-12701: CREATE DATABASE character set is not known
Thu Jul 9 19:10:14 2009
Error 12701 happened during db open, shutting down database
USER: terminating instance due to error 12701
Instance terminated by USER, pid = 28018
ORA-1092 signalled during: ALTER DATABASE OPEN...

Solution:
I had checked $ORA_NLS10 path. Instead of “$ORACLE_HOME/nls/data/9idata”,
it points to the Wrong one like below:

echo $ORA_NLS10
ORA_NLS10=/aplvol01/CRP/oracle/CRP/db/tech_st/10.2.0/ocommon/nls/admin/data

Change the env file to the correct path and start the database.

wferr: - 1602: Could not save. - 1400: Could not save to database. MODE=UPGRADE EFFDATE=

While Applying the 8310984 - May 2009, Order Management R12 Cumulative Patch on R12.0.6, worker is failed with the below mentioned error:

ATTENTION: All workers either have failed or are waiting:
FAILED: file oexwford.wft on worker 1.
Worker Log file:
wferr:
- 1602: Could not save.
- 1400: Could not save to database. MODE=UPGRADE EFFDATE=
- 1404: Please first load this entity or check protect and custom level of ACTIVITY 'WFSTD/FED_BUILD_PA_AP_INVO_ACCT_GEN'.
Oracle Workflow Definition Loader 2.6.4.0.
Access level: 20, Mode: UPGRADE
ITEM_TYPE 'WFSTD' is protected, no changes were saved.
ITEM_ATTRIBUTE 'WFSTD/EVENTNAME' is protected, no changes were saved.
ITEM_ATTRIBUTE 'WFSTD/REQUESTOR_USERNAME' is protected, no changes were saved.
ITEM_ATTRIBUTE 'WFSTD/OWNER_ROLE' is protected, no changes were saved.
ITEM_ATTRIBUTE 'WFSTD/FORWARD_FROM_DISPLAY_NAME' is protected, no changes were saved.
ITEM_ATTRIBUTE 'WFSTD/N' is protected, no changes were saved.

Solution:
Change the Patch driver file related WFLOAD command from UPGRADE to FORCE.

Before Modify:
# file-version-parsed ont patch/115/import/US oexwford.wft 120.8.12000000.10

exec fnd bin WFLOAD bin &phase=daa+52 checkfile:ont:patch/115/import/US:oexwford.wft &ui_apps 0 Y UPGRADE @ONT:patch/115/import/US/oexwford.wft

After Modify:
# file-version-parsed ont patch/115/import/US oexwford.wft 120.8.12000000.10

exec fnd bin WFLOAD bin &phase=daa+52 checkfile:ont:patch/115/import/US:oexwford.wft &ui_apps 0 Y FORCE @ONT:patch/115/import/US/oexwford.wft

Tuesday, September 23, 2008

JSP Pages Hanging in R12 After Removing Cached Class Files in _pages

In Release 12 after Removing the compiled class files from the JSP pages in the directory $COMMON_TOP/_pages and Bounce of Apache server,calling JSP pages results in hanging 'blank' screen.

In Release 11i when performing the same steps new class files are created automatically when the JSP page is called from a browser session and JSP was rendered fine.

In Release 12 it's observed that when calling the JSP no class file is created in the diretciry $COMMON_TOP/_pages

1. Change the value for the main_mode parameter to recompile (instead of justrun)

This can be achieved by doing the following actions
• Use the Context editor to change the value for "s_jsp_main_mode" in the .xml file used by autoconfig and change value from justrun to recompile
• Run Autoconfig to propagate the changes to the configuration files
• Verify that now the $INST_TOP/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml has


main_mode
recompile


• Test the scenario failing before.
• See that now a new _.class is created when the JSP page is called.

After A Clone, Blank AppsLogin / AppsLocalLogin Page in R12?

while try to access the Applications we are facing the Blank Apps Login, After Completion of the clone Successfully.

The cause might be explained because if the system was not able to access the classes this may have as root cause jsp / class corruption or wrong $CLASSPATH.

To implement the solution, please execute the following steps:

A. Set the JSP compilation to Automatic using the following steps:
1. Use the vi editor to edit the $CONTEXT_NAME.xml context file and change the value for "s_jsp_main_mode" from "justrun"or “Compile” to "recompile"
Note: Backup the context file before editing it.

2. Run Autoconfig to propagate the changes to the configuration files.

3. Verify that now the
$INST_TOP/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml has


main_mode
recompile


4. Restart the Middle Tier services and access the applications to load JSP's which will cause them to be recompiled on the run.
5. After successfully accessing the applications, use the vi editor to edit the $CONTEXT_NAME.xml and revert the value for "s_jsp_main_mode" to "justrun" in order not to hamper the performance of your system.
6. Run AutoConfig to propagate the changes.

An error occurred while retrieving Oracle Applications Help information

Hi
we have upgraded our financials to Rollup 5 in R12.0.4 Instance.
Recently our Functional Consultant had find out Oracle Applications Help information is not retrieving

Error is appearing like the below mentioned.

404 NOT FOUND

An error occurred while retrieving Oracle Applications Help information

Help target US/AP/@APXINWKB_INVOICES_SUM_FOLDER_WINDOW could not be found.

Solution:

Apply the Financials Rollup 5 Help(p6941569_R12_GENERIC.zip) patch.

while applying the Financials Rollup5 patch,we have ignored to apply that patch.

Srinivas Ramineni.
Oracle Apps DBA