'Refresh other parameters on change' of Menu Type Parameter in BIP Datamodel Doesn't Work Appropriately If It Depends on Other Invisible Parameter.
(Doc ID 3042750.1)
Last updated on SEPTEMBER 13, 2024
Applies to:
Oracle Fusion Financials Common Module Cloud Service - Version 11.13.24.04.0 and laterInformation in this document applies to any platform.
Symptoms
On : 11.13.24.04.0 version, Custom Reports and Analytics
A BIP datamodel has three parameters for example.
- Parameter_A (menu type / Refresh other parameters on change / visible)
- Parameter_B (menu type / Refresh other parameters on change / invisible)
- Parameter_C (menu type / Refresh other parameters on change / invisible)
LOV of Parameter_B is using Parameter_A as follows.
----
select col1 from XXXX
where col2 = : Parameter_A
----
LOV of Parameter_C is using Prameter_B as follows.
----
select col1 from YYYY
where col2 = : Parameter_B
----
And SQL of a Dataset using Parameter_C as follows.
----
select * from ZZZZ
where col3 = Parameter_C
----
We expect that a right value for Parameter_C is refreshed and set by selecting a value from Parameter_A.
However, when Parameter_B & Parameter_C are invisible as above, Parameter_C is not refreshed appropriately.
Because of the problem, the Dataset doesn't return an expected value.
When Parameter_B & Parameter_C are visible, these parameters works and the Dataset returns an expected value.
Changes
There is no change.
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 |