My Oracle Support Banner

Synchronize Supplier Contact Concurrent Request Creates An Extra Space in JTF_RS_RESOURCE_EXTNS Table (Doc ID 1533409.1)

Last updated on FEBRUARY 06, 2022

Applies to:

Oracle Common Applications - Version to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.


On : and R12 version, Resources Module (JRES)

Orders are failing due to sync program. We ran the synchronize supplier contact standard oracle program and that created an extra space in jtf_rs_resource_extns.
The program updated the SOURCE_NAME field in JTF_RS_RESOURCE_EXTNS, and also updated the JTF_RS_SALEREP name and that in turn updated the RESOURCE_NAME in JTF_RS_RESOURCE_EXTNS_TL table.

The issue is we ran the "Synchronize Supplier Contacts" program and it has overwritten all the Supplier Resources, and added spaces to all the Supplier Contact resources in the JTF_RS_RESOURCE_EXTNS_TL table. If you look at the code, it adds spaces to separate the names mainly to take into consideration "Middle"name, but if you look at the po VENDOR contacts tables, there's No Middle name, so not sure why its there in the program. If you do standard import of Supplier contacts into JTF_RS_RESOURCE_EXTNS, there is no space, so the program is not following what the standard CRM import process is doing. We have external Sales order Import and OIC Payment process that rely on the Resource Name for mapping purposes. So this Synchronize Supplier Contacts program looks to have a disconnect in standard import process. Even the Synchronize Employees program doesn't add any spaces to CRM resources.

The issue has the following business impact:
Due to this issue, Orders are failing due to the names being incorrect


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

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