-
BI Publisher Migration From 11g To 12c Fails With Error: Pre-action setup failed: Could not determin
I was trying to migrate BIP 11g to 12c using the bi-migration-tool.jar script. COMMAND ---------- C:\Java\jdk1.7.0_80\bin\java -jar bi-migration-tool.jar out C:\Oracle\BIP\Oracle_BI1 C:\Oracle\BIP\user_projects\domains\bip_domain C:\Oracle\BIP\user_projects\domains\bip_domain\tmp\migration-tool-test\export.jar ERROR…
-
obiee analytics page 500 Error
Hi I recently applied patches on OBIEE 11.1.1.9.191015 patch and had to roll back for some reason. Since this activity I am not able to get the 'analytics' page. I get 500 , Internal server error. All the deployments have started fine and they are in Active mode. These are the logs I could gather and find errors in…
-
Why dynamic content do not print at the beginning of the working body ?
Hello everybody, I'm using Oracle Bi Publisher 11G for rendering some reports. I have a report that is very dynamic and that can show or hide many section, if we got any data. My problem is that the last 2 sections, when they are alone do not start at the beginning of the body zone. I can't share the data, but here some…
-
Question related to BUG 16188769 and Patch 16188769 for W_GL_SEGMENT_D.
Looking for assistance on more details as to the fix applied for This issue was identified as a product defect BUG 16188769 EFFECTIVE_FROM_DT CHANGES IN FND_FLEX_VALUES CAUSES ISSUE IN W_GL_SEGMENT_D. As per the instructions and "Patch_16188769_Technote" , it appears changes to "SDE_ORA_GLSegmentDimension.XML" but the…
-
Unable to bring up the DAC server in 11g
When am trying to bring up the DAC server in 11g, throws below error. 'Encryption key in authentication file doesn't match the repository. Please use the correct authentication file to connect.' I referred the document - DAC 11g / OBIA 7.9.6.4: Encryption Key In Authentication File Doesn't Match The Repository. (Doc ID…
-
Where is "Available to Reserve" fact located in BI
Could you kindly advice where in BI is "Available to Reserve" fact located in? So far none of the following facts and dimensions display the result: 1) Subject Area: Distributed Order Orchestration - Fulfillment Lines Real Time -> Dimension folder: Fulfillment Lines - General -> Reserved Quantity 2) Subject Area:…
-
How can i change the SIL_DayDimension end date value without setting w_day_d = null
Hi All, I need to change the Parameter $$END_DATE value of SIL_DayDimension to 31-12-2030 without doing a full load to W_day_d table Is this possible to achieve without setting W_DAY_D Refresh dates to null. Any help much appreciated Thanks P
-
How to convert RPD file to XML file (OBIEE 12C)?
Hello everyone, We have installed Oracle Business Intelligence 2.2.1.2.0 on our server. We downloaded the RPD file from the instance. Now, we want to convert RPD file to XML file. Can anyone please let me know the steps to do the same? Thank you. Kind regards, Arpit
-
Oracle DAC is taking 4 hrs to start running the first task
Hi The nightly ETL is running for longer hours, when we investigated the logs, we found that the first task / ETL is actually starting after 4 hrs. Ex: Execution plan scheduled to start @ 12:00 AM where as the first task starting @ 4:27 AM which is leading to load delay. If we restart Database service, DAC service and…
-
How to download RPD file from Oracle Business Intelligence 12C?
Hello everyone, We have installed Oracle Business Intelligence 2.2.1.2.0 on our server. We need to download the RPD file from the instance. Can anyone please help us with some link or steps regarding the same? If anyone has the solution, please help as this is a very high priority for us. Thank you. Regards, Arpit
-
Error in BI Configuration
Hello Guys, I'm facing an issue while configuring Oracle Business Intelligence 12c (ver 12.2.1.4.0). I'm stuck with this issue and not able to complete the configuration. I have also attached a screenshot of the error. Kindly help...
-
Oracle BI and TimeZone
Hi All, I'm looking for change the TimeZone in Oracle Business Intelligence 11.1.1.7.140527. I don't know if it's on Websphere Server or if it's on application OraBI. Thanks for your reply and happy new year !!! Regards.
-
How to add a customized font to the font dropdown list on column property in oracle biee 11.1.1.9.
Hi, guys, Our customer want to add a local customized font to report. We want to make it chooseable on the font dropdown list of column property where creating an analysis. We are using oracle biee 11.1.1.9.0 What is the steps of customizing? Please help! Thank you!
-
How to start with OBIEE reports!
Hi , I'm new to OBIEE reports and not able to find the proper way to look for respective ERP field in OBIEE presentation layer/Subject Area. Can anyone guide me on how to analyze the Subject Area and its field. and how to find the field in presentation layer for the ERP field We are using: ODI 11g ERP 12.1.3 Regards, Rinki
-
Unable to DAC server build Dac Build AN 11.1.1.6.4.20121119.202
Hi Folks, i am trying to start DAC server in windows by executing startserver.bat file however i am getting below error. Windos cannot find '-server'. Make sure you typed the name correct and then try again. attached is the screen dump . Thanks
-
How to setup Data level security based on user login
HI , Can anyone please help in setting up data level security. The user who logged in , they should be able to view only data related to them. I have setup this by adding user in console and assigned role in em. Created initialization block when i test it with user input i am getting only user related data. Then again i…
-
Defining security in OBIEE 11g
HI In OBIEE 11g, I am trying to setup security for few of people where they should able to see only one particular subject area and catalog related to that. For This, i have create group and added users to that group using OBIEE console.and create as application role and added group to that role in EM. Can anyone please…
-
Flash deprecation and OBIA 11.1.1.8
We're still on OBIA 11.1.1.8 which uses OBIEE 11.1.1.7. With the upcoming deprecation of flash, we need to do something quick. We meant to upgrade the whole system to OIBA 11.1.1.10.2, but something got in the way. Now we don't have time to do the major upgrade before Flash is gone, but we need to do something to keep…
-
OBIEE Install Error
I installed OBIEE 12c Configuration Assistant and it finished the B Configuration portion. But I received an Error under BI Startup: "Configure BI Failed with Execution of [/u01/app/Middleware/Oracle_Home/user_projects/domains/bi1/bitools/bin/start.sh] failed with exit value 3" When, I try to run ./start.sh from the…
-
Unable to get a system user connection to BI Server
Hi, I was busy setting up OBIEE and EBS Integration as per doc: https://docs.oracle.com/middleware/11119/biee/BIEIT/ebs_actions.htm. Got to step 10 and after when I tried to login into Analytics, getting error: [2019-08-15T13:07:05.000+02:00] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid:…
-
OBIA 7.9.6.4 not certified with EBS 12.2.7
I see from the certification matrix that OBIA 7.9.6.4 is not certified with EBS 12.2.7 (although it is with 12.2.6 & 12.2.8). We have been told Oracle ran out of time to complete the testing on 12.2.7, but is anyone aware of any problems that mean it could not be certified? Alternatively is anyone running 7.9.6.4 with…
-
OBIEE 12c and HDP3.1 Hive integration
Hello Experts, I don't know if I'm posting this Discussion as it should, if not sorry for that , and I'm sorry in advance for my ignorance as I'm not an OBIEE user. anyway, I'm running into a situation that I need to integrate between OBIEE 12c and HDP 3.1-Hive- so that I can access the data located in Hive and process it,…
-
Obiee
Hello All, Please i tried to edit my my organisation balance score care as admin and i get this error: Unable to edit/view: Error outside of Presentation Catalog occurred. Please how do i go about it. I have restarted BI services but the error still coming up. Thanks.
-
OBIEE
Hello All, Please I want to know if it possible to sum up Grand Totals that is 70 and 190 in OBIEE Analysis as indicated below: Thanks. Header 4Header 5Header 6asdf2090asdf50100Grand Total70190
-
OBIA / ODI 11 - ODI Agent won't start in Admin Console
Hi team, I am facing an error when i'm trying to start oraclediagent deployment coming with OBIA Here the error message that i have : <Sep 2, 2019 5:05:25 PM EDT> <Error> <Deployer> <BEA-149231> <Unable to set the activation state to true for the application 'oraclediagent'. weblogic.application.ModuleException:…
-
ODI-1232: Procedure Parse SQL execution fails - Data Lineage load issue
I found one instance of this error and the stated solution was to regenerate the OBIEE extract files which we did. We ran the Data Lineage load plan early this morning and it ran the SQL Parser step (6) correctly, but failed on the Dashboard source (step 8) - which at the time we had the dashboard extract from an incorrect…
-
Adding step to X_CUSTOM Load Plan Component
Hi all, We have a number of steps in OBIA 11g that we want to include in the X_CUSTOM dim and fact groups. In total we have steps to add to 3 SDE Dims X_CUSTOM_DIM EBS_12_1_3 3 SDE Fact X_CUSTOM_DIM EBS_12_1_3 3 SIL Dims X_CUSTOM_DIM 3 SIL Fact X_CUSTOM_DIM All of the relevant target tables are in the correct model folder…
-
BI Apps Dev/Tst/Prd migration plan
We are in the process of migrating BI APPS 9 to 11.1.1.10.2 which was installed and configured using the silent install. The silent install produced a Master Repository and a Work Repository using the same DB schema. The work repository is a design repository. DEV11_ prefix. Following the same logic when installing the TST…
-
Informatica 10.2 hf2 suported Jdk version
Hello Everyone, Could you please let me know which version jdk is required for informatica 10.2 hf2 (DAC), certification its mentioned jdk1.8 but when i was spoke with oracle support they were strictly mentioned jdk 1.6 needs to use for informatica. Could you please let me know which version of Jdk is ok, in the same…
-
OBIEE Direct Database request not working
Hi, I am getting the following error when I execute a Direct Database Request: I have given proper permissions under: Administration/Manage Privileges but to no avail, Any ideas? BTW, It works fine when I login as Administrator Version: OBIEE 12.2.1.3
