ORACLE UTILITIES EBS-WAM - STOREROOM INTERFACE RUNS TO MANY ROWS. (Doc ID 1072160.1)

Last updated on OCTOBER 16, 2016

Applies to:

WAM-EBS Integration - Version 1.1.0 to 1.1.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

After enabling the EBSToWAMStoreRoomBpelProcess (v. 1.0), the interface keeps creating over 100,000 rows of data in the ugbu_subinventory_stg and waif_storeroom tables respectively. We only have approximately 15,000 rows of data in the EBS subinventory. The interface seems to execute the package UGBU_SUBINVENTORY_PKG every 5 minutes.

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