WebADI: Error ORA-00918 Column Ambiguously Defined When Creating Items From Excel And Applying Template With User-Defined Attributes
Last updated on APRIL 17, 2017
Applies to:Oracle Product Hub - Version 220.127.116.11 and later
Information in this document applies to any platform.
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-
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms