My Oracle Support Banner

API(HR_ORGANIZATION_API.UPDATE_ORG_MANAGER) Fails with ORA-01841 Error (Doc ID 2921348.1)

Last updated on JANUARY 15, 2023

Applies to:

Oracle Human Resources - Version 12.2 HRMS RUP15 and later
Information in this document applies to any platform.


Problem Statement:

When attempting to end date the Organization Manager Details using the API(HR_ORGANIZATION_API.UPDATE_ORG_MANAGER), the following error occurs.

Error:ORA-01841: (full) year must be between -4713 and +9999, and not be 0



Steps to Reproduce:
The issue can be reproduced at will with the following steps:

  1.  Execute the API

    API script snippet:

  2. API fails with the error.


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

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