When Using SOAP Web Service Calls To Create Projects and Update Cost Codes, Duplicate Objects Are Intermittently Created (Doc ID 2926535.1)

Last updated on FEBRUARY 10, 2023

Applies to:

Symptoms

When performing SOAP web service calls to create Projects and update Project Cost Codes, occasionally duplicate objects are being created inadvertently. It is believed that there is a delay in web service responses from Unifier that is possibly causing this issue. In the case of project creation, the client sends a "getShelllist" to confirm the shell doesn't exist, then "createBPRecord" for the shell creation BP to create a shell. Then the next call is sent to confirm that the shell is now on the list and a new creation request is sent. But this is resulting duplicate Shells on occasion. As a workaround the duplicates for now are being renamed and set to Inactive.

There have also been duplicate Project cost codes created in a project. The problem is that some actions cannot be performed in that project because of the duplicate cost codes, they cannot delete the duplicates or update them.


EXPECTED BEHAVIOR
----------------------------
Unifier should not allow the creation of duplicate Projects or Cost Codes via SOAP web services..


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Configure the SOAP client to send the needed web service calls to create Projects, Business Process (BP) records and update Project Cost Codes
2. After the web service calls are completed, Navigate to Company Workspace > Admin Mode > Company Sponsored Shells > Project > Find Contract Number the newly create project "Proj12345"> Note that there are multiple projects with the same name.
3. Navigate to Project where duplicate cost codes have been created > User Mode > Cost Sheet > Open Project Cost Sheet > Find the newly created cost code. Note that there are 2 duplicates with this same Cost code.

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.