Aloz 的 Oracle ERP 天地

因為我們有做訂單外部簽核, 簽核完之後都是走標準的 Order Import, 所以常常會遇到很奇怪的問題......

目前最常遇到的情形是, "Blanket sales agreement is locked by another user", 這個其實是老問題, 當初很直覺的覺得, 就是使用者忘了把 BSA 畫面關掉所致, 但是在最近幾次與使用者確認過後才發現好像不是這樣, 上 Metalink 才發現這是一個"問題"

(PS. 新版的 Metalink 在 Search 方面好像有強化, 比舊版更精準地查到我的問題)

Metalink Doc ID : 727777.1

Applies to:
Oracle EDI Gateway - Version: 11.5.10 to 11.5.10.2
This problem can occur on any platform.

Symptoms
-- Problem Statement:
On 11.5.10 in Production:
When attempting to import order lines which referencing the same blanket agreement number,
the following error occurs:

ERROR
"Blanket sales agreement is locked by another user. Please try later. Blanket Number: XXXX"

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Interface EDI 850 (POI) Multiple Sales Orders (Headers / Lines / Pricing Attributes) all
referencing the same Blanket Agreement Number on the Header and Line.
2. The first order record will import successfully but subsequent order records will fail with
error message on step 1 above.

Cause
This issue is described in Bug 4673289
ORDER IMPORT - BLANKET SALES AGREEMENT LOCKED BY ANOTHER USER

At this time, we do not lock the record before calculating the cumulative,
we do it in the memory, causing the locking issue.
Because of this limitation we are suggesting as a workaround to group by Customer.
That way every BSA will tie up with only one customer.
In this case - can send sold_to_org_id as a parameter to Order Import.

Solution

-- To implement the solution, please execute the following steps:

1. Go into the responsibility: Order management responsibility

2. Run order import by passing parameter 'number of instances' as 1

3. Retest the issue.

4. Migrate the solution as appropriate to other environments.