Category 81
Discussion List
-
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 51 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 23 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 493 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 22 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 21 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 331 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 274 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 517 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 23 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 13 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 14 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 11 views 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 11 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 47 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 426 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 21 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…
-
OTBI report - functional managersSummary: I would like to create a report that could give me a list of functional managers by employee - OTBI reports. Content (please ensure you mask any confidential in…Jacqueline GRANDIN 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report of edited termination datesSummary: To assist with researching retroactive payroll scenarios, we would like to report on employees who have edited/corrected termination dates. We would like to sho…awheel09 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to obtain a drill down OTBI bar chartSummary: How to obtain a drill down OTBI bar chart Content (please ensure you mask any confidential information): Hi, we created a dashboard based on a OTBI Report. The …Barile Alberto 31 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Impossible to cancel work relationshion because already terminatedSummary: We have a work relationship that needs to be cancelled but is already terminated, we can't reverse the termination because the employee has a second work relati…margherita bonfiglio 12 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management
-
Is it possible to use an EFF in a case statement in OTBI?Summary: I am working on a report trying to calculate days between LOA End Date and the Estimated RTW Date (EFF) in the system. The case statement is producing an error,…
-
Report to fetch void payment dateSummary: We are looking for a report with output similar to Payment Register Report but with an additional column to display the actual Void date. Content (please ensure…