Unable To Open Installation Details At Line Level From Sales Order HTML (Doc ID 2721546.1)

Last updated on MAY 18, 2021

Applies to:

Symptoms

On : 12.2.8 version, Transaction Entry

When attempting to  open Installation Details at line level actions from Sales Order HTML UI
An error message is displayed.

ERROR
-----------------------
Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during
statement preparation. Statement: SELECT TxnLineEO.ATTRIBUTE1,
  TxnLineEO.ATTRIBUTE10,
  TxnLineEO.ATTRIBUTE11,
  TxnLineEO.ATTRIBUTE12,
  TxnLineEO.ATTRIBUTE13,
  TxnLineEO.ATTRIBUTE14,
  TxnLineEO.ATTRIBUTE15,
  TxnLineEO.ATTRIBUTE2,
  TxnLineEO.ATTRIBUTE3,
  TxnLineEO.ATTRIBUTE4,
  TxnLineEO.ATTRIBUTE5,
  TxnLineEO.ATTRIBUTE6,
  TxnLineEO.ATTRIBUTE7,
  TxnLineEO.ATTRIBUTE8,
  TxnLineEO.ATTRIBUTE9,
  TxnLineEO.CONFIG_SESSION_HDR_ID,
  TxnLineEO.CONFIG_SESSION_ITEM_ID,
  TxnLineEO.CONFIG_SESSION_REV_NUM,
  TxnLineEO.CONFIG_VALID_STATUS,
  TxnLineEO.CONTEXT,
  TxnLineEO.CREATED_BY,
  TxnLineEO.CREATION_DATE,
  TxnLineEO.ERROR_CODE,
  TxnLineEO.ERROR_EXPLANATION,
  TxnLineEO.LAST_UPDATED_BY,
  TxnLineEO.LAST_UPDATE_DATE,
  TxnLineEO.LAST_UPDATE_LOGIN,
  TxnLineEO.MIGRATED_FLAG,
  TxnLineEO.OBJECT_VERSION_NUMBER,
  TxnLineEO.PROCESSING_STATUS,
  TxnLineEO.SECURITY_GROUP_ID,
  TxnLineEO.SOURCE_TRANSACTION_ID,
  TxnLineEO.SOURCE_TRANSACTION_STATUS,
  TxnLineEO.SOURCE_TRANSACTION_TABLE,
  TxnLineEO.SOURCE_TRANSACTION_TYPE_ID,
  TxnLineEO.SOURCE_TXN_HEADER_ID,
  TxnLineEO.TRANSACTION_LINE_ID
  FROM CSI_T_TRANSACTION_LINES TxnLineEO
 where TxnLineEO.source_transaction_type_id = :1
  and TxnLineEO.source_transaction_id = :2
  and TxnLineEO.source_transaction_table = 'OE_ORDER_LINES_ALL'
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:661) at
oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283) at
oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:150



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log Into Order management HTML responsibility.
2. Open any Sales Order in Entered/Booked status. Ensure Item line details are entered. Now try to select a line and try to open "Installation Details" from the LOV. Click on Go.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot view Installation details form Sales Order HTML UI.

Changes

Cause

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