My Oracle Support Banner

Quote Search Page Err OAF PERSONALIZATION FOR QUOTE SEARCH UPDATEDBY GIVES ORA-00904:FUUP.USER_NAME (Doc ID 2537844.1)

Last updated on JULY 29, 2019

Applies to:

Oracle Quoting - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, HTML User Interface


After displaying the 'Updated By' and 'Created By' fields in the Quote Search results using personalization,
  incorrect results are displayed.

The 'Created By' and 'Updated By' fields are displaying the same value even though the values are different.
The 'Updated By' is incorrect.  



EXPECTED BEHAVIOR
-----------------------
Expect updated by and created by to display different values when different values exist at the table level.

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. From Functional Administrator:
  Find Document name -
/oracle/apps/qot/quote/savedsearch/webui/QotSearchQueryRN


2. Create 2 items on 'Select to collapseTable: Quote Search Resu...' with the following values:
  (1)
  Item Style: Message Styled Text
        ID: xxCreatedBy
  Prompt: Created By
  Rendered: true
  View Attribute: CreatedBy
  View Instance: QuoteSearchVO

  (2)
  Item Style: Message Styled Text
        ID: xxUpdatedBy
  Prompt: Updated By
  Rendered: true
  View Attribute: UpdatedBy
  View Instance: QuoteSearchVO

3. View the result for a quote that was created by 1 user and updated by another user.
 Instead of showing different values, both fields are showing the same user.

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