Global HR
Discussion List
-
Report to get employee default expense accountSummary Report to get employee default expense accountContent Hi is there any report which can get what is the default expense account attached the employee please? this…User_2025-01-29-02-09-34-137 104 views 13 comments 1 point Most recent by Isabela Radivoi Reporting and Analytics for HCM -
Identifying global transfer records, hire/rehire records from per_periods_of_serviceSummary: Identifying global transfer records, hire/rehire records from per_periods_of_service Content (please ensure you mask any confidential information): Hi All, Empl…Gayathri K M-Oracle 676 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Is there a way to get date tracked data for Per_periods_of_service tableI'm trying to figure out the date when the "Actual Termination Date" is changed, but Per_periods_of_service table has top of the stack record only. Is there a table that…
-
We can able to load the data in User-Defined Table Business objects but not able to see in frontSummary: We can able to load the HDL data but we can't able to see the data but in backend we can able to see the data. Note: If we entered manually in UDT then we can s…Ravindr-Oracle 70 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Bring back Headcount Data from 12 months agoSummary I want headcount data from 12 months agoContent I have a simple report that sums headcount up and gives me numbers for today however I want to return the numbers…User_2025-01-29-21-02-12-466 122 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Passing values from the UI to parameters in a BI Publisher reportSummary Looking for a method of passing values shown in the UI to parameters in a BI Publisher reportContent I have a requirement to filter a BI Publisher report based o…Ron Nelson 194 views 14 comments 0 points Most recent by Jaison Joseph-Oracle Reporting and Analytics for HCM
-
How to make hyper link in one of the column values in BIP reportSummary: I have to establish link between MEANING Column values to the respective bip report . Thanks For Your Help!! RavindraRavindr-Oracle 41 views 3 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Not showing data in OTBI for other line manager type, how can we fix this?Summary: Right now, individuals with the manager type "Cross-Functional Manager" can't access any data about their direct reports in OTBI. The UI is behaving correctly; …Martijn van den Berg 22 views 2 comments 0 points Most recent by Martijn van den Berg Reporting and Analytics for HCM -
Create an OTBI analysis based on Personal Details Quick actionSummary: We have created a new DFF field in Biographical info tab in the Personal Details Quick action page. Content (please ensure you mask any confidential information…Ayesha Iroshani 31 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Need a sql to get "extra info" on "position details" pageHi All, I'm trying to find SQL tables and joins behind getting "Regulatory Licence Information" under Extra Info Section of Position Details. Navigation : Set up and Mai…
-
Org levels missing from the OTBI report for the inactive treeWe recently did our restructures and created a new version of the tree. The old version end on 2-Jul and the new version starts from the 3-Jul. Now the Org tree has leve…Girish Bhatia 33 views 7 comments 0 points Most recent by Girish Bhatia Reporting and Analytics for HCM -
SQL to retrieve employee name,person number,department name and department DFF detailsSummary: SQL to retrieve employee name,person number,department name and department DFF details Content (required): Hi All, Please share SQL to retrieve employee name,pe… -
How to create User defined table (UDT)Summary: How to create User defined table (UDT) with screen shorts. Requirement: i want to store the below data in User defined table & which table can store this inform…Ravindr-Oracle 11 views 3 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
How to FTP file upload to UCM content server via ODISummary: Hi Folks, Content (please ensure you mask any confidential information): How to upload FTP files to the UCM content server via the ODI tool Version (include the…Prakash Jayavel 35 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to return Geographies using OTBISummary: We want to return Geographies (State, County and City) using OTBI. But the data should not return the geocodes but should return the actual name. Ex: State: LA …RenzelkeithCoquia 2 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
HCM native datamodels/bipSummary: are there another schema.table wich sample reports delivered in HCM Cloud are stored to extract a list of them ?? Content (please ensure you mask any confidenti…
-
csv output giving multiple date format while using etext templateSummary: I have built a report to display a date column in dd-mm-yyyy format using etext template. the report output is displayed in text or csv. In both the cases when …Nisha_Hegde 74 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to filter the column values by another column?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to filter employees which have these Response A…
-
Facing issue with top manager type in OTBIWe have created otbi report using top manager type. Multiple managers are visible in OTBI, but in system only 1 manager is tagged. Is there any way we can pick the activ…Pranay_Soma 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to create a record in the position flexible field from postman with Oracle Rest API?Hi, I want to send a record to the flexible field opened on the position with the help of Oracle standard rest APIs. But when I examine the oracle document, I cannot see…Cansel Karasoy 31 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Workforce Management - Worker Assignment Event Real Time - Assignment FTESummary: We want to achieve below requirement using OTBI. Can we get FTE and leaving reason from the same SA or need to join other SA to get the data ? Can we get Assign…Jatin_Maru_1 21 views 2 comments 0 points Most recent by Jatin_Maru_1 Reporting and Analytics for HCM -
xmlpserver: RTF Template for quick action Change AssignmentWe were able to locate RTF templates for Person Management changes on the xmlpserver, but we were unable to locate quick actions like Change Assignment RTF templates. Th…Ashok Kumar Sharma 13 views 4 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
Quick Action Employment Start DatesSummary: Report to identify details when Quick Action Employment Start Dates is used Content (required): Need a report that shows when a Hire Date is changed when using …JHaden3 42 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get previous experience of employee plus current company experience in OTBI or BISummary: Hi Team, we have requirement to get the previous experience of employee in OTBI is possible. In BI , we used (ff_user_column_instances_f fucif.value as experien…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Maintain Meta Model and IndexHi, We have a Maintain Meta Model and Index process in error in scheduled processes. This was scheduled by someone who is now a leaver, so may be the reason for the erro…Daniel.McDermott 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Vacant Positions in SQLSummary: Hi I have had a request through to list vacancies per Position Code/per CC. But instead of having one row per vacant position, it needs to have as many rows as …
-
How to resize Rows and Columns in OTBI reports?How do I set column or cell dimensions to have a consistent format for my report?
-
SQL count of vacant positions in each department for the last three monthsSummary count of vacant positions for each department group by the last three monthsContent Hi, I am trying to write a sql in BIP to get the count of active vacant posit…
-
How to Get XLE_LE_ADD_INFO in HCM OTBI Subject Area?Summary We have a DFF with module Legal Entities and the Legal entity GL code has been created on Attribite1 of XLE_LE_ADD_INFO FlexfieldContent Hello Friends, We have a…Mansur Khalil 239 views 8 comments 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Scheduling OTBI report with a conditionSummary: I'd like to be able to schedule an OTBI report but restrict the data that is sent to the recipient using a condition. Content (required): Our OTBI employee stru…