Unable to access table shipment from claim where domain='SERVPROV'
Summary:
When trying to reach some shipment field from a claim agent, when the claim is created by a SERVPROV user, OTM does not return any information. The data type association define in OTM CLAIM TO SHIPMENT (PUBLIC) is not working either.
For example, I need to know the servprov name, so I do the following query in the agent to obtain it: SELECT LOCATION_NAME FROM LOCATION WHERE LOCATION_GID = (SELECT SH.SERVPROV_GID FROM CLAIM C, SHIPMENT SH WHERE C.SHIPMENT_GID=SH.SHIPMENT_GID AND C.CLAIM_GID=$GID)
When the user that creates the claim is in the client domain (IFA), it is working, but when it is a SERVPROV user who creates the claim, it is like OTM cannot reach the table shipment.
0