Category 81
Discussion List
-
Query to get Requisition Template name in ORCHi, I have requirement to get Requisition Template name from Basic Information. navigation --> My Client Group - Hiring - Requisition (number) - Details - Basic Informat…Rajdeep Chavda 250 views 10 comments 0 points Most recent by YASHWANTH GOWDA H R Reporting and Analytics for HCM -
Analysis of employees assigned performance goals and not assigned performance goals for a goal plan?I have created an analysis using the Workforce Goals - Goals Status Overview Real Time subject area. I have selected the following subject areas and applied filters (scr…Adrian Clarke 51 views 2 comments 0 points Most recent by Adrian Clarke Reporting and Analytics for HCM -
How to default the Location of Logged In User in Dashboard PromptSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Narendar Rao Naineni 21 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
View object cannot be found for HCM table PER_POSITION_EXTRA_INFO_FWe were using the oracle mapping document "Rel13_23D_BICC_HCM_Database_Mapping_with_ViewObjects.xlsx". Looking for the corresponding VO for table PER_POSITION_EXTRA_INFO…Ian Cosinas 91 views 3 comments 1 point Most recent by Chandra Chappidi Reporting and Analytics for HCM
-
Running an AOR report that includes who is assigned to the AORSummary: Is there a way to run an AOR report of who is assigned to each AOR and include whether the assignee is included or excluded from contacts. Content (please ensur…Angelique Cole 44 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can we restrict Benefits/Compensation Specialist from accessing Element Entries?Summary: Element Entries in BI Publisher Reports Content (required): For a client, with different legal entities, in reports we are making use of secured views at assign…VDoolhur 23 views 2 comments 0 points Most recent by Ramona Popescu-Oracle Reporting and Analytics for HCM
-
Protecting Sensitive Data in Custom ReportsWhat is the most effective way to provide managers with access to custom reports without exposing sensitive employee data, such as ethnicity, date of birth, home address…Rashi_Churiwala 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
SQL to get the list of permission assigned to Dashboard SectionSummary: SQL to get the list of permission assigned to Dashboard Section Content (please ensure you mask any confidential information): Version (include the version you …ISHWTW 2 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Public Holiday Report in BI PublisherSummary: Anyone has a sample SQL Code for the Public Holiday Report using BIP? I am currently having trouble connecting the PER_CALENDAR_EVENTS_VL to Node IDs to get the…User_2025-02-04-07-19-57-588 61 views 3 comments 0 points Most recent by Robert A Reporting and Analytics for HCM -
SQL Query for Learning Plans and ProgramsSummary: Hello I need a query that gives the following attributes in the Learning module: Program Name Plan Name Plan Profile Name Plan Profile Creation Date Content (pl… -
Element Entries Subject Areas Not Working since Patch 24cSummary: We are patch testing 24c and a few of the subject areas are not producing any data. They are functioning correctly in Production, but not where the patch has be…Mark Stoker 203 views 17 comments 0 points Most recent by Danna Spencer Reporting and Analytics for HCM -
Is there any seeded report that employees can use to list personal data stored on them?Summary: We have a request to make available in ESS a report to list all personal data stored by the company on the employee. Is there any GDPR seeded report for this? T…Lluis 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report for Screening Services on Requisition TemplateWe are trying to report on screening services (Assessment and Tax Credit) on job requisition templates but when we output fields from Job Requisition Template - Screenin…Samiir S 43 views 2 comments 0 points Most recent by YASHWANTH GOWDA H R Reporting and Analytics for HCM
-
OTBI subject area for Document of Records descriptive flexfieldsSummary: Content (please ensure you mask any confidential information): Hello experts, we created custom fields within document type and we mapped them in OTBI. Where ca…Valerio Curzi 415 views 6 comments 0 points Most recent by Becca Edwards Reporting and Analytics for HCM -
SQL to Show Which Pay Frequency is Associated to Which Legal EntitySummary: I am tasked with producing a mapping document of which Pay Frequencies are associated to each legal entity. I can find the Legal entities in "HR_LEGAL_ENTITIES"…Mickey James 43 views 2 comments 0 points Most recent by Mickey James Reporting and Analytics for HCM
-
Table name for Assign As column in learning pageHi Experts, Can someone please help me with the table name for 'Assign As' column. Thanks & Regards, DineshDinesh Jaini 11 views 1 comment 0 points Most recent by Dinesh Jaini Reporting and Analytics for HCM
-
Person Seniority Real Time not showing resultsSummary: The "Person Seniority Real Time" subject area is not returning any results, even though we're currently using the Seniority Dates V3. Does anyone have a solutio…Martijn van den Berg 11 views 2 comments 0 points Most recent by Martijn van den Berg Reporting and Analytics for HCM -
BIP notification sender nameSummary: Hello Experts, We have a requirement where we need to update the Sender name of the notifications being sent thru BIP, for example, Payslip notifications or not…AprilleLyn 6 views 3 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
call bip report from Absence page and pass person_id as parameterSummary: I need to call bip report from Absence page and pass person_id as parameter Content (please ensure you mask any confidential information): Version (include the …Farah Alajou 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
What is the table name stored allocated task code?Hi I need to get the allocated task code but I can't find it in PER_ALLOCATED_TASKS and PER_ALLOCATED_TASKS_TL table, I can find only TASK_NAME but can't find TASK_CODE.…Mohamed Salah 22 views 5 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Need table name for Legal Employer level work schedulesSummary: Need table name for Legal Employer level work schedules: Example: We can see the default level schedules at Planned Schedules in Time Management. Content (pleas…GajavalliKoteswararao 11 views 1 comment 0 points Most recent by Kanimozhi N-Oracle Reporting and Analytics for HCM
-
ORC - Candidate Details Report with phone numberSummary: Looking for the column or field phone number that has both country code area code and phone number rather than displaying it in separate columns In the UI, its …ikc 41 views 3 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Open a PDF in a new App or Quick actionIt is necessary to create an APP or Quick action that redirects to a PDF that the client provided us. I'm using the sandbox structure tool. But there is no option to upl…Brandon Martin-Oracle 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Restrict BI Author Role to only create OTBI Reports, they should not have ability to edit BI ReportsHow to restrict the user having BI Author Role to only create & access OTBI ORC Subject areas reports only. Not having access & edit BI Reports for other work area like …Twinkle Dudani 41 views 6 comments 0 points Most recent by Regie Mercado Reporting and Analytics for HCM
-
tempContent (please ensure you mask any confidential information) Version (include the version you are using, if applicable): Code Snippet (add any code snippets that suppor…Satheesh Nesamani 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
How to transpose Rows to Column in OTBI Compensation Detail ReportSummary: you can use a pivot table and have salary basis as column and value in the metric section, you should apply aggregation rule like min/max on the metric values. …Jasmine 241 views 20 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
We need OTBI column name in Absence as per below image to get leave applied dateSummary: We need OTBI column name in Absence as per below image Type is Adjustment. Content (please ensure you mask any confidential information): Version (include the v…AjayKumar Maddipati 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
element entry secured views queryIs there a query that contains a table to be used to get only the secured list element entries based on the element security profile. Similar to the table per_person_sec…bervin13 23 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to change the Query Time Out value in BI Published reportHi, How do we change the "Query Time Out" value in BI Published report It is available in Properties of the report data model , however maximum limit is 180000 and if i …Preeti Khondre 52 views 8 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Report not pulling correct salary infoSummary: We have a requirement from our HR department to build an AAP report that includes salary information for employees. We've tried building this report using a few…Henry Imgrund 24 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM