ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings on Mail Lists
ON
HRMS - REPORTS



Ad-hoc reporting

FromDomain: COPELCO
From: "Kevin Jarrett" kejarr@copelco.com
Date: Fri, 25 Jun 1999 14:57:54 -0400
Subject: [orahrms-l] Q: Reporting Tools

Hi everyone,

What are people using for ad-hoc reporting?

- Discoverer or other similar end-user query tools?
- Oracle Data Browser?
- SQL with imports into Excel, etc.?
- MS-Access (gag)?

Thanks for your input, -kj-


From: Messick Charles J TSgt AFPC/DPDIAC Charles.Messick@afpc.randolph.af.mil
To: OraHRMS-L@mail-list.com
Cc: "'Kevin Jarrett'" kejarr@copelco.com
Subject: RE: [orahrms-l] Q: Reporting Tools
Date: Fri, 25 Jun 1999 14:16:33 -0500

Discoverer is planned...and that's only if it's ever decided if the end user actually needs an ad-hoc tool.

TSgt CJ Messick
HQ Air Force Personnel Center
cj.messick@afpc.randolph.af.mil


From: Diane Patch DPATCH@FAMILYDOLLAR.com
To: "'Kevin Jarrett'" kejarr@copelco.com, OraHRMS-L@mail-list.com
Subject: RE: [orahrms-l] Q: Reporting Tools
Date: Fri, 25 Jun 1999 15:31:23 -0400

We are using Discover 3.1 with Noetix views and it is working very well for our easy ad hoc reports. We have developer s creating the more complicated weekly and monthly reports as custom reports that we run from concurrent manager.

From Discover we can export the information to excel or access for more analysis if necessary.

Diane Patch
HRIS Manager
Family Dollar Stores, Inc
DPatch@familydollar.com


From: "Balawejder, Anthony T." balawejder@ppg.com
To: "'Kevin Jarrett'" kejarr@copelco.com, OraHRMS-L@mail-list.com
Subject: RE: [orahrms-l] Q: Reporting Tools
Date: Fri, 25 Jun 1999 15:37:42 -0400

We at PPG Industries are using Cognos Impromptu for some of our ad-hoc reporting. We have developed our own reporting catalog and views.

Tony Balawejder


From: Thaddeus Inekuku tinekuku@hotmail.com
To: kejarr@copelco.com, OraHRMS-L@mail-list.com
Subject: RE: [orahrms-l] Q: Reporting Tools
Date: Sun, 27 Jun 1999 07:24:55 PDT

Kevin,
My present client uses Business Objects for both ad-hoc reporting and some of their more complex reports. A number of their sites are moving to the web version before the end of the year.

Thaddeus Inekuku
Answerthink Consulting Group


From: "Kevin Jarrett" kejarr@copelco.com
To: OraHRMS-L@mail-list.com
Date: Fri, 25 Jun 1999 22:00:51 -0400
Subject: RE: [orahrms-l] Q: Reporting Tools

Thanks for all the responses everyone!

FYI, here's the breakdown:

Discoverer either used or planned: 10 responses
Discoverer competitor: 1 response
SQL/Access/Excel: 1 resoponse
Noetix: 3 responses

Thanks again...go, Discoverer! -kj-



Reports 2.5 - Matrix Report

Date: Wed, 7 Jul 1999 14:32:50 -0700
From: USeshadri@archcoal.com (Uma Seshadri)
Subject: Reports 2.5 -Matrix Report

Hello all,

I am working on a head count report using matrix default layout. is it possible to print column heading & values based on certain criteria?.(Oracle apps HRMS)

ex: report looks like this

Salary:

Cost center-----org_name----Active----Active WO Benefit--Laidoff
----------- --------- ------- ----------------- -------
00200007---------abc--------25------------1-----------------0
00200010--------- xyc------ 0------------14-----------------1

I need to print values - Active , laidoff etc. based on certain criteria?.

what is the best way to achive this?.
Thanks in advance. suma


Date: Wed, 7 Jul 1999 15:27:17 -0500
From: "Mandadi, Harish" HMandadi@obiwan.intecom.com
Subject: RE: Reports 2.5 -Matrix Report

You can use frames and based on the value you print or not to print.
-Harish


Date: Wed, 7 Jul 1999 16:16:26 -0500
From: "Kanakam, Venkat (c)" vkanakam@Carlson.com
Subject: RE: Reports 2.5 -Matrix Report

Hi Uma,

First of all, it is best to avoid matrix reports. Modify the query using DECODEs or do some other magic and get the output what you want. Modification of field label(BP) or value is possible by format triggers tied to that field.

HTH
Venkat kanakam
Consultant
CIBER, Inc.


Date: Thu, 8 Jul 1999 10:28:05 +0300
From: Mohammad Fouwaaz Mfouwaaz@savola.com
Subject: RE: Reports 2.5 -Matrix Report

Yes it is possible. You could use DECODE(criteria,true_value,Employee_Status,null), Cost_Center, Org_Name in your select to specify the criteria and then use a CROSSTAB group with a matrix layout. The crosstab should include the Org_Name, Cost_Center and the decode column as three different groups. Remember to have COUNT(decode(criteria,true_value,EMPLOYEE_ID,Null)) as an additional column in the select statement, outside the crosstab, before generating the layout. In Tools, default layout you should also specify the 'Repeat' correctly for the appropriate groups.

Hope this helps. Regards



W2-caution for terminated employee data

Subject: [orahrms-l] W2 Heads Up
From: "William C.Stratton" bstratton@sprynet.com
Date: Wed, 3 Feb 1999 10:09:40 -0500

I would like to take this opportunity to welcome everyone to the new Oracle HR/Payroll List server. I want to publicly thank Greg Clark for his fine efforts to get this thing off the ground.

I would like to start the process by alerting everyone to problems we have encountered while processing year end W2s. Our initial implementation date was July 1, 1998, so we had to do balance loads to get the legacy YTD numbers into Oracle. We had a number of terminated employees who had YTD wages that also needed to be set up and loaded. Since these people were never going to be paid in Oracle, we only loaded what we felt was needed to prepare the W2s at the end of the year. One of the fields we did not populate was salary basis. We did to a test print of the W2, but this was before the date tracked W4 patch that was loaded last fall. What we didn't realize was these employees did not receive a State W4 record in the new date tracked W4 file. The end result was that the state wages were not printed on the W2.

Those of you who did balance loads this year might want to double check your employees that were terminated prior to the implementation date.

Bill Stratton
BOSS Corporation
Better Organization Service Solutions
6455 East Johns Crossing, Suite 404
Duluth, GA 30097
770-622-5500 (V) 770-622-5400 (F)


California legal reporting

From: "David Norton" dnorton@iciapps.com
To: OraHRMS-L@mail-list.com
Date: Tue, 22 Jun 1999 14:26:55 -0400
Subject: [orahrms-l] California Reporting

Does anyone know if Oracle HRMS has a seeded report for a Federal Report mandatory under California Law called the "Bureau of Labor Statistics Report on Employment, Payroll, and Hours - Transportation, Communication, and Public Utilities, Finance, Insurance, Real Estate, and Services"?

This looks like a simple one page report that breaks employees down by Month, Total Employees, Women employees, Non-Supervisory Employees, Gross Non-Supervisory Employee Payroll, and Total Non-Supervisory Employee Hours.

If anyone in California as seen this as a standard report, please let us know.

Thanks,
David Norton
Implementation Consulting Inc.
dnorton@iciapps.com


Employee Benefit Enrollment Register

From: "Schwartz, Ken" kschwar@rwjf.org
To: "'OraHRMS-L@mail-list.com'" OraHRMS-L@mail-list.com
Date: Wed, 30 Jun 1999 11:32:31 -0400
Subject: [orahrms-l] Q: HR Employee Benefit Enrollment Register

Greetings form Princeton, NJ!

Has anyone modified the Employee Benefit Enrollment Register to include the GL Chart of Accounts information?

We are implementing Release 11.02 or maybe 11.03 on a Sun Solaris.

Please contact me ASAP.
Thanks and regards,
Ken Schwartz
HR Consultant
Robert Wood Johnson Foundation
Site: 609-720-7529
Cell: 404-226-6334


Printing W-2s - Query 1

From: "Julie Hertzler" Hertzler.Julie@summitgroup.com
To: OraHRMS-L@mail-list.com
Date: Tue, 6 Jul 1999 14:20:48 -0500
Subject: [orahrms-l] Printing W-2s

I am trying to test printing W-2's, but am having a couple of problems. Hopefully some of you can shed some light on them for me.

When I try to print the Employee W2 Report with the Portrait - For W-2 Paper, I get a completion error. I can view the W-2's but nothing prints. When I print them in the Landscape format, they print but the format is not correct.

I would like to test printing the W-2s on the real W-2 form, but I can't seem to locate anyone who has any left from 1998. Would anyone have a sample that I could use? Do you have any idea why my W-2's won't print in the W-2 Paper format?

Thanks for your help.
Julie Hertzler
email: Hertzler.Julie@summitgroup.com


Month to date value in HRMS

Date: Fri, 18 Jun 1999 09:10:46 -0700 (PDT)
From: PRASHANT CHINCHANKAR prash_apps@yahoo.com
Subject: Month to date value in HRMS

Hi ,

I am modifying Payroll Registers report . In which I have to add value MTD for the elements.I called the package pay_balance_pkg.get_value(defined_balance_id , assignment_action_id) ; . I could calculate the MTD value for Earnings and Deductions.But for Fedaral Taxes and state taxes elements ,I found that their is no entry in PAY_BALANCE_TYPES table. So I could not find value for defined_balance_id . Element names e.g (SIT-MI ,FUTA,SS,FIT)

Please help me how to calculate MTD value for the elements.

Thanking you
Regards
Prashant


Multiple Worksite Report

From: Pat Keeley PKeeley@amctheatres.com
To: "'HRMS List Service'" OraHRMS-L@mail-list.com
Cc: Glenna McDonald GMcDonald@amctheatres.com
Date: Wed, 23 Jun 1999 11:46:32 -0500
Subject: [orahrms-l] Multiple Worksite Report

Have any of you gotten the Multiple Worksite Report to run? We are on release 10.7 SC and I'm having absolutely no luck getting this report to run.

Thanks for any and all assistance. Pat Keeley


Subject: [orahrms-l] Multiple Worksite Report
From: Ellen Young EYoung@FAMILYDOLLAR.com
Date: Wed, 7 Apr 1999 08:57:33 -0400

Has anyone successfully run the Multiple Worksite Report (10.7 NCA)? We are attempting to process quarterly payroll taxes and the report runs successfully, but returns no data with an ORA-01403 error message. We have confirmed that we have the latest and greatest version of the report.

Ellen L. Young
Line of Business Manager
Finance/HR/Payroll Technology
Family Dollar Stores, Inc.
704-814-3365
eyoung@familydollar.com


From: Ron Pribyl [mailto:RPribyl@amctheatres.com]
Sent: Thursday, July 29, 1999 2:05 PM
To: 'OraHRMS-L@mail-list.com'
Subject: [orahrms-l] Multiple Worksite Report

We have been on Oracle 10.7sc payroll for 1½ years, and have never had the 'Multiple Worksite Report' work. Since this is a mandatory quarterly report in many States, we are behind in the filing.

Oracle support says there is a Bug, and none of their clients are able to run this report. Can this be correct?? Thanks in advance.


From: Schwartz, Ken [SMTP:kschwar@rwjf.org]
Sent: Thursday, July 29, 1999 2:57 PM
To: 'Ron Pribyl'; 'OraHRMS-L@mail-list.com'
Subject: RE: [orahrms-l] Multiple Worksite Report

Ron:
It can be correct, but its probably not.

Oracle would be out of the payroll business if there was mandatory reports that could not be produced.

Get back in touch with Oracle support and ask for a duty manager and explain your situation. I think you will get better results.

Regards, Ken Schwartz
Independent Consultant
Specializing in Oracle HRMS
Site: 609-720-7529
Cell: 404-226-6334
Mail: kenschwartz@mindspring.com
Site Mail: kschwartz@rwjf.org


From: Diane Patch DPATCH@FAMILYDOLLAR.com
To: "'Schwartz, Ken'" kschwar@rwjf.org, 'Ron Pribyl'
RPribyl@amctheatres.com, "'OraHRMS-L@mail-list.com'"
Subject: RE: [orahrms-l] Multiple Worksite Report
Date: Thu, 29 Jul 1999 15:58:59 -0400

