PER Payroll Element Entry Upload creates, updates, deletes and adjusts payroll element entries – with their input values – for an employee’s assignment in Oracle HRMS/Payroll, from Excel, via the standard DateTrack-aware Oracle public API.
When to use it
- Mass-load new recurring element entries (allowances, deductions) for many employees at once.
- Update the input values of existing element entries across a population.
- Enter adjustment element entries against existing entries.
- Delete element entries in bulk using the appropriate DateTrack delete mode.
- Apply DateTracked, API-validated changes effective on a specific date, instead of manual entry.
Before you start
- Blitz Report is installed and you are signed in to a responsibility with access to the business group.
- The employee has a primary, active assignment.
- The element has a valid element link that applies to the assignment and is effective on the entry date.
Step 1 – Choose a mode, set the parameters and download
In Blitz Report, open PER Payroll Element Entry Upload, choose an Upload Mode (Create for an empty template, or Create, Update to download existing entries to update or delete), and set the parameters:
| Parameter | Purpose |
|---|---|
| Upload Mode | Create or Create, Update. Default is Create. |
| Business Group | The business group (required); also filters the employee list. |
| Employee Name | Optionally download entries for a single employee. |
Run the upload to download and open the Excel file.
Step 2 – Enter the element entries
On each row enter the Employee Name, the Element Name, the Entry Type (Entry or Adjustment), the Effective Date, and the amounts in the Input … Entry Value columns. For an update or delete, also choose the Datetrack Update Mode.
Step 3 – Delete entries (optional)
To remove an entry, set Delete Element Entry to Yes on its row and choose a DateTrack delete mode in the Datetrack Update Mode column. The entry must already exist (download it first).
Step 4 – Validate and Save
Click Validate and Save. This checks for missing required values and runs the upload’s validation, then saves the file. Correct anything it flags before continuing.
Step 5 – Upload and view the result
Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which creates, updates, adjusts or deletes each element entry. When it finishes, a result report opens showing each row as success or error.
What’s produced
- Created, updated, adjusted or deleted payroll element entries with their input values.
- A result report listing every row with a status (success or error) and a message.
Common questions
How do I delete an element entry?
Download in Create, Update mode, set Delete Element Entry = Yes on the row, choose a delete mode in Datetrack Update Mode, and upload.
What’s the difference between Entry Type “Entry” and “Adjustment”?
Entry creates a normal element entry; Adjustment creates an adjustment entry linked to the employee’s existing entry for that element.
Why can’t I edit Business Group, Employee Name, Element Name or the input-value-name columns?
They are read-only keys/labels set from the download; you enter data in the Input … Entry Value columns (and Effective Date, Entry Type, etc.).
Which Datetrack Update Mode should I pick?
For an update, choose how the dated change is applied (e.g. Correction or Update); for a delete, choose the delete mode. It is required for both update and delete.
Why doesn’t an employee appear in the list?
Only employees in the selected business group with a current, active, non-terminated assignment are listed.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| Datetrack Update Mode is required | The mode was left blank on an update or delete row. | Select a DateTrack mode (update modes for an update, delete modes when Delete = Yes). |
| Element entry not found / invalid object version | Updating or deleting an entry that wasn’t downloaded, or stale data. | Re-download in Create, Update mode so the entry’s current identity is present, then re-upload. |
| The element link is not valid on the effective date | The element isn’t linked to the assignment, or not effective on the date. | Verify the element is linked to the assignment and effective; pick a valid element. |
| No existing entry to adjust against | An Adjustment row has no base entry for that element/assignment. | Ensure a base entry exists, or use Entry Type “Entry”. |
| Input entry value validation error | The value doesn’t match the input value’s validation/lookup. | Use the dropdown where offered, or enter a value within the element’s defined validation. |