My Oracle Support Banner

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.

Symptoms

On : 12.1.3 version, Contracts Repository

ACTUAL BEHAVIOR
---------------
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.


STEPS
-----------------------
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>';

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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