My Oracle Support Banner

The Salesperson Number cannot be changed using the ResourceService due to an error. (Doc ID 2480770.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.13.18.05.0 and later
Information in this document applies to any platform.

Symptoms

The wrong Salesperson Number was entered on a resource. The Salesperson record is deleted from the Resource with the Salesperson Number unchanged and the To Date left null. This creates an inactive Salesperson record with no end date.

As a result, a new Salesperson record for the same Salesperson Number cannot be created due to an error.

The Salesperson Number cannot be changed using the ResourceService due to an error.

ERROR
-----------------------
A resource with the salesperson number {SALESPERSON_NUMBER} already exists. (HZ-120238)
Attribute SalesrepNumber in ResourceSalesrepEO is required.

JBO-27023: Failed to validate all rows in a transaction.JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000007475804 ] in ResourceSalesrepEOJBO-27004: Attribute set for SalesrepNumber in entity ResourceSalesrepEO failed

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Sales Cloud
2. Navigate to Resource Directory
3. Search and Edit resource
4. Add a new record with Salesperson Number
5. Click Save button
6. The first error occurs
7. Use Resource Service: https:///foundationResources/SalesPersonService?wsdl
a. findResourceSalesrep operation to find the ResourceSalesrepId:
<soapenv:Body>
<typ:findResourceSalesrep>
<typ:findCriteria>
<typ1:fetchStart>0</typ1:fetchStart>
<typ1:fetchSize>-1</typ1:fetchSize>
<typ1:filter>
<typ1:group>
<typ1:item>
<typ1:upperCaseCompare>false</typ1:upperCaseCompare>
<typ1:attribute>SalesrepNumber</typ1:attribute>
<typ1:operator>=</typ1:operator>
<typ1:value>9999</typ1:value>
</typ1:item>
</typ1:group>
</typ1:filter>
</typ:findCriteria>
<typ:findControl>
<typ1:retrieveAllTranslations>false</typ1:retrieveAllTranslations>
</typ:findControl>
</typ:findResourceSalesrep>
</soapenv:Body>

b. updateResourceSalesrep operation to update SalesrepNumber
<soap:Body>
<ns1:updateResourceSalesrep xmlns:ns1="http://xmlns.oracle.com/apps/cdm/foundation/resources/resourceService/applicationModule/types/">
<ns1:resourceSalesrep1 xmlns:ns2="http://xmlns.oracle.com/apps/cdm/foundation/resources/resourceService/">
<ns2:ResourceSalesrepId>999999999999999</ns2:ResourceSalesrepId>
<ns2:SalesrepNumber>99999</ns2:SalesrepNumber>
<ns2:SetId>999999999999999</ns2:SetId>
</ns1:resourceSalesrep1>
</ns1:updateResourceSalesrep>
</soap:Body>

8. The second error occurs.
<env:Body>
<env:Fault>
<faultcode>env:Server</faultcode>
<faultstring>JBO-27023: Failed to validate all rows in a transaction.JBO-27024: Failed to validate a row with key oracle.jbo.Key[999999999999999] in ResourceSalesrepEOJBO-27004: Attribute set for SalesrepNumber in entity ResourceSalesrepEO failed</faultstring>
<detail>
<tns:ServiceErrorMessage xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<tns:code>27023</tns:code>
<tns:message>JBO-27023: Failed to validate all rows in a transaction.</tns:message>
<tns:severity>SEVERITY_ERROR</tns:severity>
<tns:detail xsi:type="tns:ServiceRowValErrorMessage">
<tns:code>27024</tns:code>
<tns:message>JBO-27024: Failed to validate a row with key oracle.jbo.Key[999999999999999] in ResourceSalesrepEO</tns:message>
<tns:severity>SEVERITY_ERROR</tns:severity>
<tns:detail xsi:type="tns:ServiceAttrValErrorMessage">
<tns:code>27004</tns:code>
<tns:message>JBO-27004: Attribute set for SalesrepNumber in entity ResourceSalesrepEO failed</tns:message>
<tns:severity>SEVERITY_ERROR</tns:severity>
<tns:exceptionClassName>oracle.jbo.ReadOnlyAttrException</tns:exceptionClassName>
<tns:attributeName>SalesrepNumber</tns:attributeName>
<tns:objectName>ResourceSalesrepEO</tns:objectName>
</tns:detail>
<tns:exceptionClassName>oracle.jbo.RowValException</tns:exceptionClassName>
<tns:objectName>ResourceSalesrepEO</tns:objectName>
</tns:detail>
<tns:exceptionClassName>oracle.jbo.TxnValException</tns:exceptionClassName>
</tns:ServiceErrorMessage>
</detail>
</env:Fault>
</env:Body>

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the Salesperpson cannot be recreated with a Salesperson Number that was previously deleted.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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