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

Cannot update the SHIPMENT_COST_REMARK_T record. [REMARK_QUAL_GID] must reference a valid REMARK

in Transportation Management 3 comments

Cannot update the SHIPMENT_COST_REMARK_T record. [REMARK_QUAL_GID] must reference a valid REMARK_QUAL_T record.

any idea about this issue?

here for my sql on agent

INSERT INTO SHIPMENT_COST_REMARK ( SHIPMENT_COST_SEQNO, REMARK_SEQUENCE, REMARK_QUAL_GID, REMARK_TEXT, DOMAIN_NAME) SELECT SC.SHIPMENT_COST_SEQNO, REMARK_SEQUENCE.NEXTVAL AS NEXT_VAL, 'PL.APPROVE_ADD_COST' AS REMARK_CATEGORY, ( SELECT MAX(SHS.UPDATE_DATE) FROM SHIPMENT_STATUS SHS JOIN SHIPMENT SHP ON SHP.SHIPMENT_GID = SHS.SHIPMENT_GID WHERE SHP.SHIPMENT_GID = 'PL.SHPL20240604-0203' AND SHS.STATUS_VALUE_GID LIKE '%BUY_COST_MOD_APPROVED' ) AS REMARK_VALUE, SC.DOMAIN_NAME FROM SHIPMENT_COST SC WHERE NOT EXISTS ( SELECT 1 FROM SHIPMENT_COST_REMARK SCR WHERE SCR.SHIPMENT_COST_SEQNO = SC.SHIPMENT_COST_SEQNO AND SCR.REMARK_QUAL_GID = 'PL.ADDITONAL COST' ) AND GLOG_UTIL.REMOVE_DOMAIN(SC.ADJUSTMENT_REASON_GID) = 'ADD_COST' AND SC.SHIPMENT_GID = ?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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