| Figured it out.
See delete statmens below that should be executed in SQL as the user glogowner, you need to know the order release gid, the shipment gid and the voucher gid.
DELETE FROM ALLOCATION_ORDER_RELEASE_D
WHERE ORDER_RELEASE_GID in ('RHL.27-13048','RHL/MBUSA.38-439118');
DELETE FROM ALLOCATION_D
WHERE
ORDER_RELEASE_GID in ('RHL.27-13048','RHL/MBUSA.38-439118');
DELETE FROM ALLOCATION
WHERE
ORDER_RELEASE_GID in ('RHL.27-13048','RHL/MBUSA.38-439118');
DELETE FROM VOUCHER_STATUS
WHERE
VOUCHER_GID in ('RHL.20051207-0093');
DELETE FROM VOUCHER_REFNUM
WHERE
VOUCHER_GID in ('RHL.20051207-0093');
DELETE FROM VOUCHER_INVOICE_LINEITEM_JOIN
WHERE
VOUCHER_GID in ('RHL.20051207-0093');
DELETE FROM ALLOCATION_BASE
WHERE
SHIPMENT_GID ='RHL.03800';
DELETE FROM VOUCHER
WHERE
VOUCHER_GID in ('RHL.20051207-0093');
Commit; |