-
After applying the OBIEE bundle stack patch 37468177 user are not able to login via EBS
Hi, We have a EBS environment which is connected to OBIEE. After applying the OBIEE bundle stack patch 37468177 user are not able to login using a cookie via EBS anymore. EBS has not been patched yet. Only OBIEE has been patched. Does anyone has a clue? I have changed the userId for security reasons and have renamed the ip…
-
Error in creating a trendline - OBIEE 12c
Hello, I have a problem with TRENDLINE in OBIEE 12c. I am trying to use a formula like this: TRENDLINE(100 - ((IFNULL(Sum(DISTINCT "XX"),0) / ("YY"*24.0)) * 100.0), ("TIME"."DAY_DATE"), 'LINEAR','VALUE') "XX" - type: double "YY" - type: double "TIME"."DAY_DATE" - type: date I get this error: State: HY000. Code: 42071.…
-
How to retrieve the BICC User Logs?
We need your guidance on how to retrieve BICC user logs, specifically logs that capture details of when a user has modified offerings or job schedules. Our objective is to track changes made to these configurations, including timestamps and user details, to ensure better monitoring and auditing. Could you please advise on…
-
OBIEE 12c Agent saving issue
Hello! In our OBIEE 12c environment, we’re encountering a warning when trying to edit an existing report agent. When we click the save button, it keeps spinning, and a dialog box appears with "Wait" or "Exit" options. If I hit "Wait," it just keeps waiting, and if I click "Exit," the changes are saved, but the OBIEE page…
-
Comparing 2 Parallel groups at RTF
I'm facing a challenge within an RTF template. I need to compare two groups of data. These groups are parallel, share a common parent, and may contain duplicate records. My goal is to identify and exclude records from the first group that also exist within the second group.
-
How to Popoluate Date Parameter in OTM- FTI DV as always current week/Month
We have created DV in FTI and also connected workbench using data actions and added in OTM , now users able to access but now we have below issues. How can we always systems should keep current week as Data parameter instead of static values selected When we select the Dates in why can them applied for the connecnected…
-
Is any method to reserve leading zeroes in excel template
Is any method to reserve leading zeroes in excel template. Here length for that field is different. Kindly help on this. I changed the field format to number to restrict scientific format. If anyone knows.Kindly help
-
AOR users are not able to view the results of LOGICAL SQL otbi report - getting No Results
Hi Experts, AOR users are not getting any results it says No Results the specified criteria didn't result any data etc.. Where as the persons who have BI Admin role are able to access the report, please suggest how to debug this. thanks in advance.. below subject areas are used: Recruiting - Recruiting Real Time, Workforce…
-
Essbase Administration Services connectivity to SnowFlake DB
Hi. We have a load rule that connects directly to Oracle Exadata to pull some information using Oracle Call Interface (OCI). But we are currently migrating from Exadata to SnowFlake. How could we connect Essbase Administration Services directly to Azure SnowFlake? OCI won't work because it is only for Oracle Database.
-
Unable to embed the OAC dashboard in Power BI using the iFrame format.
We are currently attempting to embed OAC Standalone reports into Power BI. As part of this process, I have configured the OAC environment to include Power BI as a safe domain. While trying to embed the OAC dashboard in Power BI using the iFrame format, we encountered the error: "Refused to connect." Interestingly, we were…
-
I need a query to split the salaried hours as 8 hrs/day from the state of earnings.
-
RTF Preview Failed: Why do I get "Preview Failed" when trying to preview an RTF?
I am unable to preview a RTF and receive the below error message when trying to do so. This problem has just occurred recently. I have attempted to reinstall BI Publisher as well as install different version of Java but that does not seem to fix the issue. I am unaware of any updates that would have caused this to break as…
-
Can you please let me know the table names for the below PVO's?
RSI GL Config Job TopModelAM.FinExtractAM.GlBiccExtractAM.CodeCombinationExtractPVO FscmTopModelAM.FinExtractAM.GlBiccExtractAM.FiscalPeriodExtractPVO FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalCategoryExtractPVO FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalSourceExtractPVO…
-
ODI Migration Issue
Hi, so I have inherited part of this issue from someone else's set up. Physical Oracle Architecture is not identical in Test and Production instances, so on using Smart Export I also have to manually change the physical name for the test environment to the Production equivalent and update the database physical connection…
-
How to confirm if email was successfully sent using BIP Bursting.
We are looking at possible options available in Oracle Fusion to confirm if the email was successfully sent to recipients using BIP Bursting. This is from an audit standpoint an evidence that could justify that the email went out successfully from Oracle.
-
Unable to choose multiple selection of values for a parameter in ESS job
We have a requirement where we need to select multiple values for a parameter in BI report. When we are trying to create a custom ESS job, we don't see an option to select multiple values from LOV at parameter level. Is there any option which we can use to select multiple options for a parameter from the ESS job. Thanks,…
-
Is it possible t secure catalog folders and grant access to it's content only to certain users/roles
We would like the ability to secure shared catalog folders to only allow certain users to access the reports in it. We are unable to secure OTBI reports by project type/business unit/project org etc. but have a need to share reports with internal teams and do not want end users to be able to access these.
-
ODI Error: Create view on source (LKM BIAPPS SQL to Oracle (Multi Transport))
Hi, I have moved one mapping from UAT to SIT environment in ODI. I regenerated the scenario and run the scenario. The mapping is failed for below error. I have done the normal export not the Smart export. Kindly suggest, Thanks, Lalit
-
Missing Party Number or Party ID field in the "Sales - CRM Contact Resource"
Hi Community, I am creating a report for the Contact object in CRM using the standard subject area "Sales - CRM Contact Resource." However, the standard fields for Party Number or Party ID, which are needed to redirect users to the Contact Redwood UI Edit page via deep link, are not available for the Contact object. Could…
-
BIApps on ODI Marketplace
Hi, As part of cloud migration strategy, we are planning to migrate our ODI Repository installed as part of BIApps to ODI Marketplace. We want to know if ODI Marketplace supports BIApps or should we install BIApps with ODI in a Virtual Machine. Regards, Shiva
-
Oracle Business Intelligence Applications 11.1.1.10.2 end of support
Where can I find end of support dates for the components of my installation of Business Intelligence application 11? these are my components: Oracle WebLogic Server 10.3.6 OBIEE 11.1.1.9 OBIA 11.1.1.10.2 ODI 11.1.1.9 OHS 11.1.1.9 I already know the dates for OBIA 11.1.1.10.2 end of extended support on 31/7/2022 ODI…
-
Add 'GL Account Hierarchy Level 1' in Project - Cost: GL Account folder
Hi, we use OAS 7.0, OBIA 7.6.4, EBS 12.2. The OOTB Project - Cost subject area has 'GL Account Number' and shows project cost (ex. a period, a project number and cost ) distributing in various accounts (when added to the analysis). We understand that the cost grain does not go any further(finer) for this segment in this…
-
Does any one know if OBIA (OBIEE & ODI) 11.1.1.10.3 PS4 supported & compatible with OEL 8?
Hello, Does any one know if OBIA (OBIEE & ODI) 11.1.1.10.3 PS4 supported & compatible with OEL 8? somehow i cannot find it in certification matrix. Thanks a lot!!
-
IEX:Collections XML Preview Data Source
How can I execute one of the templates stored under this concurrent program? IEX:Collections XML Preview Data Source
-
Oracle Language Pack does not working in custom RTF templates even it is installed?
Hello, Good Day! We are customizing the the template of a seeded template but when we re-upload the language pack doesn't work as it expected. Can anyone help me understand why this is happening in the custom templates. Thanks,
-
Oracle Analytics BICC vs BIP
From Oracle documentation I understand that BI Publisher (BIP) and BI Cloud Connector (BICC) is used for exporting bulk data from ERP Cloud I have used BIP in the past and am aware of the use cases. I am keen to know the use cases of BICC . E.g. why should one use BICC and not BIP ?
-
Joining Party Name from AP to GL Detail Transactions in FAW
Hi Experts. I am trying to put together a report that combines primarily data from 'Financials - GL Detail Transactions' such as account code combination, journal creation date, batch name, balances etc, but I need to also incorporate Party name for here the posting originated from AP. Looking at the AP Data sets (such as…
-
Hello Guys , Good Morning , Treat for you , New learning , ODI 12c 1.1.3... ,Source is Fusion 24c
ODI 12c (1.1.3.2) to fusion Catalogue data load Data load from PVO Files from UCM is loading to Fusion Catalogue but, from Catalogue to SDE data is not loading , Kindly guide us how to proceed with SDE data load, BICC, UCM - PVO's Scheduled and downloaded in Unix path./ReplStag BIACM - Load Plan for Supply chain management…
-
Not able to find Value Set, Lookups and Message tasks in Workforce Deployment
Not able to find Value Set, Lookups and Message tasks in Workforce Deployment from Setup and Maintenance. We have automated the migrations of Fast Formulas and User-Defined Tables using Rest API. To extend the automation of migrations, we are looking for Value Sets, Lookups and Message tasks in Workforce Deployment from…
-
ODI Upgrade to 12c for OBIApps
Hi Good Morning. ODI Upgrade to 12c apply TO_CHAR(DATE) results in DD/MMM/YY instead of DD-MMM-YY TO_CHAR(SQ_KK_ACTIVITY_LOG.KK_TRAN_DT)||'~'|| Problem Description (ODI/OBIapps) on premise for peoplesoft --------------------------------------------------- When executing a Scenario in ODI 12.2.1.4 , the TO_CHAR(DATE).…
