When trying to edit the order code or item code from the works order header, the following error generates:
Cannot find either columns "Utility" or the user-defined function or aggregate utility.fn_SfdcOrderHasBookings or the name is ambiguous
Or, the following data import error generates:
Orchestrate Data Flow Import has failed. The detailed information is as follows:
Cannot find either columns "Utility" or the user-defined function or aggregate "utility.fn_SfdcOrderHasBookings", or the name is ambiguous.
ImportCommand:
EXEC [wf].[pr_UpdateDemandPlannerPurchaseOrderCodeWithSageOrderCode]
If you are trying to edit the works order, the functionality has been enhanced in Orchestrate version 7.83. Please upgrade to this version or above.
If you are trying to run a data import, Support need to run some scripts to stop the trigger from the Orc_Orders table, executing any stored procedures or functions related to SFDC. Please start a conversation on the Access Community Portal. How to contact Support via the MyAccess Portal | Orchestrate Help Centre