Unique Release ID Failure When Creating Two Release Instructions. (Doc ID 1319211.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

On OTM version 6.2 a BN Rule is created for Order Release with the following Rule:

{r*:id=1:xml=BASE}_{r*:xml=OBSURELEASEINSTRUCTIONSEQ}{r*:xml=OBRELEASEINSTRUCTIONSEQ}

When two Release Instructions are created from an Order Base to create Releases at the same time, this is failing with the following error:

ERROR:
---------
Cannot add the ORDER_RELEASE record. ORDER_RELEASE_GID must be unique.
java.sql.BatchUpdateException: ORA-00001: unique constraint (GLOGOWNER.PK_ORDER_RELEASE) violated

STEPS TO REPLICATE:
---------------------------
* Created Order Configuration: 3-3394315971

Order Base/Release Creation: Ship Unit

Order Base
Order Base Line
Net Weight: Never
Net Volume: Never
Total Package Count: Never
Packaging Unit Count: If_NULL

Order Base - Order Base Ship Unit Line:
Total Weight: ALWAYS
Total Volume: IF_NULL
Total Package Count: NEVER
Package Unit Count: IF_NULL

Order Base - Releasing Rules:

Allow Over Releasing: Ticked
Single Release Per Instruction: Ticked
Release Qualifier: Count
Plan From/To Type: POPULATE PLAN FROM/TO

Order Release
Ship Unit Calculation: SU_TO_LINE

Ship Unit
Gross Weight: Never
Gross Volume: IF_NULL
Net Weight: IF_NULL
Net Volume: IF_NULL
Total Gross Weight: ALWAYS
Total Gross Volume: ALWAYS

Formula
Calculate Using Ship Unit Dimensions
Gross Weight Per Ship Unit - Tare of THU
Gross Volume Per Accounting for THU Volume.
Gross Weight Per Ship Unit x Count
Gross Volme Per Ship Unit x Count

Ship Unit Line
Gross Weight: ALWAYS
Gross Volume: IF_NULL
Total Package Count: ALWAYS
Packaging Unit Count: ALWAYS

* Created Order Base: 3-xxxxxxxxxx_BACKUP
* Update BN_RULE: ORDER_RELEASE_XID.DEFAULT as follows:

was: {r*:id=1:xml=BASE}-{nnn:contexts=1:start=1}
now: {r*:id=1:xml=BASE}_{r*:xml=OBSURELEASEINSTRUCTIONSEQ}{r*:xml=OBRELEASEINSTRUCTIONSEQ}

1. Navigate to Order Management -> Order Base -> Order Base
2. Search for Order Base: 3-xxxxxxxxxx
3. Delete this Order Base
4. Search for 3-xxxxxxxxxx_BACKUP
5. Actions -> Order Management -> Utilities -> Copy Order Base
6. Enter ID: 3-339431597, click Ship Unit button
7. Edit the Ship Unit, enter a Ship Unit ID of 3-xxxxxxxxxx
8. Uncheck the "Shippable" flag
9. Click "Save", then Finished
10. Actions -> Order Management -> Change Order -> Release Ship Units
11. Click "New Release Instruction"
12. Enter 10 Unit Amount
13. click "Save"
14. Click "New Release Instruction" (again)
15. Enter 15 Unit Amount
16. click "Save"
17. Click Finished

This is failing with:

Cannot add the ORDER_RELEASE record. ORDER_RELEASE_GID must be unique.
java.sql.BatchUpdateException: ORA-00001: unique constraint (GLOGOWNER.PK_ORDER_RELEASE) violated

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.