When the procedures or packagess become invalidate
Answers were Sorted based on User's Feedback
Answer / guest
procedures or packagess can become invalid
if it using some object which is in invalid state.
Pravin
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / pavan
most of the packages or procedure become invalid after a
upgrade.example when u upgrade the server and database from
8i to 9i.So beore upgrading its neccesary to make a list of
already invalid procedures and packages, so that wont have
problems after upgrading and to find new p & p's which
became invalid after upgrading.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sonu
In any way, if the system is altered like by migration,
change in system date, import or export, upgrade the
system, then procedures or packages become invalidate or,
if a dependant object has been altered, it will invalidate
the stored procedure. This includes stored procedures,
packages, tables, types, etc.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is debit memo and credit memo in AR?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
Can we get the deleted Record again if the delete transaction has been committed.
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
Explain the process of recievables in oracle financials. : oracle accounts receivable
How can you rebuild an index?
Where in the Oracle directory tree structure are audit traces placed?
can u give guidance abt packages of plsql
A scenario for amount correction & how to use amount correction functionality in AP invoices
as a technical developer in oracle applications which type errors feced in your experience sofar