CN Manual Payment Upload  Help

CN Manual Payment Upload creates, updates and deletes Incentive Compensation manual payments from Excel, the way the Manual Payments tab of the Paysheet Detail page does. It downloads the manual payments of unpaid payment batches for editing, saves each row with the same validations as the page, and shows the outcome of every row in the Excel file.

When to use it

• Enter one-off payments or corrections for many resources of a payment batch in one step, for example from a list prepared outside Oracle.
• Correct the amounts of manual payments before the payment batch is paid.
• Make manual payments recoverable from future earnings, or remove the recoverable flag.
• Delete manual payments entered in error.

Before you start

• You are signed in to a responsibility with access to the operating unit and to the upload in Blitz Report.
• Your user has the permission to adjust paysheets, as for manual payments on the Paysheet Detail page.
• The payment batch exists and is not paid yet, and the resource has a paysheet in it that is not locked or submitted for approval.

Choose a template

The default template is Default.

Step 1 – Set the parameters

Open CN Manual Payment Upload in Blitz Report, choose the template and set the parameters. They decide which manual payments are downloaded.

Step 2 – Run to download the Excel file

Click Run. With Create, Update, the file has one row per manual payment. On a downloaded row only Payment Amount, Recoverable, Reason and Delete Payment can be changed; Operating Unit, Payment Batch, Resource Name and Plan Element are read-only. Pay Period, Employee Number and Pay Element are filled in from the payment batch, resource and plan element. With Create, the sheet is empty.

Step 3 – Enter the manual payments

Change the downloaded rows, or add a row for each new manual payment.

• Operating Unit and Payment Batch – a payment batch of the operating unit that is not paid yet. Pay Period shows the pay period of the batch.
• Resource Name – a resource with a paysheet in the payment batch. Employee Number is filled in from the resource; enter it when the payment batch has paysheets of more than one resource with the same name.
• Plan Element – a plan element of the resource in the pay period of the payment batch. Plan elements assigned to a payee are not listed. Pay Element shows the pay element of the plan element.
• Payment Amount – required.
• Recoverable – Yes recovers the manual payment from the resource’s future earnings. Leave it blank for a payment that is not recoverable.
• Reason – added as a user note on the paysheet. Existing notes are shown on the Notes tab of the Paysheet Detail page.
• Delete Payment – Yes deletes a downloaded manual payment.

In the example, the manual payment of Phillip Charles Taylor for Assembled Computers in payment batch OIC_Feb_2008 is corrected from 250.50 to 300, the payment of Lisa Jones for Standard Computers is made recoverable from future earnings, and new manual payments are entered for Jeffery Ulrich (Standard Computer Manager, 500) and Lisa Jones (Assembled Computers, 120).

Step 4 – Validate and Save

Click Validate and Save on the Blitz Report tab. This checks for missing required values and for values that are not in their lists, marks the rows Valid and saves the file. Correct any rows it flags before uploading.

Step 5 – Upload the file

Click Upload on the Blitz Report tab. The add-in sends the valid rows to Oracle and submits the upload request. The upload request processes the rows in order. Each row is saved or rejected on its own, so a rejected row leaves nothing behind and does not affect the other rows.

Step 6 – Review the result

When the request completes, the add-in writes the result to the sheet, listing every uploaded row with its status and a message, for example Manual payment created., Manual payment updated. or Manual payment deleted., or the reason the row was rejected. The result shows the values as they were saved in Oracle.

What’s produced

• Manual payments on the paysheets of the payment batch, saved as the Paysheet Detail page saves them.
• The same system notes on the paysheet as the Paysheet Detail page writes for each created, changed or deleted manual payment, and the Reason as a user note.
• A rejected row leaves nothing behind and does not affect the other rows.
• The result in the Excel file, listing every row with a status (success or error) and a message.

Common questions

Can I move a manual payment to another plan element?
No. Only the Payment Amount and Recoverable flag of an existing manual payment can be changed. Enter Yes in Delete Payment on the downloaded row and add a new row with the other plan element.

Which notes are written on the paysheet?
Each created, changed or deleted manual payment writes the same system note as the Paysheet Detail page, for example New Manual Payment Adjustment with Payment Amount 250.00 and Recoverable Flag value N was created. Text entered in Reason is added as a user note, once per paysheet and text, so the same reason on several rows of a paysheet is added once.

Can I download the manual payments of paid batches?
Yes. Clear Unpaid Batches Only. Manual payments of a paid payment batch cannot be changed or deleted.

Does the upload create payment batches or paysheets?
No. Create the payment batch and the resource’s paysheet in Payments, Payment Batches first.

What does Recoverable mean?
A recoverable manual payment is recovered from the resource’s future earnings.

Troubleshooting