My Oracle Support Banner

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 FEBRUARY 25, 2019

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

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
Symptoms
Changes
Cause
Solution
References


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