Popular Tags
- Reporting 1,301
- OTBI 1,232
- Analysis and Data Visualization 817
- BI Publisher 690
- FDI 672
- Analysis 626
- Administration 516
- Oracle Fusion Analytics 479
- OBIEE 392
- BI Publisher Data Models 290
- Answers 253
- Analyses 247
- Developers 231
- Analytics 208
- Security 208
- Data Connectivity 198
- Data Modelling and Datasets 188
- HCM 188
- ERP Analytics Content 169
- Report Output 165
- BIP 155
- Agents 146
- BI Publisher Report Templates 145
- OAC 136
- Packaging and Licensing 128
Core HR
Discussion List
-
How to join the recruiting subject areas to Core HR subject area in otbiIs there any join condition to join multiple subject areas For example could anyone help to join below subject areas. recruiting - recruiting real time workforce managem…Nagendra Chitra-Oracle 33 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence -
OTBI Report : Department level DFF issueWe have an OTBI report which pulls the employment level details and department level details of an employee. We would like to pull certain detail of the departments base…Amulya Kadiyala 19 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
1Custom fast formula based start date and end date for Individual Compensation Plan (ICP)Currently ICP supports only few payment start date and end date options. One common requirement we see is to derive the automatic payment start date and end date based o…
-
Employee Assignment details at the time of the absenceI would like to report on the worker assignment details at the time of the absence. If for example an employee changed department today, the absence from last year would…Rajeev Nayan 13 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
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 13 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 55 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 85 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 62 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 41 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
How to query fusion tables in SQL developerSummary: We have a data model to select the email_address_id from fusion.PER_EMAIL_ADDRESSES but we want to be able to query this table or data from this table (or IRC_C…maria.stanciu 1.4K views 4 comments 0 points Most recent by Robb Penoyer 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 5 views 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 1 view 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 121 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 324 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 121 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence