My Oracle Support Banner

Receive Error In IProcurement When Changing Need-By-Date Default Date To An Earlier Date (Doc ID 2548865.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle iProcurement - Version 12.2.7 and later
Information in this document applies to any platform.


On iProcurement, 12.2.7 version, Requisition Creation

Receive Error in iProcurement When Approver Changing Need-By-Date Default Date to an Earlier Date. The preparer can change teh Need-By-Date without issue.

The application has been upgraded from 12.1.3 to 12.2.7. Recently after the upgrade, it was discovered that Users in the Production environment receive an error when creating/submitting a Requisition in iProcurement if the default Need-by-Date is changed to an earlier date.

Example: Create Requisition in iProcurement on 04-JAN-2019. Need-by-Date defaults as 09-JAN-2019. Update Need-by-Date to 05-JAN-2019.
Receive the following error: "The Line 1 Need-By-Date defaults to 09-JAN-2019. You are changing to an earlier date".

The only way to get past the error is to either:

1) Change Need-by-Date back to defaulted date (09-JAN-2019).
2) Change Need-by-Date to a date AFTER the defaulted date (ex. 10-JAN-2019).

Issue has been researched on Metalink and found Document:

2485658.1 Cannot Complete Change Request Due To Need-By Date Error - The Line 1 Need-By-Date defaults to [date]. You are changing to an earlier date.

There is a bug/patch associate to this Doc ID and patch p28990732_R12.ICX.D_R12_SOLARIS64 has been applied to our Test instance.

After the application of the Patch, there is no change to the current functionality (still receiving the error).

Please advise.


The Line 1 Need-By-Date defaults to 09-JAN-2019. You are changing to an earlier date

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

1. Log into iProcurement
2. Begin creating a requisition
3. Attempt to change the need-by date to an earlier date than the defaulted date but still a future date from the date of req creation




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.