My Oracle Support Banner

ESFO 9.2: 'Duplicate Source Criteria Not Allowed (13100,88)' Error Message Taking Place at a Staffing Assignment Level When Multiple Effective Date Rates Have Been Defined (Doc ID 2984929.1)

Last updated on JANUARY 11, 2024

Applies to:

PeopleSoft Enterprise FIN Staffing Front Office - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms


When trying to add a new Effective Dated row in the Rates section from a Staffing Assignment (Page FO_ASGN_HDR, Component FO_ASSIGNMENTS), the system throws a 'Duplicate source criteria not allowed' Error Message (13100,88) preventing the successful storage of the changes performed on the existing Assignment.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as User ID VP1
    2.- Navigate to: Set Up Financials/Supply Chain > Install > Installation Options
    3.- Click on the 'Products' link in the General Options section
    4.- Make sure that the following FSCM Modules are selected: Staffing Front Office, Pay/Bill Management, Resource Management, Project Costing, and Contracts
    5.- Navigate to: Staffing > Orders and Assignments > Add/Update Orders
    6.- Add a new Staffing Order with the below information on the Order tab
           - Branch ID = CA001
           - User Order Type = STFTM
           - Description = Test Effective Date Rates
           - Start Date = March 1st 2023
           - Estimated End Date = December 31st 2023
           - Order Status = Unfilled
           - Sales Operator = VP1
           - Department ID = 10500
           - Customer ID = 0000050037
           - Location = 1
           - Order Contact = 0037
    7.- Go to the Resource Request tab, and fill in the below values:
           - Date Opened = March 1st 2013
           - Requisition Status = Unfilled
           - Job Code = 110000
           - Quantity Requested = 10
           - Start Date = March 1st 2023
           - Estimated End Date = December 31st 2023
    8.- Save the changes
    9.- Go to the PeopleMatch tab
    10.- Enter Type Employee, select Candidate ID 0000000001, and save the changes
    11.- Click on the Express Assignment icon
    12.- At the new Assignment Header tab, go to the Rates section, and perform the following tasks:
           - Click on the Pay Rate radio-button
           - Define a Default Rate of 60
           - Click on 'Apply Rate' button
           - Click on the Bill Rate radio-button
           - Define a Default Rate of 75
           - Click on 'Apply Rate' button
    13.- Click on the + icon to add a new Effective Date row on the Rates section
    14.- Ensure that the Effective Date is defaulted to today's date
    15.- Follow the below actions on the second Effective Date Rates row:
           - Click on the Pay Rate radio-button
           - Define a Default Rate of 80
           - Click on 'Apply Rate' button
           - Click on the Bill Rate radio-button
           - Define a Default Rate of 95
           - Click on 'Apply Rate' button
    16.- Click YES on the Message asking about the margin (18071,293)
    17.- Go to the Initial Payroll Setup tab
    18.- Define the values on the below 2 required Fields:
           - Workgroup = KUWRKPROJ
           - Taskgroup = KUTSKPROJ
    19.- Go back into the Assignment Header tab, and click on SAVE button
    20.- PROBLEM: The system throws an Error Message

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the problem.

ERROR MESSAGE:

    " Duplicate source criteria not allowed. (13100,88)  Occurred during Rate Template creation. (18071,217) FO_UTILITIES.CI.CIHandler.OnExecute  Name:errorHandler  PCPC:1940  Statement:44

      Called from:FO_UTILITIES.CI.CIHandler.OnExecute  Name:save  Statement:58

      Called from:FORS_ASSIGNMENTS.Handlers.TempHandler.OnExecute  Name:projRates  Statement:1308

      Called from:FORS_ASSIGNMENTS.Handlers.TempHandler.OnExecute  Name:backOffice  Statement:1386

      Called from:FORS_ASSIGNMENTS.Handlers.FOHandler.OnExecute  Name:Ass

      An error has occurred in the Component Interface called above.  Please make sure that the project, contract, and rate profiles have been set up correctly. "


The Error Message obtained prevents the user from saving the needed Rates changes, and therefore, the Assignment cannot be completed. This will affect any sub-sequent integrations needed to the Project Costing module, and potentially result in delayed invoicing to customers in Billing.

The system should allow the option to have multiple Effective Date Rate values, and properly interface them to the Project Costing and Contracts modules.

NOTE: In the images/screenshots/examples mentioned and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

 

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
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.