Promotion ID That Contains Characters Can't Be Associated To An Allocation (Doc ID 2198755.1)

Last updated on OCTOBER 30, 2016

Applies to:

Oracle Retail Allocation - Version 15.0 to 15.0.2 [Release 15.0]
Information in this document applies to any platform.

Symptoms

Problem Description

When creating a Standard or What If Allocation, a Promotion with characters cannot be associated to an allocation.

Internal error occurred when an Allocation is created and Saved or Calculated.  The Promotion ID that is being saved in the ALC_ALLOC table cannot be a character (needs to be a number). The system is trying to save the RPM_PROMO.PROMO_DISPLAY_ID in the Allocation promotion id (which is a number). RPM_PROMO.PROMO_DISPLAY_ID is a VARCHAR so accepts both number and characters. When a number is used on the PROMO_DISPLAY_ID it works fine.  But if a character is used it gives "Internal Error"

Steps to Reproduce

1. Create an Allocation
2. Select any Item
3. Add locations
4. Select Policy
5. On the "Context" field select 'Promotion'
6. On the promotion field select a promotion with promo id that has characters (PROMO_DISPLAY_ID from RPM_PROMO has characters)
7. Select 'Save' button to save allocation
8. 'Internal error' is displayed

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