System is not allowing to insert Documents of record for same document type and document number but with different valid from and valid to dates (Doc ID 2367813.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

System is not allowing to insert Documents of record for same document type and document number but with different valid from and valid to dates,
when old record has expired and trying to enter new records and want to keep the history of old record.

Facing below error.

ERROR
-----------------------
The &TYPE valid between &DATE_FROM and &DATE_TO already exists.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility :Employee Self service > Documents of Record
2. While trying to create a Document of Record for same Document type and Document Number , but with different Valid From and Valid To dates.
  Facing the error "The &TYPE valid between &DATE_FROM and &DATE_TO already exists."

Changes

Cause

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