WebADI: Error ORA-00918 Column Ambiguously Defined When Creating Items From Excel And Applying Template With User-Defined Attributes

(Doc ID 2208082.1)

Last updated on APRIL 17, 2017

Applies to:

Oracle Product Hub - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

When you try to create items using WebADI, records are getting populated in Open Interface and the program completes with warning message. No details are available in program log/error tables.
For each record, PROCESS_FLAG in MTL_SYSTEM_ITEMS_INTERFACE is 1 and in EGO_ITM_USR_ATTR_INTRFC PROCESS_FLAG is 2.

Program log provides below message-

ERROR

STEPS

The issue can be reproduced at will with the following steps:
1. Development manager > Import Items > Import from Excel
2. Download webADI for the ICC and upload it back into system
3. Create items using WebADI

WHAT IS WORKING

You can create items from the front-end UI without any errors.

Changes

 <None>

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