EGO_ITEM_PUB - Item Templates Not Applied Creating Items Via API

(Doc ID 1308125.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Product Catalog - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.
EGOPITMB.pls : EGO_ITEM_PUB
EGOVBUAB.pls: EGO_USER_ATTRS_BULK_PVT

Symptoms

Product Information Management (PIM/EGO) Item templates are not applied when creating items via API: EGO_ITEM_PUB.Apply_Templ_User_Attrs_To_Item. The API returns 'S' (Successful) message, but the template User Defined Attributes (UDAs) are not applied.

Expected Behavior
Expect the items created via API to take the default UDAs from the template.

What was tried
The issue continues even after patching like from the following note:
<Note 1119093.1> - Item Template Values Do Not Override MTL_SYSTEM_ITEMS_B Using API And Web-Adi

What is working
When creating items manually using a specific ICC and a specific default item template (supplemented with UDA attributes) through standard PIM item creation in forms (framework HTML forms) it works as expected.

Steps: Not working
1. Create item via API.
* Calling API EGO_ITEM_PUB.process_items. See <Note 728350.1> for an example.
2. The item template is not applied.

Steps: What is working
1. Development Manager > Item Catalog > Create Production Items
2. Select ICC
3. It will automatically provide the correct default item template for ICC.
4. Create item.
5. The template correctly applies to the item.

Business Impact
Developer would have to hard code every single UDA individually that has a translatable independent value set configured with the attribute.

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