Welcome to the Oracle Analytics Community

Popular Tags
- OTBI 1,000
- Reporting 858
- Analysis and Data Visualization 671
- Analysis 583
- BI Publisher 538
- Administration 487
- reports 297
- obiee 288
- Oracle Fusion Analytics 287
- FAW 270
- Analyses 240
- BI Publisher Data Models 226
- Developers 220
- Data Connectivity 185
- Data Modelling and Datasets 164
- OBI Answers 153
- security 150
- Report Output 135
- Agents 134
- Packaging and Licensing 124
- Home and Catalog 117
- HCM 115
- ERP Analytics Content 114
- Access and Manage Data 107
- OBIEE Answers 105
HCM
Discussion List
-
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 12 views 0 comments 1 point Started by Bhargav Prasad Oracle Analytics Cloud and Server Idea Lab
-
How to know if FAW for HCM is available/enabled in our system?I'd like to know if FAW for HCM is available/enabled in our system. Is the any documentation related on how to enable FAW? Is the subscription different from Oracle Anal…Welsey 24 views 2 comments 1 point Most recent by Mallikarjuna Kuppauru-Oracle Fusion Analytics Warehouse
-
6New flag field which uses the Federal Ethnicity code to classify race and ethnicity categoriesThis new attribute would follow the IPEDS standard reporting guidelines to condense and clarify race and ethnicity data. If an individual selects 'I am Hispanic or Latin…CarolineAnderson 21 views 1 comment 6 points Most recent by Leanna Kirkland Fusion Analytics Warehouse Idea Lab
-
The columns like BANK_NAME and BANK_BRANCH_NAME are blank in iby_ext_bank_account tableWe have a requirement to generate a report retrieving the details of changes made by an employee to their bank details in the payment methods page. We have created a use…Anusha B S 1 view 0 comments 0 points Started by Anusha B S Oracle Transactional Business Intelligence
-
Employee signature picture in reportHello Everyone, Can anyone tell me how I can show an employee's handwritten signature in my report? Thank you.
-
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…User_10PQB 21 views 1 comment 0 points Most recent by Sinduja Sekar-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…
-
[OTBI Report] Retrieving "Length of service bonus"Hi folks! I hope you can help me with this little questions: How can I retrieve the last amount of the length of service bonus? In which field of which subject area can …Gian Luca Triglia 1 view 0 comments 0 points Started by Gian Luca Triglia Oracle Transactional Business Intelligence
-
Submit a document of record request via the REST APIHi Team, there is an issue I encountered while working with the document record. When attempting to submit a request via the REST API, I noticed that the request appears…Mohammad Borghol 11 views 0 comments 0 points Started by Mohammad Borghol Oracle Transactional Business Intelligence
-
How to Effective Date a Headcount Report?I have a headcount report in OTBI HCM, that is running from the Worker Assignment Real Time subject area. When it runs, its always latest and greatest. How do I effectiv…Luke.esh 14 views 1 comment 0 points Most recent by Patrick_Midd Oracle Transactional Business Intelligence
-
Does Fusion provide a mechanism to embed typical Google Analytics V4 tracking snippet?Does Fusion provide a mechanism to embed typical Google Analytics V4 tracking snippet? If the answer is no then perhaps there is already an Oracle analytics element buil…
-
Workforce Salary Basis & Compa Ratio OverviewSummary: Two DVs used in this analysis are giving a deep dive on existing salary basis & compa ratio spread across the organization. Content (required): These DVs have f…Nupur Joshi-Oracle 246 views 1 comment 0 points Most recent by Dhaval Parikh Stantec Fusion Analytics Warehouse
-
Table for employees role history.Is there any table or related table in HCM that stores historical role assignment data and transaction data, and timestamps history for an employee?
-
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 229 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 11 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 21 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 42 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…
-
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 276 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 33 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