Trigger SHIP_CONS_TRIP_UPD_VOLUME_BASE Is Not Updating PROMOTION_DATA Table Series VOLUME_BASE_TTL
Last updated on DECEMBER 18, 2017
Applies to:Oracle Demantra Predictive Trade Planning - Version 12.2.4 and later
Information in this document applies to any platform.
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms