E1: 45: Search Agent Maintenance (P45510) Displays Duplicate Records For Search Agent (Doc ID 2882175.1)

Last updated on JULY 08, 2022

Applies to:

Symptoms

Search Agent Maintenance (P45510) displays duplicate records for Search Agent Name “37611” and Table Name “F4072”:

• EXDJ (Expired Date) is listed three times, with two of the three entries identical
• AST (Price Adjustment Type) is listed three times, with two of the three entries identical

Perform a SQL Query on the Search Agent Directives Detail (F45511) table for Search Agent 371611.

• There is one record for EXDJ
• There is one record for AST.
• There are no duplicates for Search Agent 371611 in the Search Agent Directives Detail (F45511) table.

Steps to duplicate:

1. From the Advanced Pricing menus select Pricing Mas Maint – Update Mode
2. In Pricing Mass Maintenance (P45550) populate the Search Agent Name “37611”. The Table Name “F4072” is automatically populated.
3. Take the Form Exit to SA Properties
4. Search Agent 371611 for table F4072 displays two sets of duplicate field names
   1. EXDJ (Expired Date) is listed three times, with two of the three entries identical
   2. AST (Price Adjustment Type) is listed three times, with two of the three entries identical
5. Perform a SQL Query on the Search Agent Directives Detail (F45511) table for Search Agent 371611.
   1. There is one record for EXDJ
   2. There is one record for AST.
   3. There are no duplicates for Search Agent 371611 in the Search Agent Directives Detail (F45511) table.

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.