Category 81
Discussion List
-
OTBI Column Properties Data format First Name Last NameSummary: The current format is Last Name, First Name - is there a way to switch this with below Data Format? Content (please ensure you mask any confidential information…THawkins_LGI 22 views 8 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Project Number for Payables Invoices in JournalsGood Day, Where can I pull the correct project number field for payables sources? We use 3 subject areas for our report where both Journals Real Time are mainly used: - … -
HCM Position Hierarchy standard report code file required which is running in backendHi Team, We have a requirement to develop a new report as like "HCM Position Hierarchy" standard report, so please share code file or file path and report name so that w…Suresh Gandla-Oracle 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need a report for Global transfer records with location old and new locationHello, I have requirement for report to show global transfer records with old and new location and also active inactive all employees with their salary if anyone have pl…Mirza_Adeel 22 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there a way to give Delegations for Reporting?Summary: We would like a manager to allow an employee to pull reports for her direct reports We tried Role delegation and Approval Delegations but none of them help with…THawkins_LGI 22 views 6 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM
-
Seniority date - Legal Entity Hire Date or Rehire dateSummary: Requirement to identify the Lenth of Service based on Rehire date Content (please ensure you mask any confidential information): We have requirement to accrue t…
-
Learning Calendar reportSummary: Hi Folks, Learning calendar view is blank and does not have the calendar view Please help to fix this All other reports for learning calendar title and learning…Sowmiya Velusamy 121 views 7 comments 0 points Most recent by User_7DF56 Reporting and Analytics for HCM -
Error opening journey reportHi experts, When I try to open the journey report, this error appears. It happens every now and then, not all the time. Is there a way to solve this problem? Thank you, … -
OTI Query for Fetching Free Text Fields from QuestionnaireDear Community, I am working on an OTBI report and need some help with querying data from a questionnaire called "Student Touchbase". The Questionnaire consists of sever…Ashok Kumar Sharma 53 views 14 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
https://community.oracle.com/customerconnectHow can I get employee's dependent detail and emergency contact number in OTBI reportAnup Karmankar 13 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
we have given the row num in select statemnt but we need row count also ?Summary: Hi we have given the row num in select statemnt but we need row count also ? need row count=2 ? Content (please ensure you mask any confidential information): V…AjayKumar Maddipati 11 views 7 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Ethnicity Formula broken in report after 24A updateSummary: We have a report that has been in use without issue for a few years. In this report, we are getting a general active headcount of employees and contractors with…Rob Stahly 52 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Level 02 Organization Name are not generating in the HR Help Desk ReportsThere is a requirement to include the Level 02 Organization Name in the Help Desk Report. However, after adding the columns 'Level 02 Organization Name' and the suitable…Anu shree 28 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI - what is Worker Creation DateIn OTBI, when looking at the subject areas in the analysis reports, what does the following mean: Subject area: Workforce Management - Worker Assignment Real Time Folder…
-
OTBI agents and P2THello! We are setting up our first OTBI agent to send out daily notifications and wondering what will happen to the agent in test environments. Will it be automatically … -
We have ORC Offers Transactions Report but need to add country column for below query ?Summary: Hi Team, We have ORC Offers Transactions Report but need to add country column for ? Content (please ensure you mask any confidential information): select a.OBJ…AjayKumar Maddipati 22 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Worker Assignment Event history - job title / position title as of assignment effective dateSummary: When we are running OTBI analyses with the Worker Assignment Event subject area, we need to be able to see what the associated position name/ job code names are…Hunter Kennedy 46 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to use AOR subject area to show active AOR's for inactive assignments?Summary: Trying to get a list of inactive assignments with active AOR Content (please ensure you mask any confidential information): I'm trying to use the subject area "… -
Hide seeded HCM cloud OTBI Dashboards from Dashboard MenuSummary: Business does not want to see HCM cloud product seeded OTBI Dashboards from Dashboard Menu Content (please ensure you mask any confidential information): Versio…Sambasivarao Manam 68 views 3 comments 0 points Most recent by Sambasivarao Manam Reporting and Analytics for HCM
-
How to see scheduled processes submitted by others?Summary: How to see scheduled processes submitted by others? Content (please ensure you mask any confidential information): If I (admin) submit a process my colleagues (…Stefano_Mazzocca 94 views 2 comments 0 points Most recent by ES-Oracle Reporting and Analytics for HCM -
Report Error- Oracle HCM BIP ReportSummary: Error populates for a HR Admin user with data security that excludes specific HR depts. The report parameters page does not load for these types of users. This …Erica Williams 61 views 11 comments 0 points Most recent by Erica Williams Reporting and Analytics for HCM -
Identify Headcount and FTE by Dept and Job AND Display Number of Open Requisitions by Dept and JobSummary: Requirement is a report showing active headcount and FTE by Dept by Job AND # of open job requisitions (Filled Date is null) AND # open FTE. Is this possible? Y…JHaden3 47 views 4 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Extracting Requisitions from Career SitesSummary: Hello Guys, We would like to create an analysis or a data model that allows us to extract all requisitions posted on various career sites. Currently, we are enc…Giuseppe Iacono 1 view 0 comments 0 points Started by Giuseppe Iacono Reporting and Analytics for HCM
-
Hire Report - Two subject area report erroring with two measuresSummary: Hello, we are building a hire report using the Workforce Management - Worker Assignment Event subject area and we only need one field from the Workforce Managem…CCannadayCTR 12 views 2 comments 0 points Most recent by CCannadayCTR Reporting and Analytics for HCM -
How do I query Estimated Time To Hire from ORC using BI Publisher?Summary: I need to query data on Estimated Time To Hire for existing requisitions. Any information is greatly appreciated. Content (please ensure you mask any confidenti…
-
Sql query or Table for Worksheet Display and Default Worksheet Display assigned to compensation planHi team, Sql query or Table where the information stored for Worksheet Display and Default Worksheet Display assigned to workforce compensation plan in HCM compensation …
-
What will I be able to do if I activate a user?What will I be able to do if I activate a user? Please let me know. Thanks, MayukoMayuko-Oracle 13 views 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
Sql query or Table name for Workforce Compensation plan cycles assigned to planHi team, We are unable to find the table where the "Plan cycles" information stored for HCM compensation module. Could you please provide us the table or sql query to ge…Opkey PA 152 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to translate BIP Report Parameter TitleSummary: We have a requirement to translate the report parameter label. We couldn't get any link from Community or MOS to check the translation. We would require your su…