Fusion OTBI - On CRM POD the Items Page Overview Section - OTBI Err OPR4ONWY NQSError 27047 Non Existent Table: PIM-Item

(Doc ID 1996843.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Sales Catalog Cloud Service - Version and later
Oracle Fusion Application Toolkit Cloud Service - Version and later
Oracle Fusion Application Toolkit - Version and later
Information in this document applies to any platform.


Fusion CRM 11.1.8 Cloud - CRM Admin can see PIM Item in the Items screen but not in analysis

1. Connect to Answers and attempt to create an analysis

Result:  not able to find PIM Subject area, but earlier it was available

2.  use the Items Page > Items Tab which contains 2 analyses

eg an active approved  item "21011" of Root Item Class

Items page > Overview section > Items tab

    shows list of Item Class data
    Summary element contains 2 analyses which have ODBC errors

OPR4ONWY   nQSError 27047 Non existent table:  PIM-Item

I noticed that you have a CRM POD but this question seems to be about PIM which is Supply Chain.

Notes: another place that this occurs is in the fuse UI/simplified UI, when clicking on the "Analytics" icon and then searching for "Items" . If the user clicks on Item Summary or Rejected Item Summary, they get the same error


1. user can see the Item data on the normal Fusion screen
2. unable to find the Product Manager role in their CRM instance
3. Seeded implemn user supplied with POD does not have the Product Manager Role
4. They do not have a separate Security Administrator, they use CRM Admin for all security role admin tasks


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