Looking for script to correct duplicate BOM component entries
I’m hoping we’re not the only ones that have experienced this, but from time to time we see duplicate components on an item’s BOM within the web client (Agile 9.3.2). We know that running Averify and Fix scripts fix these entries, and our DBAs typically run these once per month. We had an issue that preventing these scripts from being run this weekend, but we have a specific BOM that requires correction and would prefer not to wait for the next scheduled run of Averify (because they take about 8 hours to run). What I’m hoping someone can tell me is which script within Averify identifies these flawed BOM records and which scripts are run to correct them. I’m looking to create our own script to fix a specific BOM.
Thanks in advance,
Steve
There is a Smart Rule that is supposed to allow or disallow duplicate BOM entries. Are you saying that is already set to Disallow and you are still getting duplicate entries?
Averify can be run in different modes. One of which is to test for specific error types, (e.g. AGIL-00025135). Figure out the BOM error types you want to test for by looking at your previous reports. Then set in the config/averify.properties file.
Doc ID 1121926.1 from the Oracle knowledge zone has a list of all of the Averify scripts. I didn’t directly find the one you’re referring to but perhaps some of your earlier log files give you hints about what SQL script was ran.
Looks like, after seeing Doc ID 1932718.1, your Averify might have been running AGIL-00075061_c1.sql . There, the simplified version of the SQL script is this:
SELECT B.id “BOM.ID”
FROM bom B
WHERE B.change_in != 0
AND NOT EXISTS (SELECT R.id
FROM rev R
WHERE R.change = B.change_in
AND R.item = B.item)
UNION
SELECT id
FROM bom
WHERE prior_bom IN (SELECT id
FROM bom B
WHERE B.change_in != 0
AND NOT EXISTS (SELECT R.id
FROM rev R
WHERE R.change = B.change_in
AND R.item = B.item));
Somewhere else on the Oracle website I found the Averify Script.zip folder with all of the extended sql scripts. If you can’t find it and need the one for AGIL-00075061_c1.sql, let me know.
Try that.
