ERPstuff - Oracle EBS Community

Yes,you could use views in order to get a better performance.[8D]

<img src=images/speech/icon_speech_oops.gif border=0 width=29 height=15>

i think you won't be able to write this code directly in the report trigger as the SQL code will return error as we need srw.do_sql pckage to use that

rivon

yes the answer given is right but use it in before report trigger as the message will be displayed earlier


rivon saxon

Hi, In order to print the report in character mode u must go to the property pallete of the report module and there u will find the property called character mode where u have to change the property design in character units to yes.Now u can print in character mode. Hope this would solve ur problem....

Hi Kasif, i looked at your table structure rather making it complex u try to denormalize u r structure ok. use this table as master table ok Table 1</b> Code Number(2) Primary Key Tilte varchar2(35) then use the primary key of the above table as reference key for the table below Table 2</b> Code Num...

Hi All,
i am providing u all with a link with which u can download the oraloader with which u can upload files into oracle datadbase from these formats *.csv,*.txt,*.xls etc.

regards
rivon saxon

http://www.4shared.com/dir/1748039/c5aa ... ities.html

hi shah,
first u must know what u want to do replication in the same block or different block if in same block then use property called synchronize item property which will solve ur problem.

regards
rivon saxon

Hi All,
i am providing u all with a link with which u can download the oraloader with which u can upload files into oracle datadbase from these formats *.csv,*.txt,*.xls etc.

regards
rivon saxon

http://www.4shared.com/dir/1748039/c5aa ... ities.html

hi
do any body have any idea, how to reset administrator password as i have forgotten administrator i do not want to use any 3rd party tool


regards

rivon saxon

hi all,
can any one plz help me regarding microsoft calender control. I want to use microsoft calender control in my forms but i do not know how to implement it oracle forms can anyone please help me regarding this i require it within 10 days.

regards
rivon saxon

hi rehan, to activate toad u got to do this procedure Run the TOADXpertsetup.exe. Select The Installation type as Local TOAD Install(FULL) and continue. Select The Long Version when prompted.If prompted to install server side .... select cancel. AfterCompleting the installation if it asks for the Ke...

hi,
can u plz tell me the procedure how to do it, it would be great
regards
rivon saxon
[quote]use sql loader for simple uploading data into tables directly.
Use Dataloader for loading data through interfaces

<i><div align="right">Originally posted by abmian1981

Can anybody suggest any method to transfer data from Excel sheet to oracle database.

It would be great help for me

Regards
Rivon Saxon

Hi admin, i am copying my code do attach it so that others get it Add this code in when-button-pressed trigger and cteate a text item to view result(:view) Declare r Number; i Number; a Number; Begin Default_Value('0','Global.Counter'); :Global.Counter := To_Number(:Global.Counter)+1; :View := :Glob...

hi,
tell me how to attach a file with this message then i will give u the code

regards
riv