Here's a short guide on how to update the TA destination depot:


1. psql to jboss-cima Postgresql database.

2. Run the following SQL update statement:

    start transaction;

    UPDATE transferadvices SET destinationdepotid='<target_depot_id>' WHERE transferadvicenumber='<target_transferadvice_number>';

    commit;


3. Go to jmx-console and open the link to "jndiName=TransportCostBeanLocal,plugin=cache,service=EJB".

    Flush the bean by clicking on the Invoke button in the flush operation.


4. For reference, here's the depot id table.


Depot ID Depot Code
14-3 BA
14-299 BCT
14-14 BK
14-16 BT
14-686 BW
14-641 GK
14-963 HC
14-858 IP
14-983 JB
14-18 KB
14-761 KCT
14-8 KG
14-987 KW
14-1045 NW
14-847 SB
14-811 SW