My Oracle Support Banner

FAQ: How to Add New Fields/Columns That Are Not Previously Available to Upload/Download Template? (Doc ID 2760777.1)

Last updated on MARCH 18, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.0 and later
Information in this document applies to any platform.

Purpose

 This article talks about customization of Upload/Download templates

Questions and Answers

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
Purpose
Questions and Answers
 Need additional fields to be added that are not currently part of the base templates to leverage base Upload/Download templates to create specifically required templates by function.

For example, to leverage the ITEM_MASTER_DATA template to support Mass Item UDA Changes, the new template (created from the ITEM_MASTER_DATA template) 'TD_ITEM_UDA_UPDATE' includes the following worksheets:

- ITEM_MASTER
- UDA_ITEM_LOV
- UDA_ITEM_FF
- UDA_ITEM_DATE

You want to add fields/columns not currently available within the ITEM_MASTER_DATA template.

Consider the UDA_ITEM_LOV worksheet (included yet modified as part of my new 'TD_ITEM_UDA_UPDATE template). There are the following fields/columns:

- ACTION
- ITEM
- UDA (numeric value only -> no description)
- UDA Value (as above)
- New UDA Value (as above)

You want to add a description field for the UDA, UDA Value, and New UDA Value columns. The description fields should be drop-downs, displaying the actual description of the value entered. Assume UDA 25 = Season. You want the new UDA Description field to show 'Season.' Upon selecting Season, the UDA column would auto-fill 25 in the UDA column.

The same logic would need to apply to the remaining UDA fields/columns in the worksheet.

How to add new fields/columns that are not previously available to a template?
 Given that the drop-down selection lists for UDA LOVs are not possible, how can you add additional fields?


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