9492324 --Sort By Series Does Not Sort In Descending Order, And Not Saving The Sort Definition ORA-02291: integrity constraint (Doc ID 1096613.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Demantra Predictive Trade Planning - Version 7.3.0 and later
Information in this document applies to any platform.

Symptoms

In v7.3.0

PROBLEM
-------------
If a user sorts a worksheet by a series, saves the worksheet, closes the worksheet and re-opens it, the sort order does not get saved. Worksheet is displayed in the default sort order. Also, user is only able to sort the worksheet in ascending order of a series, and not in descending order.

STEPS
--------
1. Open worksheet
2. Sort by a series
3. Save worksheet
4. Close worksheet
5. Reopen worksheet

Other Symptoms also observed:

1) Reset Table Sort doesn't work (only re-running the worksheet resets the table sort)

2) Errors observed in the Collaborator.log when attempting to save the Worksheet after sorting the table similar to:

ORA-02291: integrity constraint (XXX.WS_VIEWS_SORT_SERIES_ID_FK) violated - parent key not found



 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms