My Oracle Support Banner

Missing iSupplier Contact Records In Table Hz_party_usg_assignments and in Contact Directory page After 12.1.3 RPC 4 Patch 2123663 (Doc ID 2141698.1)

Last updated on DECEMBER 20, 2017

Applies to:

Oracle iSupplier Portal - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Other Issues

Supplier contacts that do not have FND user accounts are deleted after running script pos_rm_dupe_contacts.sql

Supplier contacts should not be deleted even if they do not have FND user accounts.

The issue can be reproduced at will with the following steps:
1. Apply <Patch:19176952>:R12.POS.B
2. Run script pos_rm_dupe_contacts.sql
3. User accounts are deleted from iSupplier contacts directory.
4. The same are available in iProcurement.
5. The root casue is missing records in table hz_party_usg_assignments.

The issue has the following business impact:
Due to this issue, users cannot find contacts in isupplier contacts page.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.