DQM Is Enabled And Data Is Staged However Still Not Able To Query Customer Using Customer Account Number (Doc ID 1273929.1)

Last updated on OCTOBER 13, 2022

Applies to:

Symptoms

Not able to search for a few accounts by account_number . 
We see the data is in the hz_staged_parties table 

HZ: Enable DQM Party Search = YES
HZ: Match Rule for Organization Simple Search is set to HZ_ORG_SIMPLE_SEARCH
HZ: Match Rule for Advanced Simple Search is set to HZ_ORG_ADVANCED_SEARCH

Login to Receivables Manager
The simple and advanced search page is displayed

Search for Account Number 79410 - no results are seen.


Example Party:

Find the account 79410 (Verizon Wireless) - run and upload the following

select * from hz_staged_parties where party_id = 1880219


PARTY_ID STATUS TX1 TX2 TX3 TX4 TX5 TX6 TX7 TX8 TX9 TX10 TX11 TX12 TX13 TX14 TX15 TX16 TX17 TX18 TX19 TX20 TX21 TX22 TX23 TX24 TX25 TX26 TX27 TX28 TX29 TX30 TX31 TX32 TX33 TX34 TX35 TX36 TX37 TX38 TX39 TX40 TX41 TX42 TX43 TX44 TX45 TX46 TX47 TX48 TX49 TX50 TX51 TX52 TX53 TX54 TX55 TX56 TX57 TX58 TX59 TX60 TX61 TX62 TX63 TX64 TX65 TX66 TX67 TX68 TX69 TX70 TX71 TX72 TX73 TX74 TX75 TX76 TX77 TX78 TX79 TX80 TX81 TX82 TX83 TX84 TX85 TX86 TX87 TX88 TX89 TX90 TX91 TX92 TX93 TX94 TX95 TX96 TX97 TX98 TX99 TX100 TX101 TX102 TX103 TX104 TX105 TX106 TX107 TX108 TX109 TX110 TX111 TX112 TX113 TX114 TX115 TX116 TX117 TX118 TX119 TX120 TX121 TX122 TX123 TX124 TX125 TX126 TX127 TX128 TX129 TX130 TX131 TX132 TX133 TX134 TX135 TX136 TX137 TX138 TX139 TX140 TX141 TX142 TX143 TX144 1880219 A #VERIZON WIRELESS INC# VRZN WRLS VERIZON WIRELESS V625 VERIZON WIRELESS VRZN WRLS 180425 79410 ORGANIZATION VERIZON WIRELESS VERIZON 01 VERIZON WIRELESS VERIZON01 VRZN WRLS VRZN 01 VRZN WRLS VRZN01 VERIZON WIRELESS VRZN WRLS

TX35 show 79410
D_PS D_CT D_CPT
SYNC SYNC SYNC


This customer has over 200 accounts sites.
 If they add additional search criteria - The results return

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.