At the Payroll Q & A sessions that I attended at OUAG, Oracle admitted that the reports did not work and that there were problems. We also are not able to run the reports. Currently we have a reverse file that goes to our mainframe and we run our old legacy reports.



Report by Assignment No. and other information

From: Michael Scott [mailto:mscott@goodegg.com]
Sent: Monday, June 21, 1999 3:11 PM
To: orahrms-l@mail-list.com
Subject: [orahrms-l] Oracle SQL + Report

Does any one out there have any idea on the following reports

1. I want a report by assignment #, then GRE other information such as GRE, Timecard Required and shift worked. This other GRE information appears only to be a view and the TRM does not have any useful suggestions on where to find this information.

2. Assignment # with Job and Exempt Non Exempt Status (classified in other job information). Same issue as above, and the TRM is of no use in this case.

Thanks to anyone with any sql ideas on this. MS


From: pkandra@civicdevelopment.com
To: mscott@goodegg.com, orahrms-l@mail-list.com
Subject: RE: [orahrms-l] Oracle SQL + Report
Date: Mon, 21 Jun 1999 16:39:49 -0400


#2. SELECT PA.ASSIGNMENT_NUMBER, PJ.NAME, PJ.JOB_INFORMATION3
FROM PER_ASSIGNMENTS_F PA, PER_JOBS PJ
WHERE PA.JOB_ID = PJ.JOB_ID

JOB_INFORMATION3 will either be EX or NEX depending upon whether it's Exempt or Non-Exempt.
You'll most likely also want to join PER_PEOPLE_F and include EFFECTIVE_START_DATE and/or EFFECTIVE_END_DATE

Hope this helps,
Peter Kandra
Civic Development Group
(888) 800-7637 x2518



SQWL Creation

Date: 25 Jun 1999 09:45:42 -0700
From: "LOBERG.US.ORACLE.COM" LOBERG@us.oracle.com
To: orahrms-l@mail-list.com, hrnet@com.us.oracle.com
Subject: [orahrms-l] SQWL Creation

Hoping someone could shed some light -

Client still has not produced 1Q 99 SQWL because of employees with negative balances. Ran the negative balance report by the pay period timeframe and found the employees. They have created the balance adjust elements. Now ready to start defining the procedures on "how to".

Question is - do the balance adjustments need to be date tracked to each pay period for entry or can one quarter end adjustment be OK? I am wondering how the process is looking at the information - at quarter end or pay period basis?

Thank you.


Unemployed compensation report

Subject: [orahrms-l] Unemployment Compensation/Frick Reporting File / State UC Tapes
From: "Menke, Irene M." menke@Mail.Donaldson.com
Date: Tue, 9 Feb 1999 19:14:56 -0600
Cc: "Winn, George H." gwinn@Mail.Donaldson.com

Hello,
Our current HRMS system (Cyborg) has built into it the ability to create UC tapes for vaious states like Minnesota, Wisconsin etc. It also produces a file (tape) for the orgainization which handles our Unemployment comp - which is Frick Company.

Does anyone know if the Oracle System produces any or all of these files and if so how do I setup to get output.

TIA
Irene Menke
menke@mail.donaldson.com
612.887.3605


Subject: Re: [orahrms-l] Unemployment Compensation/Frick Reporting File / State UC Tapes
From: "William C.Stratton" bstratton@sprynet.com
Date: Wed, 10 Feb 1999 08:17:45 -0500

Oracle does support the preparation of the State Quarterly Wage Listing files that you must send to each state every quarter for State Unemployment Insurance (SUI). You second question sounds more like Workers Compensation, which is a different employer liability. Oracle does support the calculation of Workers Compensation liability. You may need to create your own tape file to send to your Workers Compensation carrier.

The setup procedures for both of these liabilities is handled fairly well in the manual and help screens. In the case of the SUI files, the output goes to a disk file in the out directory of $PAY_TOP. It is your responsibility to get this file onto magnetic media.

Hope this helps
Bill Stratton
BOSS Corporation
Better Organization Service Solutions
6455 East Johns Crossing, Suite 404
Duluth, GA 30097
770-622-5500 (V) 770-622-5400 (F)
http://www.bosscorporation.com


Subject: Re: [orahrms-l] Unemployment Compensation/Frick Reporting File / State UC Tapes
From: "Michael Auquier" mauquier@sprynet.com
Date: Wed, 10 Feb 1999 10:07:19 -0500

State reporting is handled within the Oracle HRMS application by running the State Quarterly Wage Listing (SQWL) process by state. The setup is fairly straightforward and starts with establishing rules on your GRE/Legal Entity organization classification on the Organization form for the organization(s) designated as a GRE.

You will be on your own for creation of a file for Frick. The only tricky part is that you will need to devise a means of flagging an employee as being reported so that they aren't reported more than once. At my current client, we are using a descriptive flexfield segment on the Additional Period of Service Details form for this purpose. If you employ people in Illinois, you will require some additional processing as well.

Hope this is helpful.
Regards,
Mike Auquier
BOSS Corporation
Better Organization Service Solutions
6455 East Johns Crossing, Suite 404
Duluth, GA 30097
770-622-5500 (V) 770-622-5400 (F) 248-651-2511 Ext. 2514 (Client)
http://www.bosscorporation.com



Federal & State Tax Remit Manager

Subject: [orahrms-l] Federal & State Tax Remit Manager
From: "Jarnutowski, George J." JarnGJ@jea.com
Date: Thu, 18 Feb 1999 09:18:30 -0500

Have some EE's living in Georgia and can not get any tax data out of the "Federal & State Tax Remittance Manager" report. Does anyone have this report working? Is there a key field on the GRE set-up that I missed that triggers this?


Subject: Re: [orahrms-l] Federal & State Tax Remit Manager
From: "William C.Stratton" bstratton@sprynet.com
Date: Thu, 18 Feb 1999 09:50:47 -0500

I believe the only requirement would be that you have your state tax rules established for Georgia at the GRE Level. My current client is located in Georgia and we are not experiencing any problems. You may want to try to run this report with Georgia selected in the State parameter just to see if it will print.

Good Luck,
Bill Stratton
BOSS Corporation


Subject: [orahrms-l] Re[2]: [orahrms-l] Federal & State Tax Remit Manager
From: pat_keeley@power-one.com
Date: Thu, 18 Feb 1999 08:30:19 -0800

Bill,
Do you know if any documentation is available on this report? I hadn't seen it before. I tried to run it and it is only allowing me to enter 1-APR-1999 as the start and ending dates. Is this a joke? Pat Keeley
ARIS Corporation


Subject: [orahrms-l] Re: Re[2]: [orahrms-l] Federal & State Tax Remit Manager
From: "William C.Stratton" bstratton@sprynet.com
Date: Thu, 18 Feb 1999 14:04:07 -0500

This report came on one of the enhancement patches (don't remember which one) and any documentation will come in the README files associated with the patch.

As far as the start and end dates, the report validates these entries from your payroll processing results, meaning you can only pick dates that exists in your payroll processing results. My guess is that you only have results for 01-APR-1999.



New Hire reporting

Subject: [orahrms-l] New Hire reporting
From: James Wood JWOOD@FAMILYDOLLAR.com
Date: Fri, 19 Feb 1999 09:24:13 -0500

I am interested in learning how employers are providing new hire data out of HRMS to the states in which they operate. We're currently looking at two options: outsourcing this process to the Frick Company (they provide this service and we're already providing the necessary data via an interface out of HRMS) or designing and developing an interface directly from HRMS to the state we've already been set up to provide multi-state reporting to.

New hire reporting, pushed by the federal government, but run by individual states is a fairly new phenomenon, with many states requiring slightly different information in different formats. My concern is undertaking a design/development process that may prove obsolete in the not-so-distant future, as states (potentially) change reporting requirements, formats, etc. Has anyone else heard about the 801 byte format that is supposedly becoming a standard? Our new hire contact with the state of Georgia told me this format is fast becoming standard among most of the states. Is he correct?

Finally, if he is, is there any word from Oracle as to whether this output could be standardized in HRMS, so that a standard flat file can be produced every time new hire reporting is due? Thanks in advance for any information.

James Wood Family Dollar Stores


Payroll Message report

Subject: [orahrms-l] Payroll Message report
From: James Wood JWOOD@FAMILYDOLLAR.com
Date: Wed, 10 Mar 1999 18:39:43 -0500

I am interested in learning other's experiences with the Payroll Message Report, a standard report in HRMS . It appears that this report was intended to be an exception report, alerting payroll to employees who were not being processed correctly in a payroll run. We've found that not only does it not do a good job with this, but it also includes a lot of information which is not helpful at all.

Our biggest concern is that it does not provide employees who have been incorrectly set-up and who won't be successfully processed in a payroll. Currently, we identify these employees at various stages of the payroll process, occasionally as late as the check writer process or even after that (when the employee calls wondering what happened to his/her check...?).

Other concerns: employees who have a "no earnings to calculate" message, when 90% of the time, the employee actually does have earnings and is paid normally. Also, all the employees receive the "no WC rate..." message. Finally, even when we use the "Fatal" parameter, almost all the messages aren't fatal or even particularly useful.

Anybody have any tips on making this report useful...? Or should we just grin and bear it and wait for another release...! Thanks,

James Wood Family Dollar Stores


Quarterly wages

Subject: [orahrms-l] Quarterly Unemployment State Tape
From: "Jarnutowski, George J." JarnGJ@jea.com
Date: Thu, 25 Mar 1999 07:50:17 -0500
Cc: "Miller, Robert W. - Tax Administrator" MillRW@jea.com

Nothing like first time events.

However, does anyone have any hits/tips on producing reporting interface to the State (mag tape, diskette, etc.) of Quarterly Wages. What is your current process/procedures. When we was on the mainframe, it was a simple process (maybe it is now).

Also, what report, etc. do you use in order to fill out the forms that support the Wage interface information. I'm in Florida, but am sure other states work similar.

Thanks
George Jarnutowski
JEA


Subject: RE: [orahrms-l] Quarterly Unemployment State Tape
From: "Venkatesh, Masoor" mVenkate@wssc.dst.md.us
Date: Thu, 25 Mar 1999 08:20:31 -0500
Cc: "Miller, Robert W. - Tax Administrator" MillRW@jea.com

George: We had the hardest time getting the Multiple Worksite Report and State Quarterly Wage Listing reports to work and ended up creating our own custom reports using Oracle delivered Balance Packages. Each state gives you a specific format that want the information in and also the media. Some states will accept ASCII files on a diskette - that is fairly easy. Others need a mainframe fromat on tape - this will require some JCL to transfer files to mainframe and then gen the tapes.

Regards,
Tony x8452
http://www.mcsgroups.com


Subject: Re: [orahrms-l] Quarterly Unemployment State Tape
From: "Ken Conway" k_conway@sprynet.com
Date: Thu, 25 Mar 1999 13:28:52 -0600
Cc: "Miller, Robert W. - Tax Administrator" MillRW@jea.com

George:

We have setup and processed the standard functionality of the State Quarterly Wage Listings at our clients. The setup is fairly detailed and requires you to know the formatting requirements of each state. For each GRE, there are various setup parameters that you must establish:

1. SQWL Employer Rules (1)
2. SQWL Employer Rules (2)
3. SQWL Generic Transmitter Rules
4. SQWL State Transmitter Rules

Since you are operating in Florida, you should not need any additional setup on employee assignments' "GRE's and Other Data".

Hope this is what you are looking for. If you need in further assistance, please do not hesitate to call me at either 281-599-7654 or 770-622-5500.

--Ken
Ken Conway
BOSS Corporation
Better Organization Service Solutions
281-599-7654 (Voice), 281-599-7653 (Fax), 770-622-5500 (Headquarters)
Email: k_conway@sprynet.com
http://www.bosscorporation.com



W2 - printing of - Query 2

Subject: [orahrms-l] Printing W2's
From: "Scott, Richard" RScott@RGIS.com
Date: Thu, 29 Jul 1999 12:13:21 -0400

Hello all,

We are currently on 10.7sc prod 16.1 (soon going to 10.7 NCA). I am looking for alternative options to printing W2's using the Oracle delivered program. We have about 90,000 W2's to print and we have had an outside service print them in the past. To continue to do this would require significant customization to the Oracle delivered program or writing our own from scratch. I am hoping there is a service that will accept the Oracle delivered output file from the W2 printing program. Any insight into available options would be greatly appreciated.

Thanks,
Richard Scott (248) 651-2511 x2537
RGIS Inventory Specialists
Administrative Applications Development (HRMS Payroll/Financials Team Leader)