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

Add Comment
2 Answer(s)

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.

Agile Angel Answered on August 20, 2018.
Add Comment

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.

Agile Angel Answered on August 20, 2018.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.