ERPstuff - Oracle EBS Community

thnks for your reply sir i use oracle form 6i and report also and use this method declare emppara paramlist; begin emppara :=create_parameter_list('aamir'); Add_Parameter(emppara, 'PARAMFORM', TEXT_PARAMETER, 'NO'); add_parameter(emppara,'p_1',text_parameter,:ysdate); add_parameter(emppara,'p_2',tex...

Hi master,

Sir I have report that contain two page sir my need is I not want preview I want direct print and not want all page my requirement only page 2 not want page 1

Sir please give me idea how I get direct print and only page no 2

Thanks aamir

hi maser
sir how i convert oracle report to excel such oracle convert report into html easily

please give me idea and step how i convert report into excel

thank

aamir

sir when i use this query SELECT VOUMASTER.discription,cheqno,NVL(SUBSTR(VOUMASTER.cheqno,10,10),0) AS chqno,VOUMASTER.entdate,VOUDETAIL.vno,VOUDETAIL.accid,VOUDETAIL.debit,VOUDETAIL.credit,CHARTOFACC.title AS acc_title,PARTYTABLE.title AS PARTY,DEPARTMENT.title AS DEPT FROM VOUDETAIL,VOUMASTER,CHAR...

hi master sir my user some time feed rough data i want to restric that he only select value from lov not give from key board mu text bot disable and accept only lov please give me idea how textbox disable and accept only from lov some body give me this idea ======= use a text-item link in the item y...

hi master
sir i use oracle group report with many group
sir my question is

HOW START NEW PAGE WHEN GROUP CHANGE

or every group print seprate page

please give me idea

thanks
aamir

Hi master Sir I have 5 office In different city and one head office in Karachi all branch have same oracle system my question is how I get new data and compile for accumulative reporting I want only new record and modify record not old record Old record already I import When I use oracle import and ...

sir see my query mfa2 is mastr and mfa3 is detail this query give me union type result and mfa2*mfa3 but i need master detail result SELECT mfa3.stdcode,mfa2.vhno,mfa3.name FROM ( SELECT STUSECMTAMT.stdcode,STUSECMTAMT.sem_code,COURSES.name,COURSES.id,COURSES.crhrs,STUDEG.DEGREE_code,SCHEME_DEG_DET....

thanks for your reply

sir

please send me the sample code of

exceptions????

When no_Data_Found, When Too_Many_Rows, When Others.....

how i use exceptions, When no_Data_Found, When Too_Many_Rows, When Others..... in form

please give me idea thank

aamir

Hi master

Sir this error crate may problem for me
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403

sir how I avoid I this error and show my message
or system not show this error and bypass this error

please send me code how I avoid this error

thanks

aamir

Sir I have tree spared query how i report how I link all query with each other the STUSECMTAMT .stdcode this is same column in each query SELECT STUSECMTAMT .stdcode,RATES.description,RATES.amount,STUINV.amt-RATES.amount AS addotherfee,STUINV.amt,STUINV.discperc,(STUINV.amt/100)*STUINV.discperc AS d...

thanks for your reply Sir this is optional field is if amount less then 5000 then not pad through cheq and :cheqno must be null if garter then 5000 then pad through cheq mustbe give value in :cheqno how i check :cheqno at navigation or query time or fatching time if i found :cheqno have value then i...

Sir I use this code in post query event :partyname :=''; :CHQBANK :=''; :repchq:=''; :chqdate:=null; :chqbank:=''; :PARTYNAME :=''; select YEARID,TITLE,STDATE,CLDATE,CLOSINGSTATUS into :yearid,:yeartitle,:ysdate,:yedate,:YSTATUS from yeartable where stdate<=:entdate and cldate>=:entdate; if :partyid...

Sir I uses this code for printing and system give me preview Run_Product(REPORTS, 'd:\iqramfa\pcvoucher', SYNCHRONOUS, RUNTIME,FILESYSTEM,emppara, NULL); But when I press print button system directly print all page Sir I want print only particular page or only page no 1 or or page no 2 not need all ...

thanks for reply

sir how i use if condition in view or query

please give me any sample

thanks

aamir