ERPstuff - Oracle EBS Community

Sir I create new record by using F6 key but I not record this record and I press delete button from menu and all field blank but system give me this error FRM-40102 Record must be entered or deleted first And no delete that blank record And not move to next record Please give me idea how I solve thi...

Hi master Hi master Sir I have many column I need landscape layout with A3 paper I set orientation = landscape from system parameter and A3 from page setup but not give me at design time and give me landscape on printer or paper Please give me idea I set all column in my report Thanks aamir this is ...

hi master Sir I have many duplicate record in my table I use this query STDCODE COUNT(*) -------------------- ---------------------- 021-00-11133 1 021-00-11327 1 021-00-11329 2 021-00-11400 3 021-00-11401 1 021-00-11473 2 021-00-11490 1 021-00-11498 2 021-00-11521 1 021-00-11529 2 021-00-11531 2 02...

Hi master Sir I set landscaped paper from report data model system parameter orientation Initial value = landscaped When I print report then print landscaped but design and view time not show me landscaped paper I need extent then field width How system show landscaped in design and view time Thank ...

Hi master sir this is my query and data query ======== SELECT TO_CHAR(STUJOURNAL.stujdate, 'YYYY') AS YEAR,DEPARTMENT.NAME,SUBSTR(STUSECMTAMT.sem_code,5,4) AS SEMESTER,COUNT(STUSECMTAMT.STDCODE) AS TOTALSTUDENTS,SUM(STUSECMTAMT.totdebit) AS totdebit,SUM(STUSECMTAMT.totalcr) AS totalcr,SUM(STUJOURNAL...

sir i use qury but system give me this result

3905.555555555555555555555555555555555556

i need result in this format

3905.555

please give me idea


thank

aamir

sir i user this query but system give me error SELECT STUSECMTAMT.totdebit/STUSECMTAMT.totalcr,STUJOURNAL.cre_bal/(STUSECMTAMT.totdebit/STUSECMTAMT.totalcr) FROM STUSECMTAMT,STUDEG,STUJOURNAL WHERE STUSECMTAMT.vhno=STUJOURNAL.ref_no AND STUSECMTAMT.studegid=STUDEG.studegid; error ERROR at line 1: OR...

Sir my requirement is the system asking befor deleting record You see my code If found this chq in ledger file then not delete form cheqfile Sir my question is where I put I this code Or which event I use select count(*) into :CHQFOUND from voumaster where cheqno=:rchqno; if :CHQFOUND>0 then message...

Hi master I hope you are good and comfort Sir my problem is I have log query from many table now my need is query display result separately Such as Query Select a.name,a.fanem,a.address,a.phone,b.carbillno,b.carbillamount,c.homelona,c.loaninst,d.chqno,d.chqamount from a,b,c,d where a.no=b.no and a.n...

hi master
how i eject the page Programmatically in in oracle report

thank

hi master sir i have group report my need is when new group start then start new page is use this code for balance cs_1 this is summrise colunm and count then record no is new group then is statr from 1 if :cs_1 =1 then :cp_1 :=0; if nvl(:drbal,0)>0 and nvl(:debit,0)>0 then :cp_1 :=nvl(:drbal,0) + n...

Hi master
Sir I use amount to word function which give me following result

four thousand five hundred sixty-three Rupees only.

But my user need following result

Four Fhousand Five hundred Sixty-Three Rupees only.

Means every first character are upper not small

Please give me idea

Than

aamir

hi master
sir i have master detail form but show data with out order by
my need is form show data in order on date

please give me idea how order by use in master detail form

thank

aamir

Hi master Sir I have master detail block form Sir I need search option in my form how when my user give amount, description, date, chqno or voucher no then system give result as per give criteria I use default inter query but that not satisfy me Please give me help how I search any voucher from my f...

thank for your reply sir i have this is lov query SELECT CHARTOFACC.TITLE||' '|| CHARTOFACC.ACCID AS comcode FROM chartofacc; and this is data or column LAND K1101 BUILDING K1102 COMPUTERS / PRINTERS K1103 OVERHEAD PROJECTORS K1104 MULTIMEDIA K1105 Sir my question Is where I % % put in my query user...