AIP Online: RETL_LOAD Procedure Import_profile Code Changed in 14.0 to Require Upper Case PROFILE_CODE in PROFILE Table

(Doc ID 2115375.1)

Last updated on MARCH 10, 2016

Applies to:

Oracle Retail Advanced Inventory Planning - Version 14.1 and later
Information in this document applies to any platform.


After upgrading from 13.1 to 14.1, the retl_load package import_profile procedure fails when it tries to insert into PROFILE table because the profile already exists. In the 13.1 environment, the profile_code was lower case, and in 14.x, the profile_code is converted to UPPER. This results in a duplicate record which causes the procedure to fail.


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