Engineering Change Order Implementation Concurrent Program (ENCACNC) Failing with Errors ORA-06510 ORA-06512 (Doc ID 1965610.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Engineering - Version 12.1.3 and later
Oracle Bills of Material - Version 12.1.3 and later
Information in this document applies to any platform.
Concurrent: ENCACNC - Engineering Change Order Implementation
Concurrent: BMCMUD - Mass Change Bills of Material
Form: BOMFDMCO - Mass Change Bills of Material (Bill or Engineering Mass Change Orders)

Symptoms

Engineering Change Order Implementation concurrent program (ENCACNC) completes with Error and with the following message in the report output.

The problem would occur for instance when attempting to implement a Bill or Engineering Mass Change to all existing BOMs. (bills of materials)

-- Error
In the report output, for the last REVISED ITEM appearing in the file:
[
MESSAGE
------------------------------------------------------------------------------
Implementation failed: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APP
]

-- Steps
The issue can be replicated per the below steps:
1. Create a Mass Change through Mass Change Bill or Engineering Mass Change form (BOMFDMCO)
Select the range of Revised Items
2. Create a record in Component Changes window
3. Implement the Mass Change
4. Monitor the concurrent requests
5. See Engineering Change Order Implementation request completes with Error


-- Business impact
Due to this issue, users cannot apply the desired change to existings BOM(s).

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