Writeback Errors
When using writeback functions in xpna, errors may occur if the attempted writeback violates business rules or data constraints. When this happens, the system provides detailed error information to help identify and resolve the issue.
Writeback Functions
Writeback errors can occur when using either of the following xpna functions:
- xpna.DATAWRITE - Writes a single value to a specific data point by typing directly into the cell or pasting values
- xpna.DATASEND - Writes multiple values to data points using values referenced from other cells
Common Error Conditions
Writeback operations will fail and generate errors under the following conditions:
Scenario Restrictions
- Actuals Scenario: Writebacks to the Actuals scenario are prohibited unless writing to Non-financial accounts or elimination entities
- Closed Scenarios: Writebacks cannot be performed on scenarios that have been closed for writebacks
Entity Selection Restrictions
- Multiple Entities: Writeback operations are restricted to a single entity. If more than one entity is selected, an error will be generated
Security Access Restrictions
- Role-based Security: When role-based security is enabled, writeback errors will occur if attempting to write to data points that the user does not have access to based on their assigned security group rules. The error message will indicate the specific restrictions that prevent the writeback (e.g., accounts, countries, departments, or entities that are outside the user's permitted access)
How Errors Are Displayed
When a writeback error occurs, the system provides error information in multiple locations:
Error Cell Display
The cell containing the writeback function will display an ERROR value and be presented as a rich entity card. This visual indicator makes it easy to identify which cells have writeback errors.
Context Aware Section
When an error cell is selected, the context aware section in the task pane displays detailed error information, including:
- The cell address where the error occurred
- A detailed error message explaining why the writeback was prohibited
- The specific restrictions that were violated
Clearing Writeback Errors
To reset writeback errors and enable the re-submission of new values:
- Select the cell containing the writeback error
- In the context aware section, click the
Clear Writeback Errorsaction button - The error state will be cleared, allowing a new writeback attempt
Note:
Clearing errors does not resolve the underlying condition that caused the error. The same business rules will still apply to subsequent writeback attempts. Ensure that the scenario is open for writebacks and that only a single entity is selected before attempting to write back again.