ERPstuff - Oracle EBS Community

I was working on my Oracle 9i database and 6i form server. windows 2003 my server suddenly restarted and after that oracle showing the error ORA-01033: ORACLE initialization or shutdown in progress... I try to resolve this error through this method. I received above mentioned error. please help how ...

I want to close my Fiscal Year like we close in General Ledger [Accounting Software (AIS)] we have completed Entries from Jan 2008 to Jun 2008 Now I want that closing Balances of all the item will be shifted in New Fiscal Year Jul 2008 to Dec 2008 as opening balances and move old data to any where. ...

oracle 6i Form & report + Oracle 9i Database + Windows 2003 I have summary Column that is TOTAL I want to display TOTAL field in WORDS using below lines in Formula Column but showing error. ORA-06502 function CF_1Formula return Number is word varchar2(100); begin select (to_char(to_date(:total,'...

A popup menu comes up when we press the right-mouse button on an picture or any item.

It is possible that popup menu comes when we press left-mouse button?

what do you want to say? User put Qty in GRN and MIN aslo has generated??
Item also has issued to department??

you should delete first MIN then GRN and put again GRN and MIN with actual QTY.

Our Oracle Server database 9i and 6i form was working fine last one year but yesterday due to power failure server was down directly from switch and after that when we start again server and run our application it gives us error . ORA-01033 Oracle Initialization or shutdown in progress I use this sq...

I used this query for print ID Card It is working fine but I want if there is no picture in the D:\pictures folder of same Employee_code then return default picture. SELECT '*'||a.Employee_code||'*' AS "BARCODE", a.Employee_code, a.employee_code||'.bmp' as pict,a.job_status, a.Employee_nam...

Assalam alaikum

Ahmed can I ask you that how can I pass the parameters from report to form
I m confuse how to start.

Report 6i result on C/S If there are 50 records in report in tabular, I found a mistake in one record then when I click on this record it will open in form so that i could edit. It is possible? Any one can solve this Issue???? I user this code but not exact to my condition <b>Procedure</b> PROCEDURE...

I am sorry to say that I think here people don't want to help others because I have posted 2 more topic but no reply received.

any why 10g can do this.

ASA Please tell me how can I run 6i forms & reports in I.E or firefox. Recently I am running in Form's runtime also please tell me that I created a shortcut of Forms runtime on client and create map drive but there is any other way to run the form because some time map drive is disconnected. reg...

I have upgraded my database 8.0.5 to 9i and developer is 6i forms&reports. (reinstalled windows 2003 and reinstalled both Oracle products. import DATA from DMP file.) when I was using database 8 it was running fine but in 9i I am receiving said error. REP-1818: Unable to read data in image format

ORA-12224: TNS: no listener
THIS ERRO SHOWS AT CLIENT ORACLE 8 WINDOWS 2000
SERVER ORALCE 8 & WINDOWS 2003
SERVER DATABASE AND FORM WORKING WELL.
@ CLIENT WHEN I CONNECT CLIENT VIA NET8 EASY CONFIG SHOW THIS ERROR.

I have DMP file & I want to import Problem is that in this DMP file onw table contants BLOB data (Pictures) I dont want to import this table i-e table name is ABC it is possible I can create logic in imp80 command

Like

c:>imp80 user/pass .....

Please open this link and read and help

http://forums.oracle.com/forums/thread. ... 0&tstart=0

best regards