Category 81
Discussion List
-
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 45 views 4 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
User_2025-10-10-00-14-09-209 45 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 42 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 52 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 43 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 240 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 116 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 252 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 42 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 53 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Cannot extract Moved to HR information from BI tables (Recruiting)Summary: Content (required): Hello experts, we need to track candidates under Moved to HR and Moved to HR date. Is there a BI table to extract this information? Thanks i…Valerio Curzi 24 views 2 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
SQL or table to get the PAY_PAYROLL_TIME_TYPE ID of time and tasksgood morning experts We are working on a time and tasks report and we did not find the PAY_PAYROLL_TIME_TYPE ID, only the code and the name, could you help us with the S…
-
OTBI plugin for officeSummary: BI Publisher tab disappeared from Word Content (required): I installed OracleAnalyticsPublisherDesktop-6.4.0-win64.exe, and it opened Word after the installatio…Maboagamo 83 views 17 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
Formula for exporting date in csv as dd mmm yyyySummary: I have a need to present date in a csv extract as dd mmm yyyy. I have the below formula that presents it as dd mm yyyy, any assistance that could be provided to…
-
Delete Folder with permission set to Open in BI CatalogSummary: Able to Delete BI Catalog Folder Content (required): With admin user we created the following folder structure Shared Folders>Custom>Custom_1>DM_Reports>.... No…Sahil_Makhiza 44 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
New Hires ReportSummary: Is it possible to create a new hire details report that pulls in the effective date from the assignment vs the proposed start date in the offer letter? Content …Bhuangtran 175 views 8 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
OTBI Analysis with suspended assignment detailsSummary: We have an OTBI analysis to capture employees' suspended assignment details and need to add the date of the that suspended assignment started. Content (required…Ayesha Iroshani 34 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Exact Privilege for Human Resource Analyst Role to view own data in the OTBI reportSummary: Hello, Does anyone know what is the exact privilege required for Human Resource Analyst Role to view own data in the OTBI report. It appears that there are nume…Hazel De Castro 45 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
New Redwood reports available for P&GSummary: Hello, Is there any new redwood reports available for Performance & Goals? Kindly provide the links here. Your help is highly appreciated. Regards, Hazel Conten…Hazel De Castro 55 views 4 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
How to make Blob Image circular in bi publisherSummary: We have a requirement to display image in circular in the output. Content (required): Version (include the version you are using, if applicable): 23A Code Snipp…
-
Is it possible to have multiple organization trees active in core HR?Summary: Is it possible to have multiple organization trees active in core HR? What is the impact if the hierarchy is different? Does this affect reporting? Content (req…
-
Compensation Eligibility StatusSummary: Content (required): Hello everyone, I'm currently trying to create a Value Set that will get me the Compensation Plan ID and the Compensation Eligibility Status…Maria Xydopoulou 54 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM