Thanks, Jeevan oracle oracle11g share|improve this question asked May 13 '13 at 20:46 Jeevan 42621228 Sounds like maybe your table is in a weird state and the packages that Teenage daughter refusing to go to school This is my pillow How Did The Dred Scott Decision Contribute to the Civil War? B. All rights reserved.
Start a new thread here 927462 Related Discussions You should define MO Operating unit at responsibility level for multi org Unable to view data of po_headers_v Profile set up for Responsibilties There was no way to know this had happened. execute hcheck.full 6.
You're now being signed in. In the package code , package = > references itself . > When I tried to compile, I receive following error. > > Do you have any idea. > > Rgds. Needs manual check ORPHAN IND$: OBJ=830176 DOBJ=830176 TS=0 RFILE/BLOCK=0 0 BO#=830174 SegType= ^- May be OK. Your cache administrator is webmaster.
And on top of that I think that the pl/sql compiler is really trying to tell you something, especially at: 62/5 PL/SQL: Statement ignored 304/9 PL/SQL: Statement ignored 397/9 PL/SQL: Statement Storage and File Structure1. Needs manual check ORPHAN IND$: OBJ=830201 DOBJ=830201 TS=0 RFILE/BLOCK=0 0 BO#=830199 SegType= ^- May be OK. http://oracle-apps-dba.blogspot.com/2007/10/troubleshooting-during-upgrade-oracle.html Buy the Full Version You're Reading a Free Preview Pages 29 to 86 are not shown in this preview.
We had the same problem today (tonight). Compile apps schema. 2. Troubleshooting after Upgrade Oracle Applications ... Other Relational Languages16.
Needs manual check ORPHAN IND$: OBJ=830193 DOBJ=830193 TS=0 RFILE/BLOCK=0 0 BO#=830191 SegType= ^- May be OK. Suggestion, use the following SQL: Select line, text from user_source where type = upper('&object_type') and name = upper('&object_name') and line between &line-5 and &line+5 order by line; -----Original Message----- From: [email protected] Concurrency ControlTransactionsRecovery SystemOracle Dev2K Course Build Forms I ExerciseFormPersonalization_395117_R12_updated1212b15503b13987b13915b13987b13919PLCLASS27PLCLASS12Print - Www.oreillynet.com Network 2003-04-22 Feuerstein Apps Technical by Abhishek15 viewsEmbedDownloadDescriptionApps TechnicalApps TechnicalRead on Scribd mobile: iPhone, iPad and Android.Copyright: Attribution Non-Commercial (BY-NC)List After that we are not able to login to Apps by thru the URL .: /dev60cgi/f60cgi">http://
I sincerly hope that you will avoid such tone in future as most of list members are very senior in experience and very valued due to their contributions towards this list http://culturahq.com/cannot-load/pls-00907-cannot-load-library-unit-oracle.html srivastava.ashish replied Feb 16, 2006 A better way to do this would be to run the following pl/sql block DECLARE stat boolean; BEGIN dbms_output.disable; dbms_output.enable(100000); stat :=3D FND_PROFILE.SAVE('ORG_ID', 92 , 'SITE'); In t... Thank you much !!!!
Meanwhile I decided to google but dint find any luck. Are you sure you want to continue?CANCELOKWe've moved you to where you read on your other device.Get the full title to continueGet the full title to continue reading from where you Grid Control: Create user-defined metrics at datab... weblink Select 2D data in a certain range Do Morpheus and his crew kill potential Ones?
Database frozen due to full archive log destination Database froze, due to archive log destination being full and you can only connect as SYSDBA. Thanks in advance. November 30, 2008 at 2:32 AM George said...
Thanks for the kind words Hetal.Regards,Aviad March 1, 2009 at 5:00 PM Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Design By TND.Art Log In Script to check if AWR snapshot collection has stopped In one database, after the archive log destination got full, snapshot collection stopped. Other related issues pls-00907: cannot load library unit APPS.HR_API (referenced by #####) HR_API is a valid object. This is the very optimal way for the people like you. > > > -----Original Message----- > From: Jared Still [mailto:[email protected]] > Sent: Monday, June 13, 2005 8:51 PM > To:
February 12, 2009 at 3:51 PM Hetal Kholia said... Sandeep Gandhi replied Feb 15, 2006 Since it is a test instance, update the record in fnd_profile_option_values where profile_option_id=1991 set level_id=10001 , level_value=0,level_value_application_id=null Top Best Answer 0 Mark this reply as This problem started occurring after they dropped a redundant custom index on the HR_ALL_ORGANIZATIONS_UNIT. check over here But much beyond that no one here can do much to help without the version, operating system and version, and the code.
Does describing your table show the new column, and does anything look amiss in user_tables? –Alex Poole May 13 '13 at 20:54 New column is not added and in In one place, i saw that below command will help but it seems to me as very risky command alter system flush shared_pool Can anyone help me with the reason and Posted by Lefteris Tsekouras Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: Real Case, Segments No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) regards Arvind Top This thread has been closed due to inactivity.
Relational Database Design6. asked 3 years ago viewed 5891 times active 5 months ago Upcoming Events 2016 Community Moderator Election ends Nov 22 Related 1Create trigger in Oracle 11g0Oracle 11g environment Issue2ORA - 06502:PL/SQL No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers mona is not in the sudoers file.
While doing Org set-up, we had accidentally removed the default operating unit from MO: Operating Unit at site level and added the new operating unit to individual responsibility level. Your cache administrator is webmaster. Only ... Connect as SYS schema in sqlplus 2.
But it won't solve the problem! Generated Tue, 08 Nov 2016 09:47:08 GMT by s_hp90 (squid/3.5.20) The idea is to do as much as one can on one's own before posting a question to the list. The system returned: (22) Invalid argument The remote host or network may be down.
Create package hOut as described in Note 101468.1 3. Clone a database using RMAN RESTORE & RECOVER commands In this scenario, we want to create a database copy using RMAN RESTORE and RECOVER commands in a different server with the Powered by Blogger. My Blogroll Steven Chan - Oracle E-Business Suite Technology Atul Kumar - Online Apps DBA Sam - Apps DBA Blog About Me Aviad Elbaz Subscribe to Updates RSS Email
Using DBMS_CRYPTO package to encrypt data in a table We have a trigger, which fires whenever a DDL, GRANT and REVOKE statement is executed and stores some session information in a