ERPstuff - Oracle EBS Community

Dear All Memmbes

Please give me any example for Making a New FORM Using Stored Database Procedues.
I have No idea for Developing this form.

I'm Using DEVELOPER 6i

Dear All Members. I have More then 10,000 Employees Images Stored on my HDD, Now i want to Delete the OLD Employees Emloyees Images which have been left before any specified Date. How do Delete that images Using Forms. The Images which have to Delete are near about 7000 and i cant delete the images ...

Just apply BARCODE FONT on the Number which u want to Show as BARCODE.

Use the FORMS_DDL Function for creating user using Forms.

Use this Functions it will Solve ur Problem Fisrt of All Create Directory in ur Schema Create or replace directory EMP_PIC as 'D:\Pictures\'; Then Create this function in ur Schema Create or Replace FUNCTION PIC_PATH(emp_id varchar2) Return CHAR is pic_file bfile := bfilename( 'EMP_PIC', emp_id||'.b...

Dear all Memebers.

Can any One give me a Complete Parameter List?
I try to Search the Form Builder help but unable to Find any List.

Here we can Disbale Any Menu of Report in the Previewer.
Can i Hide this menu Item?

Use the Lexical Reference for your required query
topic.asp?TOPIC_ID=84

Dear All Memebrs.

We Use Formt Strings for Converting Charaters to Dates and Dates to Character. I want to Know the Technical Difference between both of them.
'DD-MON-RRRR' AND 'DD-MON-YYYY'

and also the Difference of FORMAT MASK Used in Developer 6i( in Both Cases)

Thnanks

If my Question is UN CLEAR then here is Short Version of this question.

I want to Print on Customized Page (Sized 4"x8")
OR
I want to Print on the CHEQUE BOOK (on Single SLIP)


Best Regards

Hello Dear Members. I have a Probelm in Printing PAY SLIP using Reports 6i. the Probelm is the Paper Size on which i want to Print the SLIP is of SIZE (4"x8"). and the report is Also designed using the Same size. Slip is Printing Acuratly on the SLIP SIZE paper. the ONLY problem is SPEED o...

Dear Memebrs. I have a Time attendance Machine. Which can Connect to any COM Port (i.e 1,2 3,4 .....). How My Form can Know the Machine is Connected to any Specific Port Number. If i Hard Code in the Oracle Forms. using this code MSCOMMLib_IMSComm.CommPort(objVAR,1); objVar has the Reference of COM ...

Add this Parameter in ur Parameter List for directprinting

Add_Parameter(emppara, 'DESTYPE', TEXT_PARAMETER, 'PRINTER');

Dear all Members.

I want to DISPLAY URDU LANGUAGE in Report 6i.
I want to use it Only On LABLES of reports. not on Database Item.
How can i do this.


Please help me.

Use TO_NUMBER Function to Convert Varchar to Number
Like

TO_NUMBER(NVL(SUBSTR(VOUMASTER.cheqno,10,10),0)) AS chqno


and user Order by Clause in ur Report Query
Like

ORDER BY TO_NUMBER(NVL(SUBSTR(VOUMASTER.cheqno,10,10),0)) ASC

Inshallah Ur Problem will solved.

Dear Members. I want to Know the life cycle of timer control in Devloper 6i. If i have 2 timer control. and 1st timer is exipred and the statments in that timer will statrt excuting. but in the Mean while as the 1st timer statements and executing 2nd timer also expires. Then what will happen[?] will...