Category 81
Discussion List
-
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 40 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 21 views 2 comments 0 points Most recent by Ramona Popescu-Oracle Reporting and Analytics for HCM
-
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…
-
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 12 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 62 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 201 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 13 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 42 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 394 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 40 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, Dinesh
-
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 12 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 2 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 12 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 35 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 13 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 47 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 240 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 14 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 24 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 53 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 23 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Parameters for Assignment Descriptive FlexfieldsSummary: Content (please ensure you mask any confidential information): Hello experts, we configured a DFF based on the doc on this link: https://docs.oracle.com/en/clou…
-
SQL to get Org Pay Method of PersonSummary: SQL to get Person Org Payment Method Content (please ensure you mask any confidential information): pay_org_pay_methods_f record holds the BASE_ORG_PAY_METHOD_N…Vijay Solanki 45 views 2 comments 0 points Most recent by Vijay Solanki Reporting and Analytics for HCM
-
which table stores area of Expertise and Area of Interest in Talent ProfilHello, I would like to know which table stores Area of Expertise and Area of Interest in Public Info in Talent Profile page. Attaching the screenshot for reference. Rega…