PER Location Upload creates, updates and deletes Oracle EBS HR Locations from Excel – the global and business-group locations shared across HR, Purchasing, Inventory and other modules – including country-specific addresses, site-usage flags, designated receiver, time zone and the location descriptive flexfield, via the standard Oracle public API.
When to use it
- Mass-create new HR locations (for example onboarding a new set of sites or a new country).
- Bulk-update existing locations’ descriptions, addresses, time zones or site-usage flags.
- Enable or disable site usages (Bill-To, Ship-To, Receiving, Office, Internal) across many locations.
- Re-point Ship-To relationships between locations.
- Maintain the location descriptive flexfield values in bulk.
- Inactivate locations, or delete unused ones.
Before you start
- Blitz Report is installed and you are signed in to a responsibility tied to the intended business group.
- Address styles, time zones, countries, inventory organizations and employees (for the designated receiver) already exist.
- Locations download for your current business group plus global locations.
Step 1 – Choose a mode, set the parameters and download
In Blitz Report, open PER Location Upload, choose an Upload Mode (Create, Update – the default – downloads existing locations to edit; Create gives an empty template), and set the parameters:
| Parameter | Purpose |
|---|---|
| Upload Mode | Create or Create, Update. Default is Create, Update. |
| Default Address Style | The default country address format for new rows (required). |
| Location Name / Like / Status / Country / Global / site flags | Restrict which existing locations are downloaded. |
Run the upload to download and open the Excel file. Each location is automatically handled as a create or an update depending on whether the Location Code already exists.
Step 2 – Enter the locations
On each row enter the Location Code (the unique key) and a Description, choose the Address Style and fill its address fields (Address Line 1, Town or City, Postal Code, Country, etc.), and set the site-usage flags, Inventory Organization, designated receiver (Contact) and Time Zone as needed. For a new location, leave Business Group blank to make it global, or pick one to make it local.
Step 3 – Delete locations (optional)
To remove a location, set Delete Location to Yes on its row. The location must already exist, and legal-address locations cannot be deleted.
Step 4 – Validate and Save
Click Validate and Save. This checks for missing required values and runs the upload’s validation (including address validation against the chosen style), 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 or deletes each location. When it finishes, a result report opens showing each row as success or error.
What’s produced
- Created, updated or deleted HR locations with their addresses, site flags and flexfield values.
- A result report listing every row with a status (success or error) and a message.
Common questions
Are these the global locations used by Purchasing and Inventory, or HR-only locations?
They are the standard HR locations used across HR, PO, INV and more. Leave Business Group blank for a global location; assign one for a local location.
Why did my Ship-To / Receiving flags change to something I didn’t enter?
They are auto-corrected. A self-referencing (blank or same) Ship-To Location forces Ship-To = Yes and Receiving = Yes; pointing to another location forces Ship-To = No; whenever Ship-To = Yes, Receiving is forced to Yes.
Can I set the Legal Address flag?
No. It is information only and cannot be set or changed by the upload.
Why can’t I set an Inactive Date on some locations?
Legal-address locations are protected from inactivation (and deletion).
A row says “No changes detected” – did anything happen?
No. The location already matched the uploaded values, so no update was performed.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| Location Code is required | The Location Code cell was left blank. | Enter a unique Location Code (it is the required key). |
| Cannot set Inactive Date on a Legal Address location | Tried to inactivate a legal-address location. | Remove the Inactive Date; legal-address locations can’t be inactivated. |
| Location to delete does not exist | Delete = Yes for a location code that isn’t found. | Verify the code; only existing locations can be deleted. |
| Address validation error | The address fails the rules of the selected address style. | Correct the address fields for that country/style, or change the address style. |
| Location flexfield validation error | An invalid location-attribute value. | Pick valid flexfield values for the chosen attribute category. |