You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!