Difficulties using the Java UDF

[KyleRB]

Hi all,

I am trying to use the Java UDF (link) and I'm running into some major problems with the API. Here is what I'm trying currently:

#include <Java.au3>

WinActivate("Oracle Applications")
_JavaAttachAndWait("Oracle Applications")

Send("{F11}")
Sleep(1000)

_JavaObjValueSet("", "Order Number", "text", "1%")

I got the name and role of the text box by using Java Ferret. When I run this code, the script enters the text "1%" in the wrong text field. I've played around with the code a bit and I've determined that the function will enter "1%" in whatever field has the current keyboard focus, regardless of what the name is.

Another (related) problem is that _JavaObjValueSet() doesn't bother to check what it's actually doing. For instance, you could pass a bogus name to the function and it'll still "work" and return 1. I think this is a pretty major bug. Is it even possible for this function to return 0?

Has anyone else run into these issues?

- Kyle

[seangriffin]

Hi all,

I am trying to use the Java UDF (link) and I'm running into some major problems with the API. Here is what I'm trying currently:

#include <Java.au3>

WinActivate("Oracle Applications")
_JavaAttachAndWait("Oracle Applications")

Send("{F11}")
Sleep(1000)

_JavaObjValueSet("", "Order Number", "text", "1%")

I got the name and role of the text box by using Java Ferret. When I run this code, the script enters the text "1%" in the wrong text field. I've played around with the code a bit and I've determined that the function will enter "1%" in whatever field has the current keyboard focus, regardless of what the name is.

Another (related) problem is that _JavaObjValueSet() doesn't bother to check what it's actually doing. For instance, you could pass a bogus name to the function and it'll still "work" and return 1. I think this is a pretty major bug. Is it even possible for this function to return 0?

Has anyone else run into these issues?

- Kyle

Hi Kyle,

I'm struggling to get time to work on the Java UDF these days. Work is so busy and my home life is busy too. There are so many different Java applications out there that it's hard to design a "one solution fits all" Java UDF. But I'm trying my best.

I had worked with an Oracle Web application called "Oracle Developer" earlier this year, and managed to get the UDF to work with that application. It was a tough one. I'm imagining "Oracle Applications" is going to be another tough one. I recall with Oracle Developer that we had some issues in getting the UDF to recognise the right Java field. Sounds like you also have this issue. The luxury I had with working with Oracle Developer was that it was on a public website, and I was given user access to login and actually fix my UDF realtime. It was a great experience, and I could never have fixed the UDF without getting hands on.

I'm about to go to bed right now. Just wanted to let you know that I want to help. If I could get my hands on a publically accessible Oracle Applications website, and see first hand what this "Order Number" field is doing, I think I'll have a chance. Failing that, maybe I can create a debug version of the UDF that will give us a clue what's going on underneath.

Yes the UDF does still need alot of work I'll admit. I remember alot of functions didn't have good error handling. Yes the return value is probably useless at the moment (a major bug as you say). It is a time-consuming UDF to work on. I hope to have alot more time to work on it in the future.

I'll keep in touch, and I guess I can create a debug version and work with you in the future. Is there anyway I can get my hands this sort of app., and see the "Order Number" field myself?

Sean.

[seangriffin]

Hi all,

I am trying to use the Java UDF (link) and I'm running into some major problems with the API. Here is what I'm trying currently:

#include <Java.au3>

WinActivate("Oracle Applications")
_JavaAttachAndWait("Oracle Applications")

Send("{F11}")
Sleep(1000)

_JavaObjValueSet("", "Order Number", "text", "1%")

I got the name and role of the text box by using Java Ferret. When I run this code, the script enters the text "1%" in the wrong text field. I've played around with the code a bit and I've determined that the function will enter "1%" in whatever field has the current keyboard focus, regardless of what the name is.

Another (related) problem is that _JavaObjValueSet() doesn't bother to check what it's actually doing. For instance, you could pass a bogus name to the function and it'll still "work" and return 1. I think this is a pretty major bug. Is it even possible for this function to return 0?

Has anyone else run into these issues?

- Kyle

You won't believe this (well I can't believe it), but I found a publicly accessible Oracle Applications website. Don't ask me how. And lo and behold, I was able to login. It must be a test environment of sorts. Anyhow, I've learned alot about Oracle Applications in the past 1 hour. It is an ERP system, from what I can tell. I am familiar with ERP systems, having worked with SAP and Workbrain for the past 18 months. So it's an environment not unfamiliar to me.

From the description of an "Order Number" field, I'm guessing you are in the Order Management module of Oracle Apps. Is this correct? I have been able to bring up it's functions, such as:

Order Organiser

Sales Orders

Purchase Release

Requisition Import

Am I in the right area here? Actually I've just opened the Order Organiser, and I get a "Find Orders" window with the fields:

Order Number

Order Type

Created By

Customer PO

Interesting. Is this the "Order Number" field you are trying to automate?

[seangriffin]

Oh dear. I'm having a hard time finding an instance of Oracle Applications that uses JInitiator V1.3x or higher. The website I found earlier, in my last post, turns out to be a test environment using JInitiator V1.1.8.16. This is not compatible with Java Access Bridge v2.0.1, and Java Ferret subsequently doesn't recognise it. Woah-is-me.

I will keep looking. Must be another Oracle Apps public website using JInit. 1.3 for above!?

[seangriffin]

I can't provide any more support with this Kyle, until I'm able to debug AutoITJavaAccess.dll against an instance of Oracle Applications using JInitiator 1.3x or higher on my computer.

The bug will be within AutoITJavaAccess.dll, which I've written as a "bridge" (so to speak) between the Java Access Bridge (v2.0.1) and the Java UDF. It is the core of the Java UDF solution. It changed significantly in V0.6 of the UDF, after my work with tbui and Oracle Developer.

Oracle seems to be going the Java path these days, with the heavy weight applications that it's developing. It's really going to put my UDF through it's paces. There are many ways to implement Java. I have seen at least three different types of Java app out there. It would seem, on the face of it, that Oracle Applications is another type (perhaps different again from Oracle Developer).

If anyone else is reading this post, and can provide me access to Oracle Applications, it would be greatly appreciated.

Thanks,

Sean.

Edited September 27, 2009 by seangriffin