My Oracle Support Banner

User Cannot Access VMI In Collaborative Planning After Creating Personalization (Doc ID 2291240.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Collaborative Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Qn1:

After setting up a personalization to sort results in the VMI screen - the user encounters and error when trying to access the page.

How can we get the details on the error and then diagnose the issue?

Qn2:

How can the user recover from the error to continue working?


Qn3:

Now that we have debug information - what does this mean and how can we fix this?

Debug information shows

Error Page

You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.
About Previous Page


Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT MSCXvmirEO.PLAN_ID,
  MSCXvmirEO.SR_INSTANCE_ID,
  MSCXvmirEO.CUSTOMER_ID,
  MSCXvmirEO.CUSTOMER_SITE_ID,
  MSCXvmirEO.CUSTOMER_NAME,
  MSCXvmirEO.CUSTOMER_SITE_NAME,
  MSCXvmirEO.SUPPLIER_ID,
  MSCXvmirEO.SUPPLIER_SITE_ID,
  MSCXvmirEO.SUPPLIER_NAME,
  MSCXvmirEO.SUPPLIER_SITE_NAME,
  MSCXvmirEO.INVENTORY_ITEM_ID,
  MSCXvmirEO.ITEM_NAME,
  MSCXvmirEO.DESCRIPTION,
  MSCXvmirEO.ORDER_DETAILS,
  MSCXvmirEO.PLANNER_CODE,
  MSCXvmirEO.VMI_TYPE,
  to_char(MSCXvmirEO.ORGANIZATION_ID),
  to_char(MSCXvmirEO.APS_SUPPLIER_ID),
  to_char(MSCXvmirEO.APS_SUPPLIER_SITE_ID),
  to_char(MSCXvmirEO.APS_CUSTOMER_ID),
  to_char(MSCXvmirEO.APS_CUSTOMER_SITE_ID),
  MSCXvmirEO.BUYER_CODE
  FROM MSC_SUP_DEM_ENTRIES_VMI_V MSCXvmirEO) QRSLT WHERE ((customer_id = sys_context('MSC', 'COMPANY_ID') or supplier_id = sys_context('MSC', 'COMPANY_ID') )) ORDER BY VIEW_ATTR ASC
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
.....
## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00904: "VIEW_ATTR": invalid identifier

  
 

Solution

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
Goal
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.