Welcome to the Oracle Analytics Community
Popular Tags
- OTBI 949
- Reporting 844
- Analysis and Data Visualization 647
- Analysis 572
- BI Publisher 506
- Administration 499
- obiee 282
- reports 282
- Oracle Fusion Analytics 240
- Analyses 237
- Developers 223
- BI Publisher Data Models 213
- FAW 212
- Data Connectivity 184
- Data Modelling and Datasets 160
- OBI Answers 150
- security 143
- Report Output 133
- Agents 130
- Packaging and Licensing 124
- Home and Catalog 116
- ERP Analytics Content 109
- HCM 105
- OBIEE Answers 102
- Access and Manage Data 102
HCM
Discussion List
-
Accrual rate- plan balance APIHow we get the actual accrual rate in plan balance API response payload. https://xxxx-xxxx.oraclecloud.com:443/hcmRestApi/resources/latest/planBalances?orderBy=balanceAs… -
Headcount Overview DashboardSummary: This analysis is using the HCM – Workforce Core Subject Area, it provides an overview of the employee headcount by various categories. It also makes use of the …Romesh Lokuge -Oracle 154 views 3 comments 2 points Most recent by Nupur Joshi-Oracle Fusion Analytics Warehouse
-
Table Location of To/From Dates for Talent RatingsI am looking to find the the save table location for the To/From dates for the Talent Rating module. This is for a BI publisher report using a Data Model. The associated…Adam Cook 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence
-
11Social sourcing custom JavaScript enabling to add Google Analytics TagDue to the recent upgrade of google analytics to GA4, we are not able to track any traffic on the website. Oracle has confirmed sourcing doesn't support GA4 analytics. I…Ramya Koganti 22 views 0 comments 11 points Started by Ramya Koganti Oracle Analytics Cloud and Server Idea Lab
-
Automated Reports have stopped being sent to stakeholdersHi All, Can someone please help on the below issue. We are facing issues where the below automated/scheduled reports have stopped being sent to different stakeholders si…Sakthi Priya S 41 views 2 comments 0 points Most recent by MeganTerrellHowmet Oracle Transactional Business Intelligence
-
In what HCM Cloud subject area can I find billing rate information?I am looking at Benefits - Billing Real Time subject area but can't find the proper fields for Billing Rack Rate, Billing Rate Currency and Billing Rate Effective Date. …Jon D Calhoun 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence
-
The database mappings of some of the BICC VOs are not present in the list released by Oracle.We have configured Oracle BICC to extract HCM data. I am trying to find the mappings between VOs and tables. The below support note Doc ID 2506210.1 provides list of HCM…
-
ORC-Table name to get the correct delivery status of Email Notifications sent to CandidateOracle Recruiting Cloud - Table name and attribute name in BIP Report to get the correct delivery status of Email Notifications sent to candidate / Hiring Manager / Recr…
-
Terminated users has still active in security consoleHi Guys, After termination, the some of the user accounts is still active in security console. we have already enabled the Auto Provisioning rules that should ensures th…
-
FAW HCM - Workforce Rewards - Payroll Balances OfferingSummary: Fusion analytics Warehouse now offers a new subject area on payroll balances. Content (required): Payroll as of now is in preview offering. So customer need to …Nupur Joshi-Oracle 238 views 12 comments 0 points Most recent by Nupur Joshi-Oracle Fusion Analytics Warehouse
-
1Search advanced and export the data to excel in NUI pagesWhen accessing the environment, when we access the NUI pages, in the search filters there are no advanced search options as if they appear in the classic pages. So, sinc…
-
2Add FEIN into all Payroll Subject Areas in OTBIThe FEIN (Federal Employer Identification Number) can be see as apart of this field "Tax Reporting Unit Name", but it doesn't exist as its own field. Prior comment on: h…Andrew_Schmitz 31 views 3 comments 2 points Most recent by Andrew_Schmitz Oracle Business Intelligence
-
FAW HCM - Custom Data Security Use Cases Using AOR data available in FAWPost 22.R4 FAW release, FAW brings AOR data as well from cloud hcm with daily incremental changes. Many organizations use AOR data to set up custom security and it has b…
-
Which subject area(s) in FAW (HCM Fusion Analytics) can I find Talent Pools?If Talent Pools subject area is not available in Fusion Analytics, what is the best approach in utilizing the HCM OTBI subject area into FAW? Do we need to build a data …
-
In which subject area can we find the "N-BOX Assignment rating (NBOX) in FAW(HCM)?Checked the following subject areas in FAW- HCM-Talent Review Meetings, HCM - Talent Profile. In HCM OTBI subject area, 'Workforce profile- Person Profile Real Time>Pers…
-
FAW HCM incremental loadsSummary: Where can I see the FAW incremental data load process log in HCM? Content (required): When the FAW pipelines run to perform an incremental load, I believe the F… -
2Need ability to filter on either ERP or HCM records in Common - Warehouse Refresh StatisticsWe would like to be able to review rejected records based upon if the rejects are ERP or HCM related. This would likely need to come from the Common - Warehouse Refresh …
-
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:AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Create a Pre-Enrollment Validation Formula for Benefits PlanI have a requirement that needs a validation is the sum of 2 Plan is 5%. But i'm having trouble to find a Fast Formula if the employee is a new hire. because there is on…
-
17FAW Org Chart / Organization ChartAs an FAW HCM user, I want to be able to quickly display an Org Chart based on the data within a Subject Area and not a static dataset. This would eliminate tedious hour…MeganTerrellHowmet 62 views 0 comments 17 points Started by MeganTerrellHowmet Fusion Analytics Warehouse Idea Lab -
3Data PurgingWe understand that if an organisation would like to purge the job history (reports), every time they need to raise SR which is inadequate solution on long term. It would…
-
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 …Ms_Oracle 31 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Oracle Transactional Business Intelligence
-
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…Bernadette Dorris 71 views 5 comments 0 points Most recent by Bernadette Dorris Oracle Transactional Business Intelligence
-
Audit DashboardHi All, Can you please share useful documents on how to enable Audit dashboard, attached is the view that we want it in our environments. Also we are not sure if this is…
-
1Can we run BICC jobs in parallel, if so what is the MAX number of VOs which can run in parallel?Summary: Currently our BICC jobs are run sequentially and NOT in parallel, but we want to run them in parallel. Is it safe to run them in parallel? If yes, what is the M…Benjamin Israel 21 views 0 comments 1 point Started by Benjamin Israel Oracle Analytics Cloud and Server Idea Lab
-
Custom Security in Fusion Analytics Warehouse.Summary FAW Custom Security features Content Below are the list of Blogs we have currently published on Custom Security Custom Data Security in nine simple steps Blog on…Krithika Raghavan-Oracle 518 views 12 comments 1 point Most recent by Krithika Raghavan-Oracle Fusion Analytics Warehouse -
Oracle HCM CompensationHi Team, We are recently started working on the Oracle Compensation Module, and we are clear on the processes to take and considerations to make while implementing the C…
-
Detailed Headcount Analysis - By Configured Bands using BI Classic ViewSummary Headcount dashboards in this catalog, are built using BI Classic. Please download and explore the dashboards. Content Navigate to BI Classic and import the attac…Ravi Guddanti-Oracle 88 views 2 comments 1 point Most recent by Sahithi Kolasani-Oracle Fusion Analytics Warehouse
-
How to get the latest completion date along with the new due date? (Learning Assignment)Summary: We want to get in the report the latest completion date of the learner and the new due date in each course in 1 row for each learner. However, we are getting 2 …
-
Growth Rate Calculations for Hire & TerminationSummary Calculate quarterly , half-yearly & yearly Hire & Termination growth rate Content This DV uses hire headcount, voluntary termination headcount, involuntary termi…Nupur Joshi-Oracle 136 views 8 comments 0 points Most recent by MeganTerrellHowmet Fusion Analytics Warehouse