FRM-40735:CLOSE_WINDOW trigger raised unhandled exception ORA-06508.

 ERROR>ORA-01403:no data found
FRM-40735:CLOSE_WINDOW trigger raised unhandled exception ORA-06508.


 Navigation:-
Customer support,vision operations>Service Requests>Create Service Requests>open new form>>
enter data>save>error data not found>and form not close...



Solution:-

RUN ADADMIN:-

Compile APPS schema:-

Generate form files:-

1.run adadmin:-steps

[oracle@APPSR12 scripts]$ adadmin
Is this the correct APPL_TOP [Yes] ?
Filename [adadmin.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] :  

 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] : 3 <Enter>

 1.    Compile APPS schema:-

Enter your choice [3] : 1 <Enter>

Review the messages above, then press [Return] to continue.<Enter>
 
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] :
  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.

Error resolve.............

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...