Trigger SHIP_CONS_TRIP_UPD_VOLUME_BASE Is Not Updating PROMOTION_DATA Table Series VOLUME_BASE_TTL (Doc ID 2144203.1)

Last updated on JUNE 14, 2016

Applies to:

Oracle Demantra Predictive Trade Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

Trigger: SHIP_CONS_TRIP_UPD_VOLUME_BASE is not updating promotion_data volume_base_ttl

When you change the promotion ship dates of a shipment-based item-location combination, the volume_base_ttl in promotion_data is not getting updated. This causes the planned spend to be wrong.

EXPECTED BEHAVIOR

When you change the promotion ship dates of a shipment-based item-location combination, the volume_base_ttl in promotion_data should be getting updated.

STEPS TO REPRODUCE

1. Setup triggers and procedure for Consume vs Shipment Planning as per <Note 1630628.1>.
2. Open a Worksheet.
3. Change ship dates
4. Volume not updated.


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