Category 81
Discussion List
-
SQL query to retrieve a common lookup description at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, we created a custom common lookup. We need to extract at the employee level the lo…Valerio Curzi 180 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Multiple Assignment ReportSummary: Does anyone have an XML or data model that captures employees with two (or multiple) active work assignments; showing job, department and manager details. Conte… -
How do I remove notes formatting in reportI have a reprot that pulls notes information which users can format. How do I change the output to where the special characters do not show up on the report?erpexpert03 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Why are there different formats of the Transaction Analysis Duty role codes?Summary: Some Transaction Analysis Duty role codes follow this format: "ORA_FBI...DUTY_HCM" and others this format: "FBI…DUTY". Is there any significance to the role cod…Jessamyn Donovan 40 views 5 comments 0 points Most recent by Jessamyn Donovan Reporting and Analytics for HCM -
![Arun Kumar Krishnan [AK]](https://us.v-cdn.net/6034893/uploads/userpics/L8BUJDYF94E7/nTLGWFBWW678P.jpg)
Participant Feedback - Questionnaire Responses duplicationSummary: Dear Team, We have a Performance template which has the Participant feedback included and would like to capture the responses provided by the Participants in th…Arun Kumar Krishnan [AK] 71 views 4 comments 0 points Most recent by Martin Smid-Oracle Reporting and Analytics for HCM -
HCM Position HierarchySummary: Hello, I created an OTBI using Position Real Time subject area but I am not able to get the desired results. Example, I have below position hierarchy Position1 …HetalVaghela 21 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL query of Fast Formula retrieving manager+1 and manager+2Summary: Content (please ensure you mask any confidential information): Hello experts, do you have an SQL query or fast formula to retrieve the employee manager+1 and ma…
-
HOW TO DELETE INACTIVE USERS IN fUSIONSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Milind Kulkarni 53 views 3 comments 0 points Most recent by Alex Cardenas Reporting and Analytics for HCM
-
Extract run Failing after adding new FastFormulaSummary: Extract is failing after adding new rule to get the correct parking tier based upon employee salary Content (please ensure you mask any confidential information…GauravGupta39 22 views 4 comments 0 points Most recent by GauravGupta39 Reporting and Analytics for HCM
-
OTBI report prompt to display only direct reports for Line managersSummary: We have created an OTBI report using the subject area - 'Workforce Learning - Learning Management Real time'. We have created a prompt which displays all the Em…Sovan Mishra-Oracle 474 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Difference between Headcount and worker count in fusion analytics dashboardsSummary: Why are there two extremely similar workbooks (for many metrics) which include Person Count and some which do not. Their descriptions show the only difference i…ClayJ 25 views 2 comments 0 points Most recent by community-dw-integration Reporting and Analytics for HCM
-
Where can I find release notes regarding OTBI and BI Publisher for HCM?Hello, I am looking for Release Notes or What's New regarding OTBI and BI Publisher for HCM Cloud. Could you please help me find where they are? Kind regards AliceAlice Gouzy 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Candidate date of birth and gender are not pulled from OTBI reportSummary: Hi, I have used Recruiting-real time subject area ans used "person date of birth", "person gender" columns to fetch the candidate date of birth and gender. Howe…Aruna Aounti -Oracle 325 views 7 comments 0 points Most recent by PranitSawant Reporting and Analytics for HCM
-
Fast Formula or query retrieving the number of working daysSummary: Content (please ensure you mask any confidential information): Hello experts, it is possible to build an SQL query or Fast Formula retrieving the number of work…Valerio Curzi 253 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
looking for ytd and ptd bip reportSummary: lookind for ytd and ptd bip report Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Co…
-
Employee self service page not displaying in mobileSummary: Employee self service page not displaying in mobile, this is mobile only issue. Content (please ensure you mask any confidential information): We are testing Op…
-
Canada's Employment Equity Questionnaire (Legislative Requirement)Summary: Hi Team, I would like to ask for your thoughts if you have configured or added this legislative requirement of Canada to the system? It's like a set of question…KarenA 11 views 1 comment 0 points Most recent by IoanaNatalia-Oracle Reporting and Analytics for HCM
-
ORACLE FUSION HCM QUERY TO GET USER ACCOUNT LOCKEDSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Daniel Paul-183648 427 views 6 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Can i see what a user sees from PER_ASSIGNMENT_SECURED_LIST_VWe have a user downloading a report but seeing just 600 result compared to another users that can see more than 800. The only thing in the report that could prevent him …margherita bonfiglio 24 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Personalization of help desk requests page in redwoodSummary: We have requirements to personalize help desk requests page to split category field to category and sub-category, noting that the page is redwood and personaliz…
-
Page breaks do not work for bursting (RTF template -> Excel output)Report has RTF template and it is exported to XLSX format only. Resulted Excel has 2 separated sheets (from functional logic one Excel file contains 2 reports are spaced…Sourabh Patial 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
BIP encryption with UTF-8 encoded csv fileHi Team, Can you please help me know how to generate a UTF-8 encoded csv file with encrypted pgp extension file. I am using etext template. Thanks.SM_EP 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Looking for lineage data for a few VOs which are missing in Rel13_24C_BICC_HCM mapping sheetSummary: Looking for linkage details for following PVOs. These are not deprecated but missing in Rel13_24C_BICC_HCM_Database_Mapping_with_ViewObjects sheet. Any help wil…Vineeta Agarwal-Oracle 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Unable to find table name that stores comments from 'Request more Info' section of BPM approvalsSummary: Hi All, Unable to find where the comments are stored from 'Request more Info' section of BPM approvals. It's not in table FND_BPM_TASK_COMMENT or HRC_TXN_COMMEN…Nirmal Ignatius 12 views 3 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Where to find/add Brazil Job Details attribute values ?Summary: I am not able to find this Brazil Job Details values in Job Details/Jobs page. I believe its an attribute under a delivered DFF attribute (as shown in the Desig…Anshuman Chatterjee 43 views 5 comments 0 points Most recent by Anshuman Chatterjee Reporting and Analytics for HCM
-
Sample query to retrieve employee DivisionSummary: Content (please ensure you mask any confidential information): Hello experts, we need to retrieve the employee division name. Do you have a sample query to do i…Valerio Curzi 374 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
BI Report on candidate interaction date as per applicationNeed BI Report on candidate interaction date as per application. Code Snippet (add any code snippets that support your topic, if applicable):Aishwarya Somvanshi 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
FTE and Headcount no longer in per_all_assignments_m tableSummary: Is there a reason why FTE and Headcount no longer in per_all_assignments_m table? Content (please ensure you mask any confidential information): Version (includ…Consultant Ian 22 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Which table store user password and Password expiration DateSummary: Hi , Please let us know Which table stores the user password and Password expiration Date under User definition. Navigation : Tools-> Security Console-> User At…
-
Query to join BEN_PRTT_ENRT_RSLT to Payroll Tables (PAY_RUN_BALANCES)Summary: Hi experts, Just wondering if there's a way to connect the benefits table BEN_PRTT_ENRT_RSLT to payroll table (ex. PAY_RUN_BALANCES). We have a BIP report requi…