APP-WSH-231210:An Unexpected Error Occured for Line 388354.


 APP-WSH-231210:An Unexpected Error Occured for Line 388354.
The Error is:ORA-04062 :Signature of package "APP.WSH_DELIVERY_DETAILS_INV"
has been changed..

  Solution:-

  [oracle@APPSR12]$ cd
/oracle/VIS/apps/apps_st/appl/wsh/12.0.0/patch/115/sql

[oracle@APPSR12 sql]$ cp WSHDDICB.pls  /home/oracle/Desktop/

[oracle@APPSR12 sql]$ cp WSHDDICS.pls  /home/oracle/Desktop/

 [oracle@APPSR12 sql]$ rm WSHDDICB.pls

[oracle@APPSR12 sql]$ rm WSHDDICS.pls

generate form through ADADMIN..
STEP:-2 run adadmin

[oracle@APPSR12 scripts]$ adadmin
Is this the correct APPL_TOP [Yes] ?
Filename [adadmin.log] :sonu.log
Do you wish to activate this feature [No] ?
Please enter the batchsize [1000] :
Is this the correct database [Yes] ?
Enter the password for your 'SYSTEM' ORACLE schema: manager
Enter the ORACLE password of Application Object Library [APPS] :  apps


Saving product information.

AD code level : [B.3]

            AD Administration Main Menu
   --------------------------------------------------

   1.    Generate Applications Files menu

   2.    Maintain Applications Files menu

   3.    Compile/Reload Applications Database Entities menu

   4.    Maintain Applications Database Entities menu

   5.    Change Maintenance Mode

   6.    Exit AD Administration



Enter your choice [6] : 1

         Generate Applications Files
   ----------------------------------------

   1.    Generate message files

   2.    Generate form files

   3.    Generate report files

   4.    Generate product JAR files

   5.    Return to Main Menu





Enter your choice [5] : 2


AD utilities can support a maximum of 999 workers. Your
current database configuration supports a maximum of 84 workers.
Oracle recommends that you use between 4 and 8 workers.


Enter the number of workers [4] :

Your current character set is "AL32UTF8".

Do you want to generate Oracle Forms objects
using this character set [Yes] ?


Do you want to regenerate Oracle Forms PL/SQL library files [Yes] ?

Do you want to regenerate Oracle Forms menu files [Yes] ?
Do you want to regenerate Oracle Forms executable files [Yes] ?

Enter list of products ('all' for all products) [all] : inv

 Generate specific forms objects for each selected product [No] ?


The current set of installed languages is: US

Please select languages for generating Oracle Forms files.
You may select all of the above languages, or just a subset.

Enter list of languages ('all' for all of the above) [all] :


Review the messages above, then press [Return] to continue.
Resolved  error >>>>>>>>

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...