12c Data Issue

User_2NI9B

Hi All.

We are experiencing this weird behavior on our 12c (12.2.1.2.0 (Build BIPS-20160923092103 64-bit)) environments.

There is an analysis with a pivot table that has a prompt with only two values (for example YES and NO, YES being default). Now, when the the analysis is run, the results are incorrect with the prompt value YES.

When we change the prompt value from YES to NO, results are correct for NO. Now, once we change back from NO to YES, results are correct. So, essentially, when the analysis is run, first set of results are wrong. But changing the prompts produces correct results.

An example to make more sense-

First run (wrong results):-

Prompt changed (correct results):-

Prompt is changed back to initial value (correct results, at last):-

Source is TImesTen. On 11g there is no issue. Both 11g and 12c have same model and both have common TimesTen source.

Anyone any idea? Thanks.

Gianni Ceresa

Hi,

Did you looked at the generated queries in the 3 cases and compared them? First the logical one and then the physical one?

Did you manage correctly the default value in your analysis for when the prompt isn't set?

Is your cache on or off?

Joel

Just to add to @Gianni Ceresaresponse above, I'd check the query log files to check whether the filters are being correctly set for each of the scenarios.

[Deleted User]

24506898

One-off patch. You're welcome. Next question.

User_2NI9B

Thanks a lot Christian. Not sure if we have the same problem as I could not read the complete bug description. Sounds pretty similar though.

Requested Bug could not be displayed. Possible reasons are:

• The bug id was entered incorrectly. Please check and try again.
• The bug id does not exist (was referenced incorrectly).
• The bug is not classified as publicly accessible ("non-public").
• The content is being updated and it is temporarily unavailable but will be made available again soon.

If you still have questions about why you could not access this article or bug, please use Contact Us.

Should I create an SR to know more?

[Deleted User]

It's pretty certainly that bug. Never saw anything else cause this in 12. Just download the patch and patch one of your environment's. It's 700KB and costs you exactly one shutdown, one opatch apply, one startup.

And a rollback is easily done.

User_2NI9B

Hi,

We tried to apply the patch, but it complains that a more recent patch has already been updated.

Any suggestion? Thanks

[Deleted User]

Err what patch did you install? One of the BPs?