Oracle Transactional Business Intelligence

Popular Tags
- OTBI 870
- Reporting 811
- Analysis and Data Visualization 603
- Analysis 555
- Administration 493
- BI Publisher 452
- obiee 276
- reports 266
- Analyses 235
- Developers 219
- BI Publisher Data Models 203
- Oracle Fusion Analytics 182
- Data Connectivity 176
- Data Modelling and Datasets 151
- OBI Answers 147
- FAW 129
- security 126
- Packaging and Licensing 124
- Agents 122
- Report Output 120
- Home and Catalog 115
- ERP Analytics Content 105
- Access and Manage Data 98
- OBIEE Answers 96
- HCM 94
Oracle Transactional Business Intelligence
Discussion List
-
In BI Report we getting dupicate recordsHI Team, we have exist interview status report but few days onwords we getting dupliacte reocrds nearly 700plus. how can shorted out the issue ? Thanks, Ajay
-
Migrate Dashboards with Images from one instance to anotherHi Experts, We have created a dashboard with seeded available Images. However when we migrate that dashboard from one instance(where it was developed) to another, the im…
-
Unable to extract current date from current_timestamp for the local timezone in OTBIHi, I have a requirement to report current day sales value. I am trying to leverage CURRENT_TIMESTAMP function as it gives me my local time. But when I try to extract da…
-
How to merge different rows in a single row.I am trying to create one report based on Revenue generated and actual cost, so I am fetching revenue amount and cost for that particular project number, getting the cor…
-
Dependent parameters are not showing LOV'S when new custom ESS job created by copying standard ESSHi All, We have made customizations to the standard report and are currently attempting to create a new custom ESS job by duplicating the standard ESS job. The functiona…
-
Migrate the OTBI dashboard and associated/linked dashboard prompts and analysesis there a way to migrate the OTBI dashboard and associated/linked dashboard prompts and analyses to another folder without relinking all the dashboard prompts and analy…
-
Voucher Number is not getting populated for Invoices in OTBI Subject areaHi Team, We tried to create OTBI report using Payables Invoice- transaction real time subject area. And, we are noticing that the data for Voucher number is not populati…
-
How to enable BIP tables for BICCC extractionWe required a database table equivalent PVO in BICCC. The AP_INCOME_TAX_REGIONS table, we are trying to extract from the BICCC. We didn't find any equivalent PVO for thi…
-
Sales by Month , quarter and week in Oracle fusion order ManagementWe would like to know if it is possible to build OTBI report which shows monthly , weekly and quarterly sales. where time related attribute month , week , quarter should…
-
OTBI data model thought (BI Publisher) web service errorWe are trying to fetch the data displayed in an OTBI data model through an web service for further integrations. We use BI Publisher web services -> ReportServicesSoapBi…
-
Is there any Subject Area or table which will give the Task detail associated to each privilegeWe have a requirement to document the privileges which gives access to each task. Is there any Subject Area or Table which will help us get this information? To be accur…
-
UNABLE TO FIND RELEVANT SUBJECT AREA OR ORGANIZATION AND IT'S SITESHI Everyone, We were trying to make an interactive OTBI report containing the Address and it's Organization (Customer Data management module) but are unable to find the …
-
w ehave OTBi Report skills and certfications but it showing unparallely ?HI Team, We have report facing this is how can sorted . How it looks in the report How we need it to look like:
-
OTBI Spend Analysis - how to link dashboard prompt to graph promptHi All, I am new to OTBI and am trying to create a dashboard to allow users to analyse spend by product category. My business has set up a hierarchy with 2 levels. The r…
-
How to create a report containing past, current and future approvers of purchase requisitions?Summary: I would like to create a report with the summarized version of Purchase Requisition's Action Detail that contains all the stages and participants/approvers from…
-
Custom Dashboard is not available to all users.Hi All, Thank you in advance for your help and support. Kindly note the following, I have created custom reports and added them to a dashboard and saved it in the Shared…
-
How to get all fields of Payable Invoice in Sql of OTBIHi All, How to get all fields of payable invoice - header, line and taxes in one report in column format ? Is anybody having such sql ready then please share ? Thanks.
-
-
Content paging is limited to 500 - (a) how to default (b) how to increase max rowsEnvironment: 23A HCM > Oracle Fusion Workforce Development For high volume data the current content paging default is not acceptable. The requirement is for: (a) Custom …
-
have 2 sqls that work correct if run individually but UNION of the 2 causes issuesselect papf.person_number, ppnf.list_name employeename, pee.effective_start_date accru_startdt, peev.effective_end_date accru_end_dt, peev.screen_entry_value hrs_to_accr…
-
Date Requisition was put in the current phaseI am looking to create a report that will allow me to see when the requisition was put in the current phase. Any insights would be highly appreciated
-
Home Address changes - Data model/SQLHello, I've worked on a report that includes the employee's former address and current (new) address when a change has been entered in HCM. My SQL skills are kind of cru…
-
BI Scheduled Report Job and Daylight Savings TimeSummary We had a scheduled that ran an hour early after daylight savings time ended Content There is a scheduled report job that runs at 5:30am each wednesday. With dayl…
-
product group for BI adminHi, What should be the product group for creating service request for BI Admin? We have an issue with printers and trying to create a ticket. TIA
-
How to limit the data in an OTBI Purchasing report depending on the person.I am creating a dashboard for Procurement (requests and orders). However, it is a requirement from the client that the owners can only visualize their own requests/order…
-
Selecting the latest Order revisionSummary Need to retrieve the latest Orders revisions Content Hi, While creating an Analysis to retrieve the Sales Orders details we need to show only the latest revision…
-
Issue when entering OTBICustomer user is trying to enter OTBI using Tools > Reports and Analytics. However, when it hits at Browse Catalog button, following error is throwed: This is happening …
-
Report LogContent Anyone have an xml they would be willing to share or recommendations for creating a 'master' report that returns a list of all the BI reports in order to audit a…
-
Where can we find list of BICC Public View Objects (PVO) for all releasesHi All, Can you help us with the documentation where the list of PVOs are provided for BICC. Thanks,
-
I need an exception report to employees who have more than one of the same matrix manager.We currently have a multiple matrix manager exception report in our reporting catalogue but I don't think this is working correctly. The manager hierarchy process has re…