FRM-41072: cannot create group FRM-41827: Group Does not exist.

Hi for below error

FRM-41072: cannot create group <Group Name>
FRM-41827: Group Does not exist.

Solution
----------------
If it will occur at the time of changing or restricting LOV then follow below procedure.

First open the form and place cursor on field which have list of values in drop down

then go to help diagnostics examine
give system
        current block


then it shows block name this was the Data Block Name in our .fmb file.

in same form go to help--> About oracle applications

here we can see the form name. i.e our .fmb name it should be in AU_TOP

so get that .fmb and open through Form Builder

here we can click on our Data block then click on Items

select our field which is having list of values then press F4

here we can see the LOV name.


then go to LOV in the same form builder down

then right click on our LOV here copy the query and paste it into TOAD or Sql Developer

Made changes in where condition what ever we require. Dont change columns and names.

Then go to frontend form and help-->diagnistics-->custom code --> form personalize

here give sequence and name and function

below select WHEN NEW FORM INSTANCE

then click on actions

10  Builtin              All                                                 Create Record Group from query:
paste your query here. and in the group name give some name i.e. XX_GRP.( As your like)

20  Property         All                                                Object Type - LOV
                                                                                Target Object - select your LOV name here
                                                                                 Property Name - GROUP_NAME
                                                                        Value - give the new record group name here i.e. XX_GRP.

By doing above procedure as it is sometimes getting error so what we will do that time is

just done all changes and save and validate and validate all dont click on Apply Now.

now close the form and re open now we can see restricted lov.



Hope this helps.

Thanks,
Jagadekara Reddy.
 

Cannot convert to number error in RTF

In Rtf if we are using any function at that time if you get
'Cannot convert to number error in RTF " error then check that function carefully.

So Use to_number(String) then it will resolved.

Buttler Telugu

hi Viewers Happy to see my post. Here I invented the new funny language named Buttler Telugu.
This is very funny language. Usually I chat with my friends with this funny Buttler Telugu So all my friends are enjoyed alot. here I mentioned below some of buttler telugu words. So start using buttler Telugu and make others joy.

English                                                           Buttler telugu
------------                                                   -------------------
Big Bazar(Shopping)                                Pedda Bazaar (ఫెద్ద బజార్ )
TV9                                                        TV Thommidi(టీవీ తొమ్మిది )
He is Talking                                             Talkutunnadu(టాకుతున్నాడు )
Going To Office                                         Karyalam Going(కార్యాలయం గోయింగ్ )
He is Speaking                                           Speakutunnadu(స్పీకుతున్నాడు )
Face Book                                                Moham book(మొహం  బుక్ )
Pinged in Facebook                                    Pinginaadu(పింగినాడు)
Shared In Face Book                                 Sharnaadu(శేరినాడు)
Worker                                                       Work Manishi(వర్క్  మనిషి )
Two Minutes                                                Rendu Minutes/Twi Nimishalu(రెండు మినిట్స్ / టూ నిమిషాలు )
Chief Minister                                              Chief Manthri(చీఫ్ మంత్రీ )
Which Movie                                            which Cinema(విచ్ సినిమా  )
Six Runs                                                    Six Parugulu(సిక్స్  పరుగులు )
Rice Cooker                                                Annam Cooker(అన్నం కుక్కర్ )
Two Kgs                                                       Rendu Kgs(రెండు కేజిస్ )
Finger Prints                                              Finger Mudralu(ఫింగర్ ముద్రలు  )
He Ate                                                       Yetinadu(ఈటినాడు )
He was Drunked                                          Drinkinaadu(డ్ర్రిన్కినాడు )
News Paper                                               News pathrika(న్యూస్ పత్రిక )
He taked                                                    Takinaadu(టేకినాడు )
Five Crores                                               Five Kotlu(ఫైవ్ కోట్లు )
Foreign Country                                       Foreign Desham(ఫారిన్ దేశం )
Software Engineer                                   Methaware Engineer (మెత్త వేర్ ఇంజనీర్ )
Half An Hour                                          Ardha Hour (అర్ధ అవర్ )
First Floor                                               Modati Floor (మొదటి  ఫ్లోర్ )
Hard Disk                                               Gatti Disk (గట్టి డిస్క్ )
Happy Birth Day                                     Happy Birth Roju (హాపీ బర్త్ రోజు )
Week End                                               Vaaram End (వారం ఎండ్ )
Sweet Memories                                     Tiyya Memories  (తియ్య మెమోరీస్ )
Right Click                                             Kudi Click (కుడి క్లిక్ )
Nail Cutter                                             Gorla Cutter (గోర్ల కట్టర్ )
Body Pains                                            Sareeram Pains (శరీరం పెయిన్స్ )
Good Day                                               Manchi Day (మంచి డే )
T- Shirt                                                   T Chokka (టీ చొక్కా )
Windows 7 OS                                    Kitikilu 7 OS (కిటికీలు సెవెన్ వో ఎస్ )
Child Dog                                             Dog Pilla (డాగ్ పిల్ల )
Black Mail                                            Nalla Mail (నల్ల మెయిల్ )
Black Money                                        Nalla Money(నల్ల  మనీ )
Mango fruit                                           Mamidi fruit(మామిడి ఫ్రూట్ )
One day match                                       Oka Day Match(ఒక డే మ్యాచ్ )
Seetamma Vaakitlo Sirimalle Chettu      Seetamma Door Lo Siri Malle tree(సీతమ్మ డోర్ లో సిరి మల్లె త్రీ )
Iddaru Ammayilatho                             Iddaru Girls tho (ఇద్దరు గర్ల్స్ తో )
SaniwarPet                                            Saturdaypet (సాటర్డే పేట్ )
Coconut Oil                                          Coconut Nune(కోకోనట్ నునె )
Prathama Kumarudu                             Prathama Son (ప్రథమ సన్ )



Like this Daily use Above words and see the different nature.
I Hope In future This will use in movies also for comedy seens.

                                      All The Best.



                                                                                                  ------>Jగన్ /జగదేKar.

REP-1219 <object name> has no size - length or width is zero
 
Solution
--------
Error REP-1219 is usually caused when a report is designed as a bitmap, but 
then is run under character mode.  The character cell boundary falls
midway down the boilerplate object border.  Hence, when Reports tries to map 
the object to a character cell, both the top and bottom of the object are 
mapped to the top of the cell.  
 
If you are using a standard report, convert the .rdf file to .rdf with 
dunits=character.  For example:
 
   r25convm userid=apps/apps stype=rdffile source=whatever.rdf dtype=rdffile
   dunits=character dest=whatever.rdf overwrite=yes batch=yes

Pune Mehathoba Temple

My Pune Pics

Performance tuning Steps

Steps to Tune the Query :
---------------------------------
1.Make sure the proper joins for whatever tables in from clause.
2.Make the joins with "ID's" instead of Database columns.
3.Avoid Multitable views, Use Org Specific views whereever possible.
4.If the custom table is having large amount of create indexes.
5.Avoid Type casting and Aggregate functions,Negation operators
   on Indexed columns.
6.Instead of using the whole query in a single cursor or group ,
   split into multiple   Groups and link them.
7. use union all instead of Union
8. Use Exists inplace of in
9. Avoid usage of Negation operators like NOT, !=.
10.Use Union instead of OR Clause.
11.Avoid Usage of outer joins , use Equi joins whereever possible
12.Use Where Clause instead of Having Clause.