Unable To Open Installation Details At Line Level From Sales Order HTML
(Doc ID 2721546.1)
Last updated on NOVEMBER 01, 2020
Applies to:
Oracle Order Management - Version 12.2.8 and laterOracle Installed Base - Version 12.2.8 and later
Information in this document applies to any platform.
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
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
Symptoms |
Changes |
Cause |
Solution |
References |