-
Hi Gurus
Environment:
=========
OS: Sun Solaris: 8
DB: 8.0.6
Oracle Financial Apps : 11.0.3
In PROD instance, We have the following, Objects (Package body) are Invalid status. We could not bring to Valid state.
1* Select owner,OBJECT_NAME from dba_objects where owner not in ('SYS','SYSTEM','PUBLIC'
2 ;
OWNER OBJECT_NAME
------------------------------ ------------------------------
CTXSYS CTX_ACCESS
CTXSYS CTX_ADM
CTXSYS CTX_DDL
CTXSYS CTX_DML
CTXSYS CTX_LING
CTXSYS CTX_QUERY
CTXSYS CTX_SVC
CTXSYS CTX_THES
CTXSYS CTX_THS
CTXSYS CTX_VP
CTXSYS DISPATCHER
CTXSYS DMLQ
CTXSYS DMLTRIG
CTXSYS DRASERM
CTXSYS DRDINTE
CTXSYS DRICON
CTXSYS DRIOPT
CTXSYS DR_REC
CTXSYS DR_REWRITE
CTXSYS LISTENER
APPS ICX_CONTEXT_SEARCH
APPS ICX_GET
APPS ICX_KB_SEARCH
APPS ICX_ON_UTILITIES
APPS ICX_REQ_CUSTOM
APPS ICX_REQ_UPDATE
APPS JA_IN_PO_DEFAULT_TAXES
APPS JA_IN_RECEIPT_ACCT_PKG
APPS JA_IN_RECEIPT_RG_PKG
APPS JA_IN_RG_PKG
APPS JA_IN_RMA_RECEIPT_ACCT_PKG
APPS JA_IN_TAX_PKG
It leads to performance issue...
Could someone throw some light on this....
TIA
Anandharaj
a_anandharaj@yahoo.com
-
run adadmin and recompile your objects. If you still have invalid objects, submit a TAR.
Jeff Hunter
-
Hi
I have brought all the INVALID Objects to VALID state, by running the apcompsc.pls script from $FND_TOP\sql folder.
Thanks a lot.
Anandharaj
a_anandharaj@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|