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