3809066 - CA-127: Cannot Perform Operation [REFERENCE = REFERENCE_COLLECTION] When Joining Resources in Query API

When using the Query API to retrieve data from both the Service Call and Equipment master tables in a single request, the query fails when attempting to join the resources using Equipment ID.

For example, the following query is used:

SELECT sc
FROM ServiceCall sc
INNER JOIN Equipment eq ON eq.id = sc.equipments;

The Query API returns an error similar to:

CA-127: Cannot perform operation: [REFERENCE = REFERENCE_COLLECTION].
Please consider to change the ...

As a result, the expected data from the Service Call and Equipment resources cannot be retrieved using this query.

• SAP Field Service and Asset Management (FSA)

CA-127, Cannot perform operation, REFERENCE, REFERENCE_COLLECTION, Query API, FSM Query API, SAP Field Service Management, ServiceCall, Service Call, Equipment, Equipment ID, INNER JOIN, JOIN, IN operator, equality operator, reference collection, resources collection, query error, API error, eq.id, sc.equipments , KBA , CEC-SRV-FSM-API , FSM API , CEC-SRV-FSM-ADM , FSM System Administration , How To