What is the best method to connect Oracle and DB2 DB with HIGH reliability and speed?
Hello, My company currently has 2 ERP systems: JDE (in Oracle) and another which has 3 of our divisions. The decision has been made to move the remaining 3 divisions to JDE. The other divisions currently push pricing to the 2nd ERP system from home grown Contract Systems on the System i nightly (recently upgraded [...]

Answer Question   |  May 16, 2013  1:02 PM
DB2, ERP system, JDE, Oracle

Notes.notessession custom sender
Hi, I’m using Oracle 9i, Developer 6i and Lotus Notes to send an email. I need to change the sender for another and I don’t know how to do it. Please, help me.

Answer Question   |  May 14, 2013  6:46 PM
Lotus Notes, Oracle 9i, Oracle Developer

Oracle Forms
What is the iconic button for in Oracle Forms?

Answer Question   |  April 24, 2013  5:43 AM
Oracle Forms, Oracle Forms 10g

Adding a star to a required field in Oracle Application Express
I have a page…in that page there is a required field I just want to add a star which highlights the field as a required. How can this be done? I am a newbie to Oracle Application Express. Please help

Answer Question   |  April 22, 2013  5:41 AM
APEX, Oracle, Oracle Application Express

JDE world data archive at decommision
Hi, Has anybody had to perform this task and got any tips? Especially in the UK to comply with HMRC and other retention requirements.

Answer Question   |  April 19, 2013  11:47 AM
JDE, JDE archive

Install rwserver
How I can install rwserver in normal Devsuit 10g 10.1.2.0.2?

Answer Question   |  April 18, 2013  8:45 AM
Oracle, Oracle Devsuit

Connect the D2K
I am using Oracle 10g. I installed D2K 6i. After installing D2K, I wanted to connect it with the database. I had given my username, password and server name and it is showing 12154 error. What should I do? Just send me a step by step process how to resolve it. I am using xp2. [...]

Answer Question   |  April 9, 2013  5:42 AM
D2K, Oracle 10g

UPK 3.5.1 error
ERROR System.ApplicationException: Invalid entry This is the error I get when I try to install UPK 3.5.1.

Answer Question   |  April 9, 2013  8:59 PM
UPK, UPK 3.5.1

Execution of Oracle 11g wrapped procedure gives ora-00900 error
Hi, I have a procedure which I wrapped using the oracle 11g wrap utility. If I execute the wrapped procedure using JDBC I am getting an error of 0RA-00900 invalid SQL statement. The procedure is having basic SQL statements only. The same procedure if i wrap using Oracle 9i and execute using JDBC it works [...]

Answer Question   |  April 5, 2013  4:29 AM
Oracle 11g, Oracle 9i

My Oracle forms 6i Form is exiting automatically
Dear friends, My problem is…after compiling, my Oracle Forms 6i form is exiting automatically. How can I solve this problem?

Answer Question   |  April 1, 2013  11:41 PM
Oracle 6i, Oracle Forms

Oracle Forms11g on Windows 7 (64bit)
How can I install Oracle Forms 11g on Windows 7 (64bit)?

Answer Question   |  April 1, 2013  12:42 PM
Oracle Forms, Oracle Forms 11g, Windows 7

Clear button
Hi friends, I had created one form contains 2 table details(emp,dept), I saw the details from 2 table by entering empno but I want to clear those text fields.

Answer Question   |  March 19, 2013  1:05 PM
Oracle 6i, Oracle Forms

Numeric value error
How to solve this Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small.

Answer Question   |  March 15, 2013  4:59 AM
ORA, ORA-06502, SQL

Stop Oracle database using by other application
I have Oracle 9i database & want to stop other people from using it and use other applications like SQL Developer & Toad.

Answer Question   |  March 11, 2013  9:37 AM
Oracle 9i, Oracle 9i database

How to sort a resultset from a ‘group by’ statement
I have written a query like this: select to_char(order_date,’mon-yyyy’) “months”, sum(nob) “number of bags” from p_in where order_date between ’1-apr-11 and ’31-mar-12′ group by to_char(order_date,’mon-yyyy’) The above query returns me a resultset which gives me number of bags sold in every month, but it does not sort the month in their chronological order.I want to [...]

Answer Question   |  March 11, 2013  4:20 AM
Oracle 11g, Oracle 11g Database, Oracle Query

JDE with Robot/Schedule
Hi All, Our new E1 interface to Robot seems to have created an issue where previous EDI react jobs are not finishing in the OS and so Robot Schedule continues to think they are still running. After looking at the job log for the hung job I noticed it only created a data queue in [...]

Answer Question   |  March 7, 2013  4:00 PM
iSeries, JDE

Hyperion planning
Can anyone help me to figure out the difference  between substitution variable and dynamic user variable?

Answer Question   |  March 1, 2013  9:50 AM
Hyperion, Hyperion Planning

User input
How do I get the user input, so I can use it on my query on Oracle Reports Builder 6? The report will be executed on a client desktop. Im using autosearch, and just found this : Report.GetAutoSearchDescriptionLines(Memo1.Lines);which get me the whole search description, including the user input for the search criteria. Is there any [...]

Answer Question   |  March 1, 2013  1:45 PM
Oracle Reports 6i, Oracle Reports Builder, SQL Query

RMAN duplicate
1) Will be there any problem if there are two RMAN duplicates going (from two different auxiliary host) at the same time against the same source database? 2) How is the overhead incurred in the source DB during the RMAN duplication?

Answer Question   |  February 25, 2013  5:42 PM
RMAN, RMAN Duplicate

Oracle application is installed in VMware in 2003
Oracle application 12.1.1 is install in 2003 through VMware working properly. When I am trying to access application through Windows 7 (Windows 7 is install in C drive and 2003 is in E drive) its not working but the  application is working in 2003 through VMware but not working in Windows 7. I tried by [...]

Answer Question   |  February 15, 2013  10:02 AM
Oracle applications, VMware