Symptom
During ETL, Transformation & Load failed with below error:
Error creating BusinessObject: There was a problem executing your SQL statement: line 78:58: Column 'pr created date' cannot be resolved
Environment
SAP Signavio Process Intelligence 3.0
Reproducing the Issue
- Open PI
- Navigate to Manage Data
- Select the Process data pipeline tab.
- Select a pipeline on the new page
- Press Run ETL button
- See you are faced with above error.
Cause
After checking the transformation template (Purchase Requisition), in the first place it says PR Created Date, but in the subquery, the column name is Last PR Created Date.
Resolution
Development have created a bug ticket for this issue and are fixing the PTP template asap. If you are affected by this Bug, please let us know by raising a case via the SAP for Me platform and reference this knowledge article.
See Also
For more information on the Procure-to-Pay template, please read the following excerpt from our user guide: https://documentation.signavio.com/suite/en-us/Content/process-intelligence/procure-to-pay-sap-s4hana.htm
Keywords
process, intelligence, ptp, procure, pay, template, error, creating, businessobject, etl, full, transform, load , KBA , BPI-SIG-PI-TRA , Transformation (Business Objects / Pipelines) , Known Error