Views:

Applies to Product - FnO Platform
 

What’s happening?
The customer encountered an error during the purchase requisition workflow approval process, specifically: "Stopped (error): X++ Exception: Failed to find expression record."
 

Reason:
The underlying cause of this appears to be related to missing expression records in the workflow evaluation process.
 

Resolution:

  1. Delete the existing workflow batch jobs related to the following processes:
  2. Workflow message processing
  3. Workflow due date processing
  4. Workflow line-item processing
  5. Navigate to:
  6. System Administration → Workflow → Workflow infrastructure configuration
  7. Verify and update fields as needed.
  8. Click to reconfigure the workflow batch jobs correctly.
  9. Obtain Just-In-Time (JIT) access for the Tier 2 database. Refer to the documentation on enabling JIT access for Finance & Operations.
  10. Backup the EventInboxData.
  11. Execute the following SQL command:
  12. select * into <backup_table> from EventInboxData
  13. truncate table EventInboxData
  14. Confirm with the customer if these steps resolved the issue or if further assistance is needed.