Synchronize Supplier Contact Concurrent Request Creates An Extra Space in JTF_RS_RESOURCE_EXTNS Table
Last updated on MARCH 08, 2017
Applies to:Oracle Common Applications - Version 126.96.36.199 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
On : 188.8.131.52 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms