Payroll check printing
Payroll check printing errors when No. of copies are greater than 0
Subject: [orahrms-l] Payroll Check Printing
From: jowsley@usmarine.com
Date: Tue, 23 Feb 1999 13:31:35 -0800
We are having difficulty printing payroll checks. I can get the
checkwriter process to complete without error only if the number of copies
is set to 0, the style A4, and no printer is specified. If it completes
without error it will generate a file which we can print fine from native
unix but it won't send directly to our payroll printer. If the print
options are anything other than 0 copies, the program blows up.
Has anyone had a similar experience? How did you resolve it?
We are using Evergreen software for printing, by the way.
Subject: Re: [orahrms-l] Payroll Check Printing
From: "William C.Stratton" bstratton@sprynet.com
Date: Tue, 23 Feb 1999 17:22:38 -0500
As you have already discovered, Checkwriter does not automatically send the
check images to a printer. The output file generated does not conform to
the standard Oracle naming convention for the output spooler to recognize. I
do remember some modifications that came out with one of the patches that
did allow you to set some parameter so that the output file would conform to
this standard. I'll check through my file papers from my last project and
see if I can find this patch.
In the meantime, you will have to continue to spool the output file to your
printer manually through a Unix script. Most companies like to do this
anyway so that you can ensure that the printer is ready to accept payroll
checks.
Subject: Re: [orahrms-l] Payroll Check Printing
Subject: RE: [orahrms-l] Payroll Check Printing Check Numbers Mismatch
Subject: [orahrms-l] Check Numbers
Subject: Re: [orahrms-l] Check Numbers Processing the final pay for a terminated person
Subject: [orahrms-l] Processing the final pay for a terminated person
Subject: RE: [orahrms-l] Processing the final pay for a terminated person
To: "'pkandra@civicdevelopment.com'" pkandra@civicdevelopment.com, "Kim, Steven S" stevenkim@kpmg.com, OraHRMS-L@mail-list.com
Subject: [orahrms-l] RE: Processing the final pay for a terminated person Customize Check printing
Subject: [orahrms-l] Check Printing
Subject: Re: [orahrms-l] Check Printing Tables for Current and YTD Gross pay
Subject: [orahrms-l] Current and YTD Gross Pay - Oracle Payroll
Subject: RE: [orahrms-l] Current and YTD Gross Pay - Oracle Payroll
Subject: RE: [orahrms-l] Current and YTD Gross Pay - Oracle Payroll Printing message on checks
Subject: [orahrms-l] Messages on checks PayMix process not recognizing the Rate Code from the Wage Rate Table
Subject: [orahrms-l] PayMIX Costing and Transfer to GL
Subject: [orahrms-l] Costing and Xfer to GL
Subject: RE: [orahrms-l] Costing and Xfer to GL
Subject: RE: [orahrms-l] Costing and Xfer to GL Generate Deposit Advice
Subject: [orahrms-l] HRMS / Deposit Advice
Subject: RE: [orahrms-l] HRMS / Deposit Advice pay_balance_pkg
Subject: [orahrms-l] PAYROLL / BALANCES - pay_balace_pkg
Subject: [orahrms-l] FW: [orahrms-l] PAYROLL / BALANCES - pay_balace_pkg Running Quickpay results in error on processing Assignment
Subject: [orahrms-l] balances/payroll process
Subject: RE: [orahrms-l] balances/payroll process
Subject: Re: [orahrms-l] balances/payroll process Calling command file psecure from within a SQL script
Subject: [orahrms-l] SQL Scripts
Subject: Re: [orahrms-l] SQL Scripts
Subject: RE: [orahrms-l] SQL Scripts
From: "William C.Stratton" bstratton@sprynet.com
Date: Tue, 23 Feb 1999 17:38:29 -0500
I found the readme file for the patch I was referring to. According to this patch (652376) you can:
"manually insert in table pay_action_parameters a row with PARAMETER_NAME = 'STD_FILE_NAME'
PARAMETER_VALUE = 'Y' if standard file names are required (i.e. p
Try setting this parameter to N and see what happens. I have never tried this so let us know the results.
From: "Venkatesh, Masoor" mVenkate@wssc.dst.md.us
Date: Tue, 23 Feb 1999 18:19:20 -0500
You will have to get the .ch file out of unix and send it to the MICR
printer with the signature chip in it. The other option is to get the
services of companies such as Optio, that will setup a form template with
appropriate signatures, etc. and then this software will do all the work of
printing the checks. In our sites we are using the first method by setting
up a Unix shell script that the user executes to print the check. Hope this
helps and let me know if I can be of further help.
Regards,
Tony Venkatesh (301) 206-8452
http://www.mcsgroups.com
From: Terry Toms ttoms@FAMILYDOLLAR.com
Date: Mon, 8 Mar 1999 13:56:59 -0500
We are currently running 10.7 NCA Payroll. We have a situation
where checks are clearing the bank with a different check number than that
assigned by CheckWriter. The number is always one digit off and later in
the check run the check numbers seem to get back on track. Some examples
are as follows: Check number 30001 for 200.48 clears the bank as 30002.
Check 30002 for 400.57 clears as 30003. This continues until check number
30100 then mysteriously check number 30100 for 600.95 clears as 30100 for
600.95. Has anyone experienced this problem and if so, what did you do to
correct the problem? Thanks for your help.
Terry W. Toms
Applications System Administrator
Family Dollar Stores, Inc.
(Phone): (704) 847-6961 x4442
(Email): ttoms@familydollar.com
From: "William C.Stratton" bstratton@sprynet.com
Date: Mon, 8 Mar 1999 15:13:10 -0500
My initial guess is that the check number on the MICR coding is not matching
up to the check number that CheckWriter is producing on the face of the
check. Your bank is reading the coding to determine the check number. Are
you using preprinted check forms? If not, how are you getting the MICR on
the check stock? Could this be the source of your problem?
From: "Kim, Steven S" stevenkim@kpmg.com
Date: Tue, 9 Mar 1999 13:11:40 -0500
I have a question for anyone who may have encountered this situation and
resolved it in an automated process.
Situation:
An employee is monthly paid. The payroll frequency is monthly. The
employee is terminated in the middle of the month.
Problem:
The payroll process is run at the end of the month. The employee above is
processed but Oracle HRMS does not produce a paycheck for this payroll. I
do not want to run a Quickpay for this person on the termination date nor do
I want to create a new assignment status to pay this person then later
terminate them.
Has anyone found a easy automated way to get around this process problem?
This situation would be for all other payroll frequencies as well
Thanks
Steve
From: pkandra@civicdevelopment.com
Date: Tue, 9 Mar 1999 13:34:02 -0500
When you terminate the employee, make sure that the Final Process Date is on
or later than the check date of the payroll. If the employee is only
getting partial pay, also be sure to reduce their salary with the Special
Inputs earnings element.
Subject: RE: [orahrms-l] Processing the final pay for a terminated person
From: "Beers, Al" abeers@kpmg.com
Date: Tue, 9 Mar 1999 20:53:00 -0500
Oracle recommends that you DO NOT use the final process date, as this will
create issues should you need to make a correction on the employee's file or
process a W2C. Why would you use special inputs for a partial pay??
Shouldn't the system automatically calculate the salary based on the term
date, standard conditions, and pay frequency?
Al Beers
Consultant
KPMG LLP
Oracle Practice, Houston TX 77002
Cell Phone (281) 788-5589
Client Site: (203) 432-9476
Voice Mail (713) 319-2601
e-mail: abeers@kpmg.com
From: "Gregory A. Clark" GACLARK@us.oracle.com
Date: 09 Mar 99 19:57:07 -0800
Cc: gaclark@ibm.net, gaclark@us.oralce.com
Oracle does not recommend that you do not use the final process date. In fact,
it must be used if you want to rehire a perviously terminated employee. This
is a very common event for many clients who traditionally have high employee
turnover due to the nature of their business.
I know that the documentation states "it is best to leave the Final Process
date blank, so that you can make corrections to the final payment or make
other payments to the employee in the future if this is necessary." But do not
interpret this to mean that you should not use it at all. I personally
recommend my clients to set the final process date to a future period such as
a few weeks or a month after termination to accommodate the correction of any
discrepancies or pay anomalies due to timing issues.
The Final Process date is a date after which no further pay processing for the
employee can occur, if you are using Oracle Payroll. Essentially the employee
assignment, which is naturally a prerequisite structure for producing pay run
results, does not exist after the final process date. As for the Final Process
date creating issues when generating Form W2's for employees, my observation
has been that real issue that clients incorrectly try to create balance
adjustments using a date of 12-DEC-19XX instead of the a date equal or before
the final process date. Recall that a balance adjustment is merely an
assignment run result...so how can you produce a run result for an assignment
which does not exist at year end?
Finally, the use of the Special Inputs element to produce partial pay is a
technique that some clients have successfully used in the following scenario:
1. The Assignment Status used for the terminated employee has the HR system
status of Terminate Assignment and the Payroll system status of Process.
2. The terminated employee needs to be paid Regular Salary or Regular Wages in
a pay period occurring after the termination...for whatever reason.
3. The employee assignment has no timecard required.
4. The Regular Salary or Regular Wages Pay Value is based upon hours worked
which are less than the pay period hours derived from assignment work schedule
or the organization or business group standard hours.
5. One or more full pay periods occur between the termination date and the
final process date.
The Special Features element input value Replacement Amount replaces the
earnings element FastFormula calculated amount (standard hours X effective
hourly rate) with the desire amount.
Regards,
Greg
From: "Mark F. West" mwest@estee.com
Date: Fri, 19 Mar 1999 18:14:33 -0500
Cc: "Adler, Siegy" ESTEELAUDE/USMELVILLE/SADLER@email.
Folks,
We are installing Oracle HRMS ver 11. We have recently begun to examine the
check writing process. We have found the number of Earnings (8) or
Deductions & Taxes (15) that will print on the SOE before becoming
summarized as "other" to be inadequate. We will need to develop our own
process.
Therefore, any ideas, tips, leads, etc. on:
a) How do we go about this, what are the pitfalls to beware of?
b) Are there canned routines (Oracle or third party) that we can look at.
c) Alternate ways to accomplish the same thing that we should consider.
would all be gratefully received.
Thank you,
Mark F. West
Estee Lauder
From: "Ken Conway" k_conway@sprynet.com
Date: Sat, 20 Mar 1999 09:38:15 -0600
Cc: "Adler, Siegy" ESTEELAUDE/USMELVILLE/SADLER@email
Mark:
Check Printing issues within Payroll are a common issue we have observed
when implementing Oracle HR/Payroll. In fact is was a big enough issue to
be included as one of the Top 10 Challenges in the OAUG paper that Bill
Stratton and I wrote entitled "Oracle HR/Payroll - Top 10 Challenges".
Unfortunately, the best solution for your problem will be to modify the
Oracle report process PAYRPCHK. This will require added future maintenance
on your part. Your custom changes will need to be reapplied to any future
patches or product upgrades affecting PAYRPCHK.
We attempt to avoid this customization at most of our implementations but
sometimes there is no way around it. Are there any opportunities for you to
reduce the number earnings or deductions by consolidating multiple elements
into one element. I know this is not the answer you want to hear but it is
worth reviewing.
Please feel free to call me at 281-599-7654 or 770-622-5500 if you desire to
discuss this further.
Hope this helps,
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
From: "Dhawan, Radhika (Oracle Financial)" RDhawan@sigeco.com
Date: Mon, 22 Mar 1999 09:30:10 -0600
Hi All,
I am looking for table names where Current and YTD Gross Pay is stored - I
need this information for a 401K interface we are setting up in Oracle
Payroll.
Thanks,
Radhika.
From: "Venkatesh, Masoor" mVenkate@wssc.dst.md.us
Date: Mon, 22 Mar 1999 11:42:21 -0500
Radhika: Oracle Payroll is implemented in a way that these balances are not
stored in any table. You will have to write a PL/SQL procedure to utilize
the Oracle delivered package 'PAY_BALANCE_PKG'. This is the only way you
can get balances out of the Oracle Payroll system. I will be presenting a
paper 'TIPS ON IMPLEMENTING ORACLE PAYROLL' at the upcoming OAUG, San Diego,
on Wednesday at 9:30 AM that will explain some of these concepts. Hope you
can make it.
Regards,
Tony x8452
http://www.mcsgroups.com
From: "Schmit, Mark" mschmit@Mail.Donaldson.com
Date: Mon, 22 Mar 1999 10:41:38 -0600
Pay_run_results_values. But you need the element name for the correct
dimension. ( so join the per_people_f, per_assignments_f,
pay_assignment_actions, pay_payroll_actions, pay_run_results,
pay_run_result_values, pay_element_types_f with pay_time_periods!) I just
finished the Fidelity 401K project here and could give you the select I used
if you're interested.
From: Matt_Nebel@gallup.com
Date: Tue, 30 Mar 1999 14:32:18 -0600
We would like to be able to add a message on certain checks. This would be
similar to the memo line on personal checks. What steps do we need to
investigate to make this happen?
Thanks,
Matt Nebel
From: "Philomena, Rosy (Exor Consultant)" rphilomena@sigeco.com
Date: Mon, 5 Apr 1999 13:28:10 -0500
Hi,
Any information regarding using PayMIX with existing Wage Rate Table
will be of much help to us. We are unable to Validate or Transfer Time
Entry Wages using the Wage Rate Table. We did set up the Rows and Values.
But when running PayMIX we get error, for some reason the PayMIX entry (Time
Entry Wages) is not recognizing the Rate Code from the Wage Rate Table. We
get this error message: Rate Code does not exist. However, when we use just
the Rate Code through element entry screen, it recognizes and works fine.
Has anyone had this problem?
Thanks
Rosy
From: jowsley@usmarine.com
Date: Tue, 13 Apr 1999 09:59:03 -0700
We have a situation in which an employee was termed and a final process
date was not entered. We ran a payroll for the pay period ending March
27th with a check date of April 2nd. We then ran the costing and trasfer
to GL.
Well, it turns out that this employee was re-hired on the 29th of March,
but the paper work wasn't entered before the payroll was run. Of course,
the final process date has to be filled in before an employee can be
rehired. This is where we have a problem. HR cannot enter a final process
date because this person's assignment has been processed for a payroll.
I was able to roll back the assignment processing for prepayments, but not
for the payroll run. The payroll run itself could not be rolled back
because the transfer to GL had been completed and I can only roll back the
Transfer to GL for an assignment set, not just a single assignment.
Does anyone have any ideas about how to rehire this person? What are the
ramifications of rolling back the Transfer to GL for an assignment set?
Thanks for any insight that you might have on this.
From: "Beers, Al" abeers@kpmg.com
Date: Tue, 13 Apr 1999 20:08:29 -0400
If Accounting picked up the Transfer to GL and posted, you will not be able
to roll back the transfer. If they haven't, I would delete this one
employee from the Transfer to GL, then delete from the other post payroll
processes from the process performed last. For example: Checkwriter,
Costing, Prepayments, Payroll Run). Again, this will only work if
Accounting did not import the file.
From: jowsley@usmarine.com
Date: Tue, 13 Apr 1999 18:41:16 -0700
I was able to roll back the whole Transfer to GL process, but I couldn't
roll it back for only one individual. When I tried to roll back for just
one assignment, I received an error message telling me that I could only
roll back the whole process. I really appreciate your input, but I'm a bit
confused. Are you saying that if Accting hasn't uploaded from the GL
Interface table, then I should be able to roll back just one assignment?
That would be the ideal situation, since I'm not too keen on deleting the
Transfer to GL after it has been uploaded to the GL.
If we do roll back the entire process after Acct has picked it up from the
GL interface, do you know how this will impact the next round of payroll
post processing - ie. Costing, Transfer to GL, etc.?
So far, we've decided that the best approach is to re-hire the individual
on the first day that the system allows, which is the day after the last
check date. The Continuous Service Date, Vacation Date, etc. will be
adjusted to account for the apparent lost days. Also, procedures are being
put in place to hasten the data entry. Unfortunately, Oracle Payroll
doesn't permit the "last minute data cram" facilitated by the legacy
system.
From: "Menke, Irene M." menke@Mail.Donaldson.com
Date: Tue, 13 Apr 1999 13:12:09 -0500
Hello,
Could anyone please tell me if Deposit Advises get generated along with
regular checks
during a payrun and if they also get put on the same image file.
Thanks for your support.
Irene Menke
menke@mail.donaldson.com
612.887.3605
From: pkandra@civicdevelopment.com
Date: Tue, 13 Apr 1999 14:31:41 -0400
Irene,
The PrePayments process distributes employees net pay based on their payment
methods. The Check Writer process will generate an image file for checks,
the Deposit Advice process will generate an image file for deposit advices
and the NACHA process will generate the file that you'll submit to your bank
for direct deposits.
Peter Kandra
Civic Development Group
(888) 800-7637 x2518
From: "Dhawan, Radhika (Oracle Financial)" RDhawan@sigeco.com
Date: Thu, 15 Apr 1999 17:10:32 -0500
Does anyone know of any documentation that exists about the pay_balance_pkg.
The only documentation that I have seen is the 21/2 pages in the Oracle HRMS
US Implementation Guide. Has anyone used this package to get balances like
YTD and current month to date hours etc.
Thanks,
Radhika Dhawan
HRMIT
Southern Indiana Gas and Electric Co.
From: "Driver, Paul" p.driver@ic.ac.uk
Date: Fri, 16 Apr 1999 08:10:23 +0100
Hi Radhika
Why not use this code fragment to retrieve your balance values:-
FUNCTION get_ass_balance
( p_assignment_id NUMBER
, p_item_name VARCHAR2
, p_effective_date DATE
) RETURN NUMBER IS
CURSOR csr_defined_balance IS
SELECT TO_NUMBER(ue.creator_id)
FROM ff_database_items di
,ff_user_entities ue
WHERE di.user_name = p_item_name
AND ue.user_entity_id = di.user_entity_id
AND ue.creator_type = 'B';
l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
g_message_text VARCHAR2(240);
l_balance NUMBER;
l_balance_char VARCHAR2(12);
l_effective_date DATE;
BEGIN
OPEN csr_defined_balance;
FETCH csr_defined_balance INTO l_defined_balance_id;
IF csr_defined_balance%NOTFOUND THEN
CLOSE csr_defined_balance;
g_message_text := 'Balance DB Item does not exist';
RAISE hr_utility.hr_error;
ELSE
CLOSE csr_defined_balance;
END IF;
--
BEGIN
l_balance := pay_balance_pkg.get_value(l_defined_balance_id
,p_assignment_id
,p_effective_date);
EXCEPTION
WHEN no_data_found THEN
l_balance := 0;
END;
RETURN l_balance;
END get_ass_balance;
Hope it helps
P.Driver
From: "lakshmi mannem" prasuna_ml@hotmail.com
Date: Mon, 19 Apr 1999 13:34:07 PDT
Hi Folks:
I loaded the legacy balances into ORacle HR and later I ran the
quickpay process. Today, I did same conversion in my new instance and
after that I tried to run payroll/quickpay process, but they are
errored out with error message
HR_51118_HRPROC_ERR_OCC_ON_ASG
ASG_NO 202-44-0043
APP-51118: Error was encountered while processing the assignment
202-44-0043
HR_6882_HRPROC_ASSERT(LOCATION=py3usctx:1)
Did anybody encounter this type of error before.
The weird thing is I am able to see all my loaded balances through
Statement of Earnings. (????????????)
I am on R11.0.2
Thanks
Raju
From: "Driver, Paul" p.driver@ic.ac.uk
Date: Tue, 20 Apr 1999 08:08:29 +0100
Hi
Was the error just for one assignment or for all of them ?. If one try
removing that assignment and retrying the others.
Good luck
Paul Driver
From: "David Norton" dnorton@iciapps.com
Date: Tue, 20 Apr 1999 11:57:03 -0400
I have encountered a similar message when there were records in
pay_element_entries_f without children records in
pay_element_entry_values_f. An element entry must have at least on entry
value even if it is null. I also saw the same type of message in another
case, but I will have to look it up in may old TARs.
Hope this helps.
David Norton
Implementation Consulting Inc.
From: "Schmit, Mark" mschmit@Mail.Donaldson.com
Date: Wed, 28 Apr 1999 15:03:44 -0500
Has anyone started a routine from inside of a SQL script before? What's the
syntax of the command?
We have a need to implement a process that runs the check printing
concurrent manager process then a SQL script that modifies the check image
file. Immediately after that process I want to move the file to a secured
area using an existing UNIX command file. How do I call this command file
(called 'psecure') from within my SQL script?
thanks,
Mark Schmit
Donaldson Inc.
(612) 703-4606
From: Matt Surico surico@users.buoy.com
Date: Wed, 28 Apr 1999 22:32:26 -0400
In order to invoke an operating system command from within
SQL*Plus, you use either "host" or "!". So for example, if in the
middle of a script you wanted to see what directory you were in
(assuming this is a Unix box) you would run
SQL> !pwd
Similarily, you should be able to have a line that does
!psecure (with a fully qualified path to be complete, like
/usr/local/bin/psecure)
Does that accomplish what you need?
Matt
From: "Driver, Paul" p.driver@ic.ac.uk
Date: Thu, 29 Apr 1999 07:56:57 +0100
Mark
Why not create a report set to perform all of the tasks.
Cheers