Promotion ID That Contains Characters Can't Be Associated To An Allocation
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.
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
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