Global HR
Discussion List
-
Conditional Formatting in OTBI AnaylsisSummary Conditional Formatting in OTBI AnaylsisContent Hello, I am using conditional formatting to show when a field is NULL by changing the color of the field box. I ha…Shanna Oppenheim 59 views 7 comments 0 points Most recent by Ivony Ann Paula Salango Reporting and Analytics for HCM -
OTBI Questionnaire text column how to set the questions inproper to order ?Summary: Hi Team, We were developed new report by using Check list real time subject area to get onbaording Questionnaire text of employees but issue questions are inpro…AjayKumar Maddipati 32 views 12 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How to sort the Questions in order using OTBI report?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to display the Questions under the Questionnair…Welsey 74 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
3rd Substring from a Field in OTBISummary: Need 3rd Substring from "Job"."Job Name" Content (please ensure you mask any confidential information): I have "Job"."Job Name" field and the data looks like "U…Pradnya_Pampatwar 2 views 2 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM -
Need 2 Date Fields having Case or Filter functionality in OTBI ReportSummary: Interim Review Date ("Performance Document"."Performance Document Period Name" like '%Interim%') and Final Review Date ("Performance Document"."Performance Docu…Pradnya_Pampatwar 42 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
BIP report or data model for fetching the data of all the employees with their Hire date, terminatioSummary Can anyone help me with BIP report or data model for fetching the data of all the employees with their Hire date, termination date, rehire date along with depart…User_2025-01-29-01-34-30-592 198 views 2 comments 0 points Most recent by Becki Willard Reporting and Analytics for HCM -
Pull birthdays in the next 90 days in OTBI.Summary: Hello all, How to pull birthdays in the next 90 days in OTBI. The logic I currently use is to pull birthdays that fall between WEEK OF YEAR ( CURRENT_DATE) and …
-
How to calculate Age with Person Date of Birth and Effective Date variableSummary: Calculating Age using Person Date of Birth and the Effective Date variable based on a date entered in the prompt. Content (required): I need to calculate Age us…GJ79 568 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Remove Year from Date in OTBI ReportSummary: I need to set up a scheduled report to go out and not reflect the year of the birth dates. I know how to change the format in the Column Format, but once the re…Jessica D 84 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
how to read webcenter files using python script and extract informationcan we read the files which we uploaded through bi reports bursting into webcenter servers. while i'm the downloading the files in the webcenters they are not readable.Dara Nagasai 11 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
How to customize change personal information workflow notification?Summary: How to customize change personal information workflow notification? Content (required): Hi All, Need to customize the change personal information WF notificatio…
-
is there a way to get data from tables?Apologies for the basic question but is there a way to get data from the Geog Trees, calendar events, work patterns and work schedules please? This is from the backgroun… -
BIP report to fetch employees that are included in Automated Grade Step ProgressionSummary: Other than GSP_ELIGIBILITY_FLAG from PER_ALL_ASSIGNMENTS_M, is there any tables which can identify employees that are included in Automated Grade Step Progressi…
-
Import Oracle Taleo Recruiting to HCM Fusion.Summary: Hi Team, Could you please let us know, Candidate Imported form Taleo to fusion through "Import Oracle Taleo Recruiting Cloud Service Data" process, in which tab…
-
Oracle OLM - Business wants to track a user and his assigned course progress by date wise break-up.For ex: ******* 1. Maria John did a course on "Sexual_Harassment". She started the course on 1st Jan and stopped after an hour, again continued on 2nd Jan for an hour an…
-
Requirement to have a report that provides details of changes made to UDTSummary: We have a requirement to have a report that provides details of changes made to User defined tables. can anyone please help us on this requirement? Content (ple…Jagadesh S 22 views 2 comments 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM
-
Why Oracle did not create Per_All_Assignments_D View In HCM CloudSummary: Dear All, Since we can't create any objects in the Cloud Database like Views, why oracle did not bring one of the most useful HR Assignment view used on the EBS…Alaa Abu Hijleh 21 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Payroll run exclusion GroupSummary Identifies employees who are in an exclusion group and will not be included in the payroll run.Content Hi, Can you please suggest if Payroll exclusion group is a…User_2025-01-30-20-59-13-989 40 views 4 comments 0 points Most recent by Nitin.Goswami Reporting and Analytics for HCM
-
How to use a dashboard prompt in Case When query for a fieldSummary: Content (please ensure you mask any confidential information): We have a custom field in OTBI report that uses Person Number as a prompt on a dashboard. Below i…Giuseppe Cannova 33 views 1 comment 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM -
Valid grades list is not displaying on few JobsSummary: Hi Team We noticed that for few Jobs on Job details page Valid grades list are not getting displayed but for few Jobs we see grades list is populating . I have …Liyaquath 33 views 4 comments 0 points Most recent by Julian Challenger-Oracle Human Capital Management -
Is it possible to authorize manager-based reports?We added the SQL reports we prepared to the spring board screen and we want to make an authorization here. But is it possible to make it manager-based rather than person…Cansel Karasoy 14 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Provide access to Transaction console without actionsHi, I want to provide view only access to Transaction Console ,I have followed instructions as in , however i dont see the transaction security while adding the Data sec…
-
Document of Records OTBI Subject Area not displaying dataSummary: Document of Records OTBI Subject Area not displaying data. Do we need to run any processes? Content (please ensure you mask any confidential information): Tryin…
-
is there a REST API which will give list of all nationalitySummary: Hi Team is there a REST API which will give list of all nationalities ? Please help Content (please ensure you mask any confidential information): Version (incl…mudassirsOrc-Oracle 21 views 5 comments 0 points Most recent by mudassirsOrc-Oracle Reporting and Analytics for HCM
-
-
How to get "Person Type" and Assignment Details from Fusion TablesSummary: Hi All, We are seeing a difference between the "Users license Usage" numbers in the Usage reports for HCM Base cloud Licenses and number of "actual user report …
-
Alert based on Assignment StatusSummary: is there any way we can add this field assignment status in filter criteria under alert composer. Content (please ensure you mask any confidential information):…
-
how to send a custom email when employee submits resignationwe have a requirement to send an email to employee when he submits resignation and also we need to send another email as resigantion approved to employee with the custom…Dara Nagasai 15 views 2 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM
-
Export audit logs through OTBI\BI publisherHi, need assistance on how to pull mass audit logs from the OTB?I\Bi publisher. thank you in advance.Gal Shani 31 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Query for Person Security Profile ReportHi team, we need a person security profile report. can someone help me to provide the query of this if anyone has already gone through this type of requirenment. Thanks!Pushpendra Patle 14 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM