There Is A One Day Discrepancy In The Effective And Expiration Dates In The Contract Repository when queried
(Doc ID 2506651.1)
Last updated on JULY 14, 2020
Applies to:Oracle Procurement Contracts - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Contracts Repository
Querying the Repository contract shows the Effective and Expiration dates one day prior to what was entered. But the data in the table OKC_REP_CONTRACTS_ALL is correct.
The issue can be reproduced at will with the following steps:
1. (R) Contracts Workbench Administrator
Contracts --> Contracts
2. From Recent Contracts region, open any contract that has an expiration date.
Note down the Effective and Expiration dates.
Click on Update or query the database and the dates is one day higher.
Note: Values in the table are fine. You can run this query to confirm.
select CONTRACT_EFFECTIVE_DATE, CONTRACT_EXPIRATION_DATE from OKC_REP_CONTRACTS_ALL where contract_number = '<your contract number>';
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