Resolving HSP_ID_xxxx Errors while Running Rules in Workforce
What Causes HSP_ID_XXXX Errors
HSP_ID_xxxx errors can be caused by the following:
- Migrating only the Oracle Essbase data from one environment to another.
- Deleting members from a component, account (for example, options and tiers) or driver dimension (for example, union code and employee type) which is already assigned to employees as Smart List values.
- Deleting members from the Financials cube used as Smart List values in the Workforce Financials mappings.
Fixing HSP_ID_xxxx Errors
The easiest method to fix HSP_ID_xxxx errors is to perform a complete migration of the application using an application snapshot. If this is not possible, use the following instructions to fix invalid data and correct HSP_ID_xxxx errors.
Fix Invalid Data
Using Oracle Smart View for Office, perform an ad hoc analysis on the Identify invalid data form. Change the form definition to arrange all lev0 entities (employees, jobs, and periods) in rows and OWP_Financial Account (if enabled) in columns so that you can easily identify invalid data.
Fix any invalid data present in the application.
Correct HSP_IDs
If you find no invalid data in the application, use the following procedure to find HSP_ids that cause the error ad fix them.
- Using a browser, sign into your Workforce environment.
- Export data to a CSV file.
- From the Home page, select Application and then Overview.
- From Actions, select Export Data.
- In Export Data, click Create.
- In Export Data, for Dynamic Members option, select Exclude.
- Define the Slice Definition:
- From: In Slice Definition, select lev0 accounts in Row, lev 0 period in Column, and other dimensions in Point of View for data export.
- To: In Slice Definition, select lev0 accounts in Row, lev 0 period in Column, and other dimensions in Point of View for data export. Note: Select the members of the Smart Lists OWP_Option, OWP_Tier, OWP_Salary Basis, and No Property from Property dimension).
- Click Export.
- Open the CSV file that you created by exporting application data.
- Using the error number as the search string, search the CSV file to locate the intersection that is causing the error. For example, if the error is HSP_ID_1234, search for 1234.
- In Workforce, review and correct the data as needed until all reported errors are fixed.
Fixing HSP_ID_0 Error
Load all mandatory fields in Workforce.