Procedure Bompexpl.exploder_userexit doest not Detect Bills of Material Loop (Doc ID 1534512.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Bills of Material - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Bills

When running procedure bompexpl.exploder_userexit throw pl-sql for ASSEMBLY bom explosion and for this ASSEMBLY has a loop in his BOM the loop doesn't detected (loop is shown throw Bills of material form and ECO form - BOTTON --> tools --> "check for loops").
In bompexpl.exploder_userexit there is out parameter - ERROR_CODE - that this parameter return 9999 if loop detected. But ERROR_CODE is always 0 although there is a loop.


EXPECTED BEHAVIOR

The loop into procedure bompexpl.exploder_userexit throw pl-sql for ASSEMBLY bom explosion should be detected.


STEPS

The issue can be reproduced at will with the following steps:

  1. Run the procedure bompexpl.exploder_userexit throw pl-sql for ASSEMBLY bom explosion

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms