RESALIB Compilation Fails Due to Presence of Special Characters Such As Hyphen (-) or Dot (.) On Code Column of CODE_DETAIL Table (Doc ID 1638695.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.0.6 to 13.0.7 [Release 13.0]
Oracle Retail Merchandising System - Version 14.0.1 to 14.0.4 [Release 14.0]
Information in this document applies to any platform.

Symptoms


RESALIB Compilation fails while executing make-command with below error when Code field Of CODE_DETAIL includes a (-) character even though CODE is a VARCHAR2(6) field.

Error
-----------------------

 Steps to Reproduce
-----------------------
The issue can be reproduced at will with the following steps:

1. Add a CODE with a (-) character, say OI-001.
2. Execute make-command for RESALIB.MK file.
3. Notice the error.

What is Working
-----------------------
If you do not include the (.) character such as 050 the compilation runs successfully.

 

 

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