ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings on Mail Lists
ON
HRMS - APPLICATION DATA EXPORT (ADE)



ADE working in 11.02

Subject: [orahrms-l] ADE working in 11.02?
From: "Tenley, Bob" btenley@varco.com
Date: Thu, 17 Jun 1999 13:06:46 -0700

Hi,
Does anybody have ADE working in release 11.02? We are at the point in our project where we want to start setting up ADE but our project staff has been to several Oracle sponsored classes and ADE was never able to work in any of them. Just don't want to waste any time or effort.......

Any advice would be greatly appreciated!
Thanks,
Bob Tenley
Project Manager
Varco International, Inc.
(714) 704-0796


Subject: RE: [orahrms-l] ADE working in 11.02?
From: "Schwartz, Ken" kschwar@rwjf.org
Date: Thu, 17 Jun 1999 16:19:56 -0400

Bob:

We are in the same boat as you.

The HR Director saw a 'demo' where ADE worked, but we have been unable to get there. Oracle support has not been very helpful.

Let me know if you get a positive response.

By the way, don't try to put in Employee Pictures OR try to use Attachments either!

Regards,
Ken Schwartz
Site: 609-720-7529
Cell: 404-226-6334


Subject: RE: [orahrms-l] ADE working in 11.02?
From: "Tenley, Bob" btenley@varco.com
Date: Thu, 17 Jun 1999 13:32:32 -0700

Ken,
We haven't had any problems with attachments but according to Support, pictures will not be working until 11.05. Also, FYI - release 11.03 just came out but our consultant was told by a few people that it is still unstable. We are going to remain at 11.02 for a while until we hear better news.

Bob Tenley


Subject: RE: [orahrms-l] ADE working in 11.02?
From: Laurie Bosley lbosley@solbourne.com
Date: Thu, 17 Jun 1999 16:14:29 -0600

There are (several) patches available for Attachments in 11.02. If you need the numbers, I can do a little research.


Subject: RE: [orahrms-l] ADE working in 11.02?
From: "Schwartz, Ken" kschwar@rwjf.org
Date: Fri, 18 Jun 1999 06:57:59 -0400
Laurie:

I appreciate the offer, but our DBA is currently applying a boatload of patches.

Regards,
Ken Schwartz
Site: 609-720-7529
Cell: 404-226-6334


From: "BERNARD (ERP)" BAILBL@bcps.k12.md.us
To: Diane Patch DPATCH@FAMILYDOLLAR.com
OraHRMS-L@mail-list.com
Subject: RE: [orahrms-l] ADE working in 11.02?
Date: Fri, 18 Jun 1999 11:48:54 -0400

I was working on it a few weeks ago, and seem to get it 3/4's done. I have yet to go back and finish up do to other taskings. However, I used the applicant view that was on the server side, created a letter on the client side containing the appropriate merge features, and placed it in ADE's letters directory. I was then able to do the call from within ADE, and create the letters.

There are times when I have had to close ADE to get the letters to generate. Once again, this is a bit rough, because I have not had time to tailor it as-of-yet.

Initially we did have a problem, because the HR Data Export Screen would not activate.

Good luck!
Bernard



Excel Apps instead of browser to view reports

Date: Wed, 11 Aug 1999 10:46:11 -0700
From: "Ashwin Ayancha" Ashwin.Ayancha@xilinx.com
Subject: Re: ADE

Hi, Does anyone used Application Data Export ADE if so please send me steps to use that. Basically i want to setup the system like when you view the output of a report and if we use the Special/Copy function i want to open an Excel file or Excel application instead of a browser. for information we are using applications versin 11.0.2.

thanks, Ashwin


ADE Upload

Subject: [orahrms-l] ADE Upload
From: "Krishnasamy, Balaji (Exor)" bkrish@sigeco.com
Date: Tue, 20 Jul 1999 13:45:55 -0500

Hi Everybody,

Environment

Oracle APPS - Rel. 10.7 Prod 16.1 SC
Oracle DB - Rel 7.3.3.6
O/S - Digital Unix Ver 4.0c
ADE 32 Bit Version Ver 11.0.1

Navigation Path : Launch Oracle APPS, choose US HRMS Manager -> People -> Salary Management -> F8 (Blind Query) . Launch ADE -> Choose default folder, Spread sheet -> Start. This creates a excel file (HRIO.xls). Update the Change Date or Proposed Salary or Proposed Reason Column(s). Save the updated file. Click upload , Choose Correction (default), Click Load . Point to HRIO.xls file to upload. The system gives error-116 .

Objective : To upload changes made in HRIO.xls file into Oracle APPS enmase through ADE.

Note : When ADE is launched standalone and People [General] Style is selected from styles folder ADE gives me error 116. The script views107.sql has been run .

Balaji Krishnasamy


ADE: Launcher.exe replacement?

Subject: [orahrms-l] ADE: Launcher.exe replacement?
From: Matt Surico surico@users.buoy.com
Date: Wed, 4 Aug 1999 22:27:00 -0400

In the documentation for installing ADE there is a statement that one must use the launcher.exe program before invoking NCA (browser) access to the database so that the ADE product can communicate with one's Applications session correctly (which is what we are currently using). There was a hint in there about an Oracle patch to replace launcher.exe so that this extra step would no longer be required.

Does anyone know if such a patch has been released yet, and if not, when one might become available?

TIA,
Matt
--
Matt Surico | "Someday we'll all be on our backs
Oracle Certified | Free at last from income tax."
Database Administrator | -- Billy Joel
Email: surico@buoy.com | http://www.buoy.com/~surico
Pager: 1465555@skytel.com |


Can ADE be used to generate letters

Date: Sat, 14 Aug 1999 12:09:28 +0400
From: IjlalR@mashreqbank.com
Subject: GEN: ADE

Hi,

Has anyone used ADE to generate letters? If so, what are the pros and cons as to using concurrent processing (for the users and the technical staff)?

Ijlal


From: IjlalR@mashreqbank.com
Date : 18th August 1999
Subject: URGENT: Letter generation using ADE

Hi,

We are on 11.0.2, ADE version 11.1.6 and would like to generate letters using ADE from the HR application. I tried using the predefined style, Letter Test, which uses the view HRV_PEOPLE_LETTERS. The mail merge document is present under ADE\Letters. My question is: what are the steps that must be carried out in order to submit a letter request from the HR application?

Please reply in detail as I have been through the steps mentioned in the ADE user guide but to no avail. If I run a query in ADE and export it to Excel and then mail merge it works fine, so the trouble seems to be that when submitting the request no data is read from the application.

Thanks in advance,
Ijlal



Responsibility - Controlling access of

From: "Barnett, Janet L." jlbarnet@mountaineergas.com
Tue 12:25 AM
Subject: [orahrms-l] ADE

What controls whether a responsibility can use the organization or position hierarchies in ADE. Some responsiblities seem to go to the part that has all the tabs(organization, position, discover, etc). Other responsibilities go straight to the query screen.

What's the difference?

Janet Barnett
Mountaineer Gas Company