The latest available version of Bi Apps (OBIA) is 11.1.1.10.2 There is a nice note (including all the links) for the previous version: OBIA: Getting Started with an OBIA 11.1.1.10.1 Install and Upgrade (Doc ID 2065612.1) - I wasn't able to find the 11.1.1.10.2 equivalent. --> Here is the official 10.2 documentation:…

4089263 - If you have access to My Oracle Support, try this note: OBIA Master Note for Data Lineage Guides Documents (Doc ID 2276946.1). In particular, you may find OBIA 11g: BI Applications 11.1.1.10.x Data Lineage Guides (Doc ID 2058613.1) the most relevant to what you are seeking. Charles

Hi Manu, Did you have a chance to review that article/link I provided? Charles

Hi Manu - Try reviewing this: https://www.rittmanmead.com/blog/2012/03/obiee-11g-security-week-subject-area-catalog-and-functional-area-security-2/ . Also, I recall there being a bug/patch "related" this this kind of thing. Not sure if it will apply to you here, but check it out: Patch 22221772: NEW APPLICATION ROLE…

Can you check some other logs to see if there is any more details? Try bi_server1.log and AdminServer.log. They should be under: /{$MW_HOME}/user_projects/domains/bifoundation_domain/servers (if you're using 11g). BTW - You may want to add some system details ... OS, etc.? Regards, Charles

Hi Ben, I have not faced this particular issue. However, I have had some other issues with the agent, connections, etc. Take a look at the notes below ... maybe they will help out with this. OBIA 11g: How to Change BI Applications System Account Passwords (Doc ID 1613764.1) OBIA 11g oraclediagent Not Starting After Cloning…

Hi, Check the database alert log (or, have your DBA/team check). There should be some additional details there. Regards, Charles

Hi, Very important ... if you are doing customizations, there is a process to follow. Have you seen this document? https://docs.oracle.com/cd/E63231_01/doc/BIAET/GUID-C9E7D7FD-3C17-4247-962B-56DD9E8A2B6B.htm#BIASA24484 So, I'd suspect that the reason your code is not being reflected is because the scenario wasn't…

Sure. One other table that looks related is: W_GL_ACCOUNT_D. Here's the description of it: This dimension table stores your General Ledger accounts. In Oracle, this table stores the GL Code Combinations. The GROUP_ACCOUNT_NUM field categorizes GL accounts into various groups. This categorization denotes the nature of the…

Hi, This is definitely not my area of expertise. But, I see that there haven't been any responses here ... so I'll see if I can offer anything (perhaps, I will also learn something along the way ). I see a table named W_LEDGER_D in the Bi Apps data warehouse. It has the following description: Stores information about the…

Hi KashSidd, Those are file system objects, which reside on the application tier. Take a look at: OBIEE 12c: Quick Reference For Architecture, Lifecycle Management and File Locations (Doc ID 2067527.1) -- section: Where are the RPD and catalog located? Regards, Charles

Hi Christian, Just to round this one out ... I did get an answer from MOS on this. It is needed to use the older version of the bi admin tool, if merging between different versions. The new version of the tool does not recognize (is not compatible with) some older version objects. So, in this case, the 10.1 version was the…

Did you ever resolve this?

Have you already tried decompiling (into XML) and then recompiling the RPD on the command line?biserverxmlgen / biserverxmlexec ? Thanks, that could be helpful. I'm going to look into that.

Also, looking a bit closer at that note, I can see that it is super-old, 2011 (and archived). I think we can disregard it ...

Ok, good to know . Glad that is actually the case - I was hoping so! Then, maybe it is closer to my first posting?

Maybe it has to do with this: Can multiple versions of OBIEE Admin Tool coexist on the same Windows PC? (Doc ID 527984.1) I had installed mine in separate places, but maybe there was still some kind of conflict.

Ok. I think this may possibly have to do with the version of the BI admin tool. I didn't see that it was specified anywhere, so I used the new version of the BI Admin tool (ie taken from the 10.2 home page). I did that because that OBIEE patch (discussed above) said that we'd need to download the new client tools, after…

Ok, so I am trying to see if I can "outsmart" the RPD a little bit . Instead of trying the consistency check at the global level, I have been doing it at various sub-levels. What I am finding is that there are several errors at the top-level of the BMM ... in this case it is called 'Core'. But, still it works. However,…

Hi Christian, I patched OBIEE to 11.1.1.9.181016 during the OBIA upgrade. I think that is the highest at the 11.1.1.9 code line. Unfortunately, this is as high as we can go with Bi Apps ... without trying for an out-of-place 12c upgrade. Regards, Charles