Category 81
Discussion List
-
SQL for PER_EMAIL_ADDRESSES to obtain Email Address IDSummary: Email Address ID required for HDL worker.dat file to mass upload email address changes. Content (required): We want to use HDL to mass upload email address chan…Michelle Hughes 3.1K views 6 comments 0 points Most recent by Michelle Hughes Reporting and Analytics for HCM -
Restricting the values of a dashboard promtSummary: Hello, We have made a BIP report on an Assessment which will show the candidates who have reached the assessment state and their results/current status etc. The…Shreya Datir 42 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How can i get access to OTBI?Is there a specific role/privilegie that grants access only to the OTBI? Thanks Guys, Mayko MeloMayko.Melo 34 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
State tax details in hcm fusionSummary: I am looking for the below details in the state tax setup level state tax type state Minimimum wage state of the tax defined Please guide me to refer the table …
-
Rehires are showing twice when using Seniority Years in Wrkfrc Mgmt - Person Seniority Real TimeContent (required): When I add Seniority Years (or months/days) to a report in this subject area, rehires are duplicated with one row calculating based on their enterpri…Monique Dias 54 views 5 comments 0 points Most recent by Monique Dias Reporting and Analytics for HCM
-
Post P2T, how to switch from classic dashboard view to new dashboard view?Summary: We have dashboard in Prod which has a responsive UI as per below. However post P2T, In Test it is showing classic view for the dashboards. How to change this vi…Sathesh Ramaswamy 61 views 9 comments 1 point Most recent by PriyankaM Reporting and Analytics for HCM
-
Column order in BIP ReportSummary: Column order in BIP Report Content (required): Hi, We are trying to have specific order of columns in our BIP report (CSV output). Earlier it was word layout wh…
-
How to link Top Manager to a username within "Workforce Management - Worker Assignment Real Time"Summary: Hi all I'm trying to create an emergency contact report that allows managers to see their entire reporting line population and the emergency contact details on …
-
Guidance to optimize OTBI HCM Cross-SA Reports having static report filters1- Some Cross subject area reports may be costly in terms of response time, if they are not designed correctly. It is always recommended to use (i) at least one common d…Abhishek Dixit-Oracle 134 views 1 comment 4 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Help getting interview date - BI report for ORC.Summary: Hello experts, Need input for getting interview date for an ORC report i am working on. This is my first time working on ORC related tables. I can see this tabl…Jithin Mathews 81 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
We have option to Scheduled the BIP report in more option but why we go with ESS Job any difference?Summary: Hi Team, We have option to Scheduled the BIP report in more option but why we go with ESS Job any difference? what is the main purpose of ESS JOB . How can we u…AjayKumar Maddipati 117 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Performance report including response to questions not rendering while using pivot optionSummary: Have anyone been able to generate a report from Performance Rating real time subject area that includes response to questions with response to each question app…
-
Time Entries SQL HelpHi Experts, we need to fetch all the time entries including Absences.SO for Absences we need to have a column for Absence Type.But i am not sure how can we find the abse…minati_behera-Oracle 42 views 4 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
Arun Raj Budde 42 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
I'm looking below columns in otbi or any reference reportSummary: Hi , I'm looking below columns in otbi or any reference report ,any help me on below columns. Thanks, Ajay Content (required): Opening EL leave balance /DOJ (Da…AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need to edit Subject in Enterprise Onboarding mail- ChecklistWelcomeReportSummary: Wanted to customize the Enterprise Onboarding email subject being sent. Content (required): We want to display the first name in place of full name in the Enter…Gourabh Choudhary 52 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Unbale to get Notice Period UOM token details for Offer creation in XML file?Summary: Unbale to get Notice Period UOM token details for Offer creation in XML file? Content (required): Unbale to get Notice Period UOM token details for Offer creati…
-
Need Enterprise Onboarding Template NameSummary: Wanted to customize the Enterprise Onboarding email being sent. Content (required): We need the path of the template. We want to display the first name in place…Gourabh Choudhary 53 views 3 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
Need SQL for data model list of values for Time Card Time TypeSummary: I need to add a parameter to a BI Publisher Report that has the values from the Time Type field from the Time Card. I have the following SQL written for the lis… -
Time card dashboard for line managersSummary: Need assistance on using the Time card dashboard filtered for line managers Content (required): Need assistance on using the existing seeded Time card dashboard…VenkataSubbareddy 41 views 3 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
Special Characters in BIP ReportSummary: have requirement of replacing special characters coming in the description column of the BIP report with following: Double quotes replace with '"' need to …Rajdeep Chavda 219 views 0 comments 0 points Started by Rajdeep Chavda Reporting and Analytics for HCM
-
Geography Mappings in Oracle HCM CloudSummary: How is data from hz_geographies mapped to per_addresses for countries other than the US Content (required): I am working on a Peoplesoft to Oracle HCM Cloud imp…NathanParry 115 views 1 comment 0 points Most recent by Sebastien Mariller Reporting and Analytics for HCM
-
How do you remove double quote marks from a CSV file?Summary: I'm creating a CSV file to export to a 3rd party vendor. The file contains double quote marks around a few fields. The vendor does not want them. How can I disa…MorganH13 181 views 2 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
calculation card link with legal employerSummary: we are trying to fetch the below calculation card with specific legal employer Could you please let me know if any query is available or guide me on the linking…
-
User-define column does not return valuesSummary: Content (required): Hello everyone, We are currently trying to create a data model using the following sql: SELECT /*+ MATERIALIZE */ r.row_low_range_or_name SS…Maria Xydopoulou 43 views 10 comments 0 points Most recent by Maria Xydopoulou Reporting and Analytics for HCM -
Reporting on 'Required' Field in OTBI From the Learning CatalogHello all, Does anyone know if its possible at all to report on the 'Required' section of any assigned learning to an individual? Within the Learning Catalog, we have co…
-
Can you password protect files sent out using an Agent?Summary: Is it possible to add a password to the output file for additional security that is sent out via email by the agent? It isn't needed for all situations but if w…Sarita Schumacher 43 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI Query not working with where clause in BI publisherSummary: OTBI Query not working with where clause in BI publisher We have query which works in BI Publisher with no where clause but when added with where clause the whe…
-
Privilege for ORA_PER_LINE_MANAGER_ABSTRACT to access Workforce Management - Worker Assignment SASummary: Hello, Does anyone know what is the exact privilege required for ORA_PER_LINE_MANAGER_ABSTRACT to run the data of subject area Workforce Management - Worker Ass…Hazel De Castro 52 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Report Date Parameters needed START: (First_Day of Last month) END: (Last_Day of Last_month)Summary: Hi Forum: I'm looking to use below to accomplish General tab for Scheduling a report START: Last_Day(ADD_MONTHS(SYSDATE,-2))+1 First_day END: Last_Day(ADD_MONTH…JTW_HCM 1.3K views 1 comment 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM