My Oracle Support Banner

Size Profile RETL Integration Does Not Load Style Level Entries (Doc ID 2437969.1)

Last updated on APRIL 11, 2022

Applies to:

Oracle Retail Allocation - Version 14.0.4 and later
Information in this document applies to any platform.


Problem Summary

Size Profile RETL Integration Does Not Load Style Level Entries

When providing a style level size profile request the RETL integration does not upload file. In order to request a style level profile, the style is entered into the file with a NULL value for color. The RETL validation is looking in ITEM_MASTER for transaction level items with a NULL color. The NULL in the RETL file means it is for all colors and not items with a NULL color.

We are unable to maintain size profiles at style level. The validation should be changed to match items with any color when a NULL color is provided in file.

Steps to Reproduce

1. Create RETL Size Profile file containing style level size profiles with style populated and color not populated
2. Execute RETL Size Profile integration
3. Style level records not added to ALC_SIZE_PROFILE


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.