ESFO 9.0+: Duplicate Error Message (13000,88) When Adding New Rates Effective Date Row in Staffing Assignment (Doc ID 1544086.1)

Last updated on MARCH 16, 2016

Applies to:

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

Symptoms

ISSUE:

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 preventing the successful storage of the changes performed on the existing Assignment.

REPLICATION STEPS:

   - Log into the FSCM Online Application as User ID VP1
   - Navigate to: Set Up Financials/Supply Chain > Install > Installation Options
   - Click on the 'Products' link in the General Options section
   - Make sure that the following FSCM Modules are selected: Staffing Front Office, Pay/Bill Management, Resource management, Project Costing, and Contracts
   - Navigate to: Set Up Financials/Supply Chain > Product Related > Staffing > Orders > Contract Profile
   - Open for Business Unit US004, scroll to User Order Type STFTM, and set the Encumbrance % to 20
   - Navigate to: Set Up Financials/Supply Chain > Product Related > Staffing > Orders > Rate Profile
   - Open under Set ID SHARE, the existing Rate Profile ID NAHRLYEE, and make sure all configuration is properly done, with 6 Rate Elements listed
   - Navigate to: Set Up Financials/Supply Chain > Product Related > Staffing > Orders > Rate Elements
   - Add a new value under with the following settings:
        - Set ID SHARE
        - Rate Element = NAGCS
        - Description = GCS Week Day
        - Short Description = GCSWeekDay
        - Regular = Y
        - Rate Action = Pay and Bill
        - Regular Time Multiplier Factor = 1
        - NA Payroll Hourly Employee = Y
        - Global Payroll Employee = Y
   - Go to the Details tab, and enter the below new values:
        - Analysys Type = TLB
        - Time Reporting Code = HOUR1
        - Target Analysis Type = BIL
   - Navigate to: Staffing > Orders and Assignments > Add/Update Orders
   - Add a new Staffing Order with the below information:
        - Branch ID = CA001
        - User Order Type = STFTM
        - Description = GCS Order
        - Start Date = March 1st 2013
        - End Date = March 31st 2013
        - Order Status = Unfilled
        - Sales Operator = VP1
        - Department ID = 10500
        - Service Operator = VP2
        - Customer ID = 0000050035
        - Order Contact = 46
        - Customer Fields Definition = STAFF
        - Date Opened = March 1st 2013
        - Requisition Status = Unfilled
        - Job Code = 120000
        - Quantity Requested = 1
        - Internal Date = March 1st 2013
   - Save the changes
   - Go to the PeopleMatch tab
   - Enter Type EMPL, Candidate ID KUX135, and click on the Express Assignment icon
   - 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 15
        - Define a Target Margin of 25
        - Click on the Apply Rate button
        - Click on the Apply Margin button
   - Save the changes, in order to generate the new Assignment ID
   - Click OK on the Messate stating that the Order Line has been Filled
   - Note that at this stage, the Staffing Assignment has 6 Rates listed, one of them being PAY ONLY, which means that it should not be interfaced to Project Costing
   - Go to the Cross Reference tab, and click on the Contract Line available link
   - A new window will open, displaying the Contract Lines information
   - Click on the Detail tab
   - Click on the Contract Terms link
   - In the new Related Projects tab, click on the Rate Set link
   - See that there are a total of 5 Rates defined, not counting the one whose Rate Action is PAY ONLY. This is correct
   - Navigate to: Staffing > Orders and Assignments > Assignments
   - Open the Assignment ID we just created
   - In the Assignment Header tab, go to the Rates section, and perform the following tasks:
        - Click on the Correct History button at the bottom of the page
        - Proceed to delete the 1st rate row: Rate Element NHERG
        - Click OK on the Warning Message displayed
        - Click on the Insert Rate button
        - In the new row, define Rate Element NAGCS, with a Pay Rate of 17, and a Bill Rate of 25
        - Proceed to save all the changes
   - Query Record PS_PC_RATE_DTL and confirm that it is in sync with the values stored in PS_FO_ASGN_RT_DTL, leaving aside of course the PAY ONLY Rate row
   - Back at the Assignment Header tab, within the Rates section, click on the + icon to add a new Effective Dated row with the following values:
        - Effective Date = March 20th 2013
        - For the line containing Rate Element NAGCS, set the Pay Rate to 10
        - For the line containing Rate Element NAGCS, set the Bill Rate to 15
   - Proceed to save the changes performed
   - The system throws an Error Message at this stage

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

ERROR MESSAGE:

   " Duplicate source criteria not allowed. (13100,88)  Occurred during Rate Template creation. (18071,217) FO_UTILITIES.CI.CIHandler.OnExecute Name:errorHandler  PCPC:1908  Statement:44
     Called from:FO_UTILITIES.CI.CIHandler.OnExecute  Name:save  Statement:58
     Called from:FORS_ASSIGNMENTS.Handlers.TempHandler.OnExecute  Name:projRates  Statement:1278
     Called from:FORS_ASSIGNMENTS.Handlers.TempHandler.OnExecute  Name:backOffice  Statement:1356
     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. "

BUSINESS IMPACT:

The Error Message obtained prevents the user from saving the needed Rates changes, and therefore, incorrect Rate values will continue to be used as per a particular date when different values should be applied in Project Costing module. This will result in incorrect invoicing to customers in Billing.

EXPECTED BEHAVIOR:

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms