Getting Error While Trying To Search Quotes with UpdatedBy field added in Quotes Dashboard Screen
Last updated on JUNE 16, 2017
Applies to:Oracle Quoting - Version 12.2.5 and later
Information in this document applies to any platform.
On : 12.2.5 version, HTML User Interface
Getting error while trying to add UpdatedBy on Quotes Dashboard Screen
When trying to add Updated By column on Quotes Dashboard page via Personalization the page gives an error to the Quoting User
The QotQuoteSearchPG page gives this error.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement:
SELECT AQHA.QUOTE_HEADER_ID as QuoteHeaderId , nvl(AQHA.QUOTE_NAME,'----------') as QuoteName , AQHA.QUOTE_NUMBER as QuoteNumber , AQHA.CUST_PARTY_ID as CustomerPartyId , AQHA.CUST_ACCOUNT_ID as CustAccountId , AQHA.QUOTE_STATUS_ID as QuoteStatusId , AQHA.QUOTE_EXPIRATION_DATE as ExpirationDate , AQHA.TOTAL_QUOTE_PRICE as Amount , AQHA.ORDER_ID as OrderId , AQHA.ASSISTANCE_REQUESTED as AssistFlag , AQHA.ASSISTANCE_REASON_CODE as AssistRsnCode , AQHA.CREATION_DATE as CreationDate , AQHA.ORDER_TYPE_ID as OrderTypeId , AQHA.PRICE_LIST_ID as PriceListId , AQHA.RESOURCE_ID as ResourceId , AQHA.RESOURCE_GRP_ID as ResourceGroupId , AQHA.SALES_CHANNEL_CODE as SalesChannelCode , AQHA.MARKETING_SOURCE_CODE_ID as SourceCodeId , AQHA.LAST_UPDATE_DATE as UpdateDate , AQHA.PUBLISH_FLAG as WebPublished , AQHA.QUOTE_VERSION as VersionNumber , AQHA.ORG_ID as OrgId , null as OpportunityName , null as OpportunityNumber , null as OpportunityId , HPOBJ.PARTY_NAME as CustomerName , null as AccountNumber , null as ContactName , null as ContactPartyId , null as PartyRelnId , null as PartyRelnType , AQST.MEANING as QuoteStatus , null as QuoteStatusCode , null as Agreement , null as AgreementId , null as AssistanceReason , null as AssistanceRequested , null as CreatedBy , null as OrderType , null as PriceList , null as PrimarySalesperson , null as PrimarySalesGroup , null as SalesChannel , null as SourceName , FUUP.USER_NAME as UpdatedBy , null as OrderColSwitcher , null as CurrencyName , null as OperatingUnit , AQHA.CURRENCY_CODE as CurrencyCode , AQHA.PARTY_ID as PartyId FROM ASO_QUOTE_HEADERS AQHA, FND_USER FUCR , HZ_PARTIES HPOBJ , ASO_QUOTE_STATUSES_TL AQST WHERE AQHA.MAX_VERSION_FLAG = 'Y' AND AQHA.RESOURCE_ID IS NOT NULL AND AQHA.CUST_PARTY_ID = HPOBJ.PARTY_ID AND AQHA.QUOTE_STATUS_ID = AQST.QUOTE_STATUS_ID AND AQST.LANGUAGE = USERENV('LANG') AND AQHA.QUOTE_STATUS_ID IN ( :1, :2, :3) AND FUCR.USER_ID = AQHA.CREATED_BY AND NVL(AQHA.QUOTE_TYPE, 'Q') = 'Q'Order By UpdateDate DESC
The issue can be reproduced at will with the following steps:
1. Setup the Personalization for the UpdatedBy field in Quote Search
2. Login as the Quoting User responsibility
3. Try to search quote, get error in search page.
The issue has the following business impact:
Due to this issue, users cannot search quotes and use this field as a search criteria.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms