My Oracle Support Banner

Data Mismatch For "Details" Column in agile.PROGRAM_HISTORY Table When Compared to Agile User Interface "History" Tab (Doc ID 2916844.1)

Last updated on DECEMBER 21, 2022

Applies to:

Oracle Agile Product Portfolio Management - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

The data in the Agile User Interface (UI) "History" tab doesn't match with "DETAILS" column returned by "agile.PROGRAM_HISTORY" table.

Steps to replicate the issue:

  1. Log into Agile Web Client.
  2. Search and open an Agile object.
  3. Look at history tab in Agile object.
  4. Run SQL Plus. 
  5. Connect to the Agile Database used.
  6. Run the command: "select * from agile.PROGRAM_HISTORY where OBJ_ID=<OBJECT_NUMBER>;"
  7. Compare the values from step 3 to the ones stored in Agile.PROGRAM_HISTORY table under "DETAILS".
  8. Notice they are not matching.

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