Performance Issue With BOM_RTG_PUB.PROCESS_RTG When Add Item to Delete Group (Doc ID 2107385.1)

Last updated on MARCH 17, 2016

Applies to:

Oracle Bills of Material - Version 12.1.1 to 12.1.3 [Release 12.1]
Oracle Bills of Material - Version 11.5.10.0 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

Actual Behavior
When adding 50000 items to BOM delete group using BOM_RTG_PUB.PROCESS_RTG API, it takes 3 hours.
From AWR report Following SQL take much time.

Expected Behavior
Improve the performance to add items to BOM delete group using BOM_RTG_PUB.PROCESS_RTG API

Steps to Reproduce

  1. Run BOM_RTG_PUB.PROCESS_RTG API

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