Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
How to get the Name equivalents of RECRUITING_LOC_HIERARCHY_ID and RECRUITING_ORG_HIERARCHY_ID?I'm trying to get the Recruiting Type, Recruiting Location Hierarchy and Recruiting Organization Hierarchy from the Areas of Responsibility - Scope section, but I only h… -
Worker Termination Alert fetching all termination dates (Older ones also)Summary: Hello Everyone, We have developed an alert using alert composer for triggering notifications when termination transaction occurs. But the issue is, we are getti… -
Person Identifiers for External ApplicationsSummary: For some employees we have updated payroll id under Person Identifiers for External Applications in person management. Content (required): If I need to take tha…
-
How to distinguish the output file basing on the scheduling dateSummary: How to distinguish the output file basing on the scheduling date Content (please ensure you mask any confidential information): Hi, we created a BI report; the …
-
In person HCM Cloud OTBI Workshop at Oracle Reading UKContent In the last few years we have been running a popular HCM Cloud OTBI Workshop in EMEA to help customers get the most from their investment in HCM Cloud. We plan t… -
Report to get cost center and account from time management (OTL)Hi Experts, I have an requirement to fetch Cost center and account from time management page. Please check below navigation and Image to identify requirement. My Client …
-
Table for Payroll Transfer Status and Payroll Processing StatusWe need to get Payroll Transfer Status and Payroll Processing Status. Where are these information gets stored? Please share if you have any inputs. We have tried using p…
-
Query or table to get the employee work schedule as of the leave start dateSummary: Hi Every one, Do any one have any query to get the employee work schedule as of the Leave Start date . The requirement is when employee applied the leave, I nee…
-
Is it possible to present the data from first table as shown in second table using BI Report?Summary: This is the sample data we have and need to present as shown n Table 2 ****_ID ACTION_CODE REASON_CODE PERSON_ID EMP_TYPE ****_SEQ EFF_DATE PRIMARY_FLAG STATUS …
-
HELP - Hierarchical Columns - Query not returning dataSummary: When I query multiple folders within the Recruiting - Sourcing Real Time subject area no results are returned. Security is working correctly. Content (please en… -
Is there a way to get new and old value for an object in OTBI without logical SQL?is there a subject area that inherently stores old and new values of objects like department l -
HardCode a Value in OTBISummary HardCode a Value in OTBIContent Hi Team, How can we hardcode an LOV value of a field in OTBI analysis? Any samples or query with case? Thanks much. Regards, Kaly…
-
Manage Document Security ProfileSummary: We can View the Document Type Security Profiles however we would like to have a report or query to know which document type is associated to which profile. Or j… -
Get current and future termination EE records in OTBIHi, We are trying to build a demographic file that should pull the data of EEs as of system date and also future terminations in next 7 days. I have tried using the pref…
-
Observation Checklist Link not found in Oracle TablesHow is the observation checklist link/URL being created or generated to use for notification? Can it be found in Oracle tables? Where could the link be stored? Is there …
-
Report of everyone who reported to a terminated managerUsing OTBI, how can I pull a historical listing of all employees who had a specific manager in their management matrix over a specified date range?
-
Analysis on section comments and development goalsHi, I'm trying to build a report that displays for each performance document, the manager section rating for a specific section and the development goal name and success… -
Does anyone know how to pull this address (Manage Locations) in OTBI?Summary: How to pull address (Manage Locations) in OTBI? Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…
-
Rehire recommendation details are inconsistent in OTBI reportSummary: Need help with fetching data for Rehire Recommendation for terminated employees Content (please ensure you mask any confidential information): Hi, We have an OT…
-
How to add background color BIP excel template row wise in HCMHi Folks, May I know how to set the row background colour in the Excel template? Thanks Prakash Jayavel
-
Need a sample SQL for HDL Summary ReportSummary: I'm trying to create a HDL summary report, where I wanted to fetch the Submission Time, Finish Time and Elapsed Time which I'm unable to find the exact table. P… -
OTBI parameter issueSummary: Hi Experts, I need some assistance. I'm working on the Talent Profile Report and wanted to capture all the details in one report. I picked up multiple values by…
-
Retrieve Person addressesSummary: Do we have any package function to retrieve the person addresses? Please share. Content (please ensure you mask any confidential information): Version (include … -
per_person_secured_list_v view problemSummary: per_person_secured_list_v view is ignoring past events Content (please ensure you mask any confidential information): Hi, we have an admin user and she should h… -
How to add custom Parameter to PayslipSummary: Need to be able to print Payslip by Departments for specific Departments following a Pay Run Content (required): We have over 60 departments and some department…
-
SQL Query to get Value Set ListSummary SQL Query to get Value Set ListContent Hi Team, Could you share me any BI/SQL query to fetch the all list of Value sets using in HCM Instance like Dependent, Ind… -
How can parameters values be be linked to depend on each otherIs there a way the list of values in BIP report parameters be linked such that selecting values in one determines the values that show up in another especially when they…
-
OTBI: How can we run a report with the previous month start and end dateSummary: How can we programmatically run an OTBI analysis report with the previous month start and end date? Content (please ensure you mask any confidential information… -
Filter query using NVL not workingSummary Unable to save query when trying to use the NVL command with a logical sqlContent Hi All, I hope someone is able to help me with an issue that I am having. I hav…
-
Decimal number issue in etext templateSummary: Etext template - When I use if clause to compare two numbers without decimal positions is working fine, but it is not working if one of the number has decimal p…