When the procedures or packagess become invalidate

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

1901


Can we modify approve purchase order?if yes what is navigation?

1524


i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

1746


What are different types of transactions in ar? : oracle accounts receivable

715


Explain how to close periods in ar. : oracle accounts receivable

675






i want to know about the javaBean.what is its purpose and how it can use in Forms.

1811


Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2332


How to clone the database using RMAN back

1592


how to replace not in with not exist?

3160


Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7405


Could you please let me know the interfaces in OM / FA??

1712


A scenario for amount correction & how to use amount correction functionality in AP invoices

1625


What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3307


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1808


Explain about party and customer in ar : oracle accounts receivable

694