Popular Tags
- OTBI 1,439
- Reporting 1,388
- FDI 1,101
- Analysis and Data Visualization 982
- BI Publisher 850
- Analysis 678
- Oracle Fusion Analytics 581
- Administration 555
- OAC 441
- OBIEE 433
- Analytics 400
- BI Publisher Data Models 353
- Security 292
- Answers 264
- HCM 262
- BIP 260
- Analyses 255
- Developers 244
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 189
- Report Output 184
- Fusion Data Intelligence 167
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Core HR
Discussion List
-
BPEL_FAULT-JBO-29000: Unexpected exception caught: oracle.jbo.JboExceptionwhile changing employee Personal Information: Phone Details,Demographic Info,national identifiers we are getting above error -
Employee contract extension errorHi team, originally employee contract type as OpenEndedContract, then when we try to add new contract record effective today and remove contract end date, click on ok co…
-
OTBI anlysis results from diemensions withinn the same subject area aren't matchingWe have a specific report that retrives the person demographic information. We are referring to the "Workforce Management – Person Real Time" under which the information…Anusha B S 1 view 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
Get current and future termination EE records in OTBIHi, We are trying to build a demographic file that should pull the data of EEs as of system date and also future terminations in next 7 days. I have tried using the pref…LeelaV 12 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
How can we add date parameters through advance SQL in OTBI?Hi All, We have a custom OTBI report that in which we want to add some date prompts, Can anyone guide me how to add date prompt from advance sql? How we refer parameter …Sushant95-Oracle 116 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Oracle Transactional Business Intelligence
-
How to pass parameters through agents in OTBI?Hi All, We created a fully customized OTBI report to fetch balance details, all the customization is done through advance sql/XML, the report is running fine manually, b…Sushant95-Oracle 285 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Oracle Transactional Business Intelligence
-
Which FAW table stores indirect Reportees data?I am looking for a table/column in FAW that stores the data for indirect reportees of a manager. dwc_manager_dn_dh_tbl table stores the data for direct reportees only (i…Dinky Dudeja 61 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Oracle Fusion Data Intelligence -
Usage of PVOs GLOBALPERSONPVOVIEWALL and PERSONDETAILSPVOVIEWALLWe are building a BICC extract to extract person and their assignment data, wanted to understand when should we use GLOBALPERSONPVOVIEWALL and PERSONDETAILSPVOVIEWALSR_CC 131 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
1How to update the service date field with a new custom name in the format of the date.Hi, How to set up a new custom field name in the service date area using the date format. Please find the reference image Thanks in advance Regards Bhargav PrasadBhargav Prasad 11 views 0 comments 1 point Started by Bhargav Prasad Oracle Analytics Cloud and Server Idea Lab
-
Calculated Field in OTBI PromptSummary: Wish to have Calculated field in OTBI prompt. I want to have 3 prompts based on the given table data below: Assignment Last Update Date Grade Change Flag Grade …Pradnya_Pampatwar 1 view 0 comments 0 points Started by Pradnya_Pampatwar Oracle Transactional Business Intelligence
-
1To have different person number sequence as per legal entities.Below is list of legal entity and their sequence of person number requirement that should be followed automatically when employee is hired into that Legal entity LE1: 52…Darshan12345 2 views 0 comments 1 point Started by Darshan12345 Oracle Analytics Cloud and Server Idea Lab
-
2Journey Task search can be added with Sort By option on Journey TaskDescription : Journey Task on search can be added with Sort By option on Journey Task Use case and Business Need : When Performers using Journey and want to search Task,…User_XUB7Q 12 views 0 comments 2 points Started by User_XUB7Q Oracle Analytics Cloud and Server Idea Lab -
Open a Drill Down report in same page in DashboardHi Team, We are using a dashboard for performance documents in Oracle Fusion OTBI. Within this dashboard, there is an attached analysis featuring a Pie chart that displa…User_46FMZ 205 views 1 comment 0 points Most recent by Rich Merkel Oracle Transactional Business Intelligence
-
Report for vacant positions and open job requisitionsSummary: Hi, I was wondering if anyone has a report that shows active vacant positions with active open job requisitions? We are looking to pull: * Active position curre…Eva Elks Herrmannsen 353 views 1 comment 0 points Most recent by KatieH Oracle Transactional Business Intelligence
-
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, AjayAjayKumar Maddipati 213 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
we have developed new OTBI report but when we Export analysis issue is occuringSummary: Hi Team, when we Export analysis > data > excel we get each row have person number, name some columns coming each row. and we export another way like Export ana…AjayKumar Maddipati 171 views 5 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence
-
Any one help Skills ReportSummary: Hi Team, we need skills report in Bi or OTBI Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets…AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
how to put a Countif in a unique field in an OTBI reportSummary: In my report, I have Person Number field which is unique, however the report has some duplicate entries. I only need to understand how do I get a count to see h…Abhishek Bagh 1.3K views 8 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence
-
OTBI Analysis - Getting DFF meaning instead of the valueContent Hi, I am developing an OTBI analysis that deals with several DFF from Oracle HCM Cloud. These DFF have value sets that get values from lookups loaded into the sy…Tmolina-Oracle 504 views 5 comments 0 points Most recent by Yves Chassein Oracle Transactional Business Intelligence
-
when i taken manger number and name from manager folder then company level coming mulitiple numberSummary: Hi Team, when i taken manger number and name from manager folder then company level coming mulitiple numbers for each mangers . How can i rectify the issue. PFA…AjayKumar Maddipati 131 views 7 comments 0 points Most recent by AjayKumar Maddipati Oracle Transactional Business Intelligence