Kasanur Vinayakudu

This is Kasanur Ganapathi in 2013 september.

Last two pics are my drawings.

Rainbow

Hi this is called Rainbow when rain going to stop that time we can see this. This has 7 colours. In telugu it is called as Indhra Dhanussu. So people thought that when Rainbow genarated then rain will stop.

Bhanukota Photos

 

 These Photos are taken at Bhanukota on 9th Sep 2013 which is Vinayaka Festival Day.

Today we made Abhishekam to lord Shiva with my family.

Oracle Apps Frequent Errors and Solutions

10-may-2013

------------

1) Error in Report while generating .XMl file.

REP-0069: Internal error

REP-57054: In-process job terminated: Terminated with error:

REP-1401: '': Fatal PL/SQL error occurred.

Solution

---------

1) It shows this error because in formula column I wrote end if before RETURN clause.

So i wrote end if after the return clause then it will compile successfully

13-may-2013

-------------

2) Caused by: oracle.xdo.parser.v2.XPathException: Cannot convert to number

This was occurred when I click the preview in rtf.

Solution

---------

2) Used to_number (String)

3) Routine FDPREP cannot read the file /oraapp/ERP/apps/apps_st/appl/ar/12.0.0/reports/US/    XXST_AR_INV_INTER.rep.

Check if the file exists under correct product directory.

Solution

------------

3) In above error observe carefully there is a space in front of .rep file name. Means in executable remove space and

Save

4) Enter Password:

REP-0004: Warning: Unable to open user preference file.

REP-1316: After Report Trigger references column 'inv_max' at wrong frequency.

REP-0069: Internal error

REP-57054: In-process job terminated: Terminated with error:

REP-1316: After Report Trigger references column 'inv_max' at wrong frequency.

Solution

------------

4) Here inv_max is in group in RDF data model but I took this field or formula column or summary column in after report trigger

So this error occurs what I do is I created that field (summary column) in report level not group level so it was rectified.

07-Jun-2013

------------

5) Enter Password:

REP-0004: Warning: Unable to open user preference file.

REP-1401: 'cf_vend_nameformula': Fatal PL/SQL error occurred.

ORA-06502: PL/SQL: numeric or value error

REP-0069: Internal error

REP-57054: In-process job terminated: Terminated with error:

REP-1401: 'cf_vend_nameformula': Fatal PL/SQL error occurred.

ORA-06502: PL/SQL: numeric or value error

Solution

----------

5) This error occurred because that formula column has a number data type but it returns varchar values

So I changed data type as char and size 100 then submit report works fine.

07-06-2013

----------

6) Enter Password:

REP-0004: Warning: Unable to open user preference file.

REP-1416: 'beforereport': User exit 'FND'. IAF GET: unknown column 'P_CONC_REQUEST_ID'.

REP-0069: Internal error

REP-57054: In-process job terminated: Terminated with error:

REP-1416: 'beforereport': User exit 'FND'. IAF GET: unknown column 'P_CONC_REQUEST_ID'.

Solution

---------

6) Whenever we use user exits in report without creating P_CONC_REQUEST_ID parameter then this error will occur.

Action

------

To achieve this error you should create P_CONC_REQUEST_ID in user parameters of your report.

19-Jun-2013

-------------------

Error

--------

REP-0091: Invalid value for parameter 'P_VENDOR_NAME'.

 

Solution

------------

This error occurred because in rdf P_VENDOR_NAME parameter having only 40 size but value maximum is 58 so it occurred.

Action

---------

Increase that width to 100  then it will solve

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.