My Oracle Support Banner

Fail To Convert To Internal Representation Error While Doing Advanced Search When Clicking on Format Button Adding BOM.Page Two MultiList Attribute on Displayed Field (Doc ID 2608740.1)

Last updated on MARCH 15, 2020

Applies to:

Oracle Agile Product Collaboration - Version and later
Information in this document applies to any platform.


After running Advanced Search on Document object, clicking on Format button
and add BOM.Page Two MultiList attribute on Displayed Field returns below error.

This issue occurs even after applying from Bug:29922296

Fail to convert to internal representation

For 9.3.6 below error will be displayed :
ORA-00960: ambiguous column naming in select list

The issue can be reproduced at will with the following steps:
1. Login to Java Client as admin
2. Go to Data Settings - Classes - Documents. In User Interface Tab go to BOM tab and go to Attributes: BOM tab
3. Enable a new PAGE_TWO.MULTILIST01 attribute. Name : Item P2 MultiList01
   Make it Visible.
4. Enable a new PAGE_TWO.MULTILIST02 attribute. Name : Item P2 MultiList02
   Make it Visible.
5. Go to Data Settings - Classes - Documents. In User Interface Tab go to
   Page Two tab and go to Attributes : Page Two tab
6. Enable MultiList01 and MultiList02. Set a new List to each list.
7. Login in Web Client as admin user
5. Create a new Document : D00003 and add value to below Page Two attribute.
   Item P2 MultiList01
   Item P2 MultiList02
6. Go to BOM tab and add new Document : D00004
7. Perform Save As and create new Document D00005 from D00003
8. Go to Advanced Search and perform below search

Items : Document : Where-used One Level Latest Released Revision Only
Name/Number/Desc : Contains Phrase : D

9. Press Format and go to Format tab
10. Add

Item P2 MultiList01 (BOM)
Item P2 MultiList02 (BOM)

and Apply




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

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