Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Cannot create a record in Position details (HcmPositionDetail). Insert not supported with the values specified for 'Effective' and 'Expiration'. New record overlaps with multiple existing records.

(0) ShareShare
ReportReport
Posted on by 5

Hi Everyone,

I am getting the below error while creating worker with the position.

Cannot create a record in Position details (HcmPositionDetail). Insert not supported with the values specified for 

'Effective' and 'Expiration'. New record overlaps with multiple existing records.

I am not getting the point in this error, as i am new to HRM module(Functionality), request you all to tell me why i am getting this error or let me know what wrong i was doing while selecting the Position and its dates.

Thanks in Advance..

Best regards,

Nanda Kishore.V 

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot create a record in Position details (HcmPositionDetail). Insert not supported with the values specified for 'Effective' and 'Expiration'. New record overlaps with multiple existing records.

    I suggest you should review following link to understand how to create Worker position

    technet.microsoft.com/.../hh242914.aspx

    Appreciated if you please update us with your findings

  • Suggested answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 46,612 User Group Leader on at
    RE: Cannot create a record in Position details (HcmPositionDetail). Insert not supported with the values specified for 'Effective' and 'Expiration'. New record overlaps with multiple existing records.

    each position has a duration.

    suppose there a position 'Human Resource Manager'

    This position may have a duration from JAN-1-2010 to DEC-31-2013.

    now if you try to add a new position within same positionId, it must not overlap exiting duration.

    By overlapping it can be as under for example

    if I selected same postionId and duration as May-1-2010 to FEB-18-2013 its is overlapping as JAN-1-2010 comes within range.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans