Whats the best way to create USER variable in BI Apps?
I have just installled BI Apps and am trying to integrate EBS R12 with OBIEE 11g
We have USER variable already defined in the BI Apps rpd.
In EBS Security context init block i need to define USER variable, but when i define it... it says *'USER' has already been defined in the variable "Authentication"."USER"*
Whats the best way to create USER variable for EBS Security Context init block?
1) Delete the existing USER variable and then define a new one ( in this case all the places where USER variable is getting used in the rpd would become <missing>)
And i was told that it should not be done.
Let me know how can it be done.
Thanks
Ashish