AIP Online: RETL_LOAD Procedure Import_profile Code Changed in 14.0 to Require Upper Case PROFILE_CODE in PROFILE Table
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
Million Knowledge Articles and hundreds of Community platforms