App-fnd-01564 Oracle Error 3114
Contents |
in Production: After entering and validating and invoice and creating the accounting under Payables Invoice workbench, at closing the form, the following messages oracle error 3114 in afprsr-resubmit_time show up: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-01001. Your log on
Routine Afpprd Has Encountered A Fatal Error. Ora-03114: Not Connected To Oracle
session has become invalid. Exiting Oracle Applications. APP-FND-01564: ORACLE error 3114 in auduse Cause: auduse failed due to ORA-03114 audusd : not connected to ORACLE. The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE. Application is closed after that. CAUSE The issue is caused by an ORACLE error in the database. The alert.log file shows the following errors which happened at the time the end user closed the form in Oracle Applications: ORA-00600: internal error code, arguments: [729], [104], [space leak], [], [], [], [], [] SOLUTION Comments -------- === ODM Solution /Action Plan === To implement the solution, please execute the following steps: Since this issue is caused by a problem in the database, you might want to review Note 403584.1 Understanding and Diagnosing ORA-600 [729] Space Leak Errors. If after reviewing the note and performing the following suggestion the error has not been fixed, then kindly open a Service Request with the Server Technologies team and upload the alert.log file. 1. Set the following event in init.ora parameter file. event = "10262 trace name context forever, level 90000" 2. Stop and restart the database. 3. Retest the issue. 4. Migrate the solution as appropriate to other environments. Reactions: Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) About Me Toberosa Tambunan Student of Life View my complete profile Total Popularity Find me in my Linkedin Toberosa Linkedin My Archive ► 2016 (36) ► 09/25 - 10/02 (4) ► 09/18 - 09/25 (1) ► 09/11 - 09/18 (3) ► 09/04 - 09/11 (3) ► 08/14 - 08/21 (5) ► 07/03 - 07/10 (1) ► 04/24 - 05/01 (10) ► 04/17 - 04/24 (1) `
error 1000 in close_server_files During the application of a help patch which was running FNDGFU concurrent requests the worker FAILED and following error was logged in .req file:APP-FND-01564: ORACLE error 1000 in close_server_filesCause: close_server_files failed due to ORA-01000: maximum open cursors exceeded.The SQL statement being executed at the time of the error was: "&SQLSTMT and was executed from the file &ERRFILE".ORACLE error 3114 in afpexcpCause: afpexcp failed due to ORA-03114: not connected to ORACLE.The SQL statement being executed at the time of the error was: and was executed from the file .After some research on metalink, I realized that the DBAs had not set INBOUND_CONNECT_TIMEOUT parameter in http://tobeimpact.blogspot.com/2013/08/when-closing-invoice-workbench-app-fnd.html listener.ora, and the requests were simply timing out. After setting this parameter and setting its value to zero (for patching only), the patch proceeded without issues.An offshoot of this error was ORA-07445 in alert log:ORA-07445: exception encountered: core dump [drumcmf()+184] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []So in 10.2.0.3, do not forget to set INBOUND_CONNECT_TIMEOUT to zero during patching and do not forget to set it back to http://oracleappstechnology.blogspot.com/2008/05/app-fnd-01564-oracle-error-1000-in.html 60, 120 or 240 whichever works best in your environment. Posted by Vikram Das at 8:32 AM Labels: APP-FND-01564, ORA-7445 drumcmf No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) About me Vikram Das, ERP Technical Architect Post Your Questions Here Google Group: Oracle Apps Technology Subscribe via email Enter your email address:Delivered by FeedBurner Subscribe To Posts Atom Posts Comments Atom Comments Disclaimer The postings on this blog are my personal opinions. This content is not read or approved by my current or former employer, before it is posted, and does not necessarily represent their positions, strategies, or opinions. Blogroll Free Oracle Help Puneesh Lamba's Blog Confessions of an IT Hitman Mukul's Oracle Apps Technology blog Tanel Poder's Oracle blog H Tonguc Yilmaz Oracle blog Tom Kyte's blog Eye on Oracle blog Integrigy's Oracle security blog Pete Finnigan's Oracle security blog Niall Litchfield's blog Jonathan Lewis Oracle scratchpad Oracle Pitstop's oracle tech blog Bas Klassen's Oracle Apps blog Atul Kumar's Online Apps DBA Site Anjo Kolk's performance blog Steven Chan's Blog Blog Archive ► 2016 (2) ► March (1) ► January (1) ► 2015 (20) ► December (2) ► November (3) ► October (2) ► September (1) ► June (1) υ
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and https://community.oracle.com/thread/856258?start=15&tstart=0 reload this page. Please enter a title. You can not post http://myappslife.blogspot.com/2011/04/app-fnd-01564-oracle-error-6502-in.html a blank message. Please type your message and try again. More discussions in LCM: R12 Install/Upgrade All PlacesOracle ApplicationsE-Business SuiteE-Business Suite TechnologyLCM: R12 Install/Upgrade This discussion is archived 1 2 Previous Next 22 Replies Latest reply on Feb 12, 2009 9:47 AM by sparrowDCLXVI oracle error Go to original post This content has been marked as final. Show 22 replies 15. Re: R12 Concurrent Managers on XP sparrowDCLXVI Feb 10, 2009 5:42 PM (in response to Hussein Sawwan-Oracle) Hussein What version of R12 are you running? This is 12.0.4. Thanks Alex Like Show 0 Likes(0) Actions 16. Re: R12 Concurrent Managers on oracle error 3114 XP Hussein Sawwan-Oracle Feb 10, 2009 6:16 PM (in response to sparrowDCLXVI) Alex, Same release here. Did you try the steps in my previous reply? Like Show 0 Likes(0) Actions 17. Re: R12 Concurrent Managers on XP sparrowDCLXVI Feb 11, 2009 9:40 AM (in response to Hussein Sawwan-Oracle) Hussein I've completed the steps you suggested, and it's made no difference. Below is the latest CM log file: --------------------------------------------------------------------------- Application Object Library: Concurrent Processing version 11.5 Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. Internal Concurrent Manager started : 11-FEB-2009 09:34:30 --------------------------------------------------------------------------- Process monitor session started : 11-FEB-2009 09:34:33 ORACLE error 3113 in insert_fcp Cause: insert_fcp failed due to ORA-03113: end-of-file on communication channel. The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE. Could not initialize the Service Manager
PL/SQL: numeric or value errorORA-06512: at "SYS.OWA_UTIL", line 325ORA-06512: at "SYS.HTP", line 1322ORA-06512: at "SYS.HTP", line 1397ORA-06512: at "SYS.HTP", line 1689ORA-06512: at "APPS.ICX_SEC", line 3457ORA-06502: PL.The SQL statement being executed at the time of the error was: SELECT SES.USER_ID, SES.RESPONSIBILITY_ID, SES.RESPONSIBILITY_APPLICATION_ID, SES.SECURITY_GROUP_ID, FSG.SECURITY_GROUP_KEY, U.USER_NAME, U.ENCRYPTED_USER_PASSWORD, SES.SESSION_ID, NVL(SES.LOGIN_ID, -1) FROM ICX_SESSIONS SES, FND_SECURITY_GROUPS FSG, FND_USER U WHERE SES.SESSION_ID = ICX_SEC.GetSessionCookie(:tik) AND NVL(SES.SECURITY_GROUP_ID, 0) = FSG.SECURITY_GROUP_ID AND SES.USER_ID = U.USER_ID AND DISABLED_FLAG = 'N' AND COUNTER + 1 < LIMIT_CONNECTS AND FIRST_CONNECT + LIMIT_TIME/24 > SYSDATE and was executed from the file &ERRFILE."Solution:Added my server http://bkptapsrv2.com in trusted sites and kept the security level as low for trusted sites. It solved the problem Posted by Farook Issudeen at 5:55 AM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest 3 comments: Jaydev KatrapatiNovember 17, 2012 at 8:37 PMAPP-FND-01564: ORACLE error 6502 in afscpconI have upgraded my IE from 8 to 9 and got the same issue. Followed the above steps and got resolved; Here is my solution with detail1) Click on Internet Settings-->Internet Options-->Click on Security-->Click on Trusted Sites-->Click on Sites button-->Copy your Apps URL and Add this website to the zone then click on Add and Click on Close buttonRestart your IE9Thx/JDKReplyDeletekiran kumarApril 8, 2014 at 12:25 AMThanks alot ..Jaydev Katrapati it worked.ReplyDeleteNilkantha PathakJuly 9, 2015 at 11:29 PMthanks bro... its workingReplyDeleteAdd commentLoad more... Newer Post Home Subscribe to: Post Comments (Atom) Followers Blog Archive ► 2014 (1) ► April (1) ▼ 2011 (1) ▼ April (1) APP-FND-01564: ORACLE error 6502 in afscpcon About Me Farook Issudeen View my complete profile Simple template. Powered by Blogger.