AIP-Online: Purging Process aip_purge.sh Fails Due to Missing Child Tables (Doc ID 2185811.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Oracle Retail Advanced Inventory Planning - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

The following purging processes fail due to missing child tables:

 
  1. Parent Table: DEMAND_GROUP

      - Child table missing: ALTERNATE_SOURCES_LIST
      - Purging process: purge_commodity_pack_size
      - Error message: integrity constraint (AIP_Q10_SCH01.ASL_DG_FK1) violated - child record found returned by AIP_PURGE.EXECUTE_PURGE while purging demand_group.


  2. Parent Table: COMMODITY

      - Child table missing: RECONCILIATION_METHOD
      - Purging process: purge_commodity
      - Error message: integrity constraint (AIP_Q10_SCH01.FK_RE_FOREIGN_KEY) violated - child record found returned by AIP_PURGE.EXECUTE_PURGE while purging commodity.

Changes

 

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