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

Merging Sell Shipment Error

Summary:

Error while merging sell shipment

Content (please ensure you mask any confidential information):

I use DUS to insert line in the shipment_cost upon a custom agent event when attribute_number4 in sell shipment is modified
INSERT INTO SHIPMENT_COST (
SHIPMENT_COST_SEQNO,
SHIPMENT_GID,
ADJUSTMENT_REASON_GID,
ATTRIBUTE1,
COST_TYPE,
COST,
COST_GID,

BILLABLE_INDICATOR_GID,
IS_COST_FIXED,
EXCHANGE_RATE_GID,
DOMAIN_NAME
)
SELECT
(SELECT NVL(MAX(SHIPMENT_COST_SEQNO),0)+1 FROM SHIPMENT_COST) AS SHIPMENT_COST_SEQNO,
S.SHIPMENT_GID,
'CREW.CUSTOMER SERVICE ADJUSTMENT',
(SELECT ORDER_RELEASE_GID FROM ORDER_MOVEMENT WHERE SHIPMENT_GID = S.SHIPMENT_GID),

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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