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

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

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

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

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

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

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

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

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

thanks for reply

sir how i use if condition in view or query

please give me any sample

thanks

aamir