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 convert RTF template file from LF to CRLFSummary: Convert file from LF to CRLF Content (please ensure you mask any confidential information): I would like to ask on how to use the CRLF in RTF Template. Is it li… -
Values being truncated at 240 characters in the non-Excel output formatsHow to address those values being truncated at 240 characters in the non-Excel output formats. -
Transaction Console Subject AreaGood Day Experts, May I know what subject area to use to get processes from Transaction Console? The following are the process name: - Manage Salary - Change Personal In…
-
Balance trending reportWe have developed a Balance trending report for current & previous check dates. When we are running for a particular employee we are able to see data within 2 seconds, W…
-
How to make a BIP deep link opens in the same pageSummary: How to make a BIP deep link opens in the same page Content (please ensure you mask any confidential information): Version (include the version you are using, if…
-
Building a BIP Report for User Access TrackingSummary: Dear Customer Connect Community, I hope this message finds you well. I am looking to create a BIP Report using standard SQL to track user access within specific… -
User All Login Details within a specific periodHello Experts, Below query provides information on Last Login Date. For example, a user last logged in 1st Nov, this query will provide Last Login Details. However, is i… -
Payroll - Element Entries Real Time SA not returning car allowance Elements in the reportSummary: I have created an OTBI report with car allowance element entries for two Business units by using "Payroll - Element Entries Real time" subject area, each BU hav…
-
How to use outer join in OTBI AnalysisContent Hi All, I am using Worker Assignment Real Time Subject area and i have to pull only the person who has home phone number . The person who don't have home phone n… -
Employee displays in analysis for indirect leader they no longer report up toSummary: We've kicked off our workforce compensation cycle. I have an employee who changed managers earlier this year. The indirect manager they previously reported to i… -
Excel Output Formats is not generating any data and file size is showing only 7 KBSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
OTBI-How to combine Requisition other locations into one fieldSummary: I have created an OTBI report ( Subject Area :Recruiting -Recruiting Real Time) , and the Requisition Other Locations are displayed in multiple lines in output …
-
Combine multiple Ethnicities in OTBI "Two or more races"Summary: Per the below - we have some Team Members that classify with more than one Ethnicity and the "Two or more race" option is no longer available in Oracle. This is… -
SQL Query to fetch value set details with respect to modulSummary: Hi All, I want to fetch the value set details with respect to module, can anyone help me with table name or query? Version (include the version you are using, i…
-
Seniority Dates V2 to V3 TransitionContent Hi all - my search skills are seriously lacking, or there is just no information out there ... what work is involved in transitioning from V2 to V3 for the new s… -
Active Candidate Pools OTBISummary: Dear Community, We would like to create an indicator that counts all active candidate pools within our system. However, while exploring the Recruiting - Recruit…
-
OTBI report for finding position wise incumbants including candidates with Job offersSummary: We are looking for an OTBI report to fetch all incumbents of a given position along with candidates with active Job offers already given. This report will help … -
if we can run an OTBI report that shows when a password has been reset as well as an email updated?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Adding Learning Comments to Criteria is causing my analysis to fail to process ResultsSummary: I have a report using Workforce Learning - Learning Records Real Time that works until I add "Evaluation Questionnaire"."Answer Comments" to the Criteria. Then …
-
Write-back errorSummary: Write-back error - An error occurred while writing to the server. Please check to make sure you have entered appropriate values. Content (please ensure you mask…
-
Timing issue for an SQL querySummary: Content (please ensure you mask any confidential information): Hello experts, we built a query to retrieve the organization manager assignment id for a specific… -
Query to fetch the individual Manager Rating and Employee rating corresponding to each Goal.Summary: I am creating a custom report to get the employee and manager ratings for each performance goal. I got the summary ratings from table 'HRA_EVAL_RATINGS'. But fo…
-
Can someone please help, on where to find this value in oracle Tables?Hello can someone please help on where to find this field on HCM Table and Views? UI Navigation is Benefit Administration> Plan Configuration> Rates and Coverages> Varia…
-
Report to get Original Date Earned of element entrySummary: Report to get Original Date Earned of element entry Content (please ensure you mask any confidential information): Hi Team, Greetings! Does anyone have the repo… -
Need sample query to fetch list of document records for dependentsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to get rid of a trailing space CHR(32) at the end of a OTBI folder name or in a directory path.Summary: The site at: https://community.oracle.com/products/oracleanalytics/categories/otbi where this probably should go is defunct, so I am posting this here. I have f…
-
OTBI filter show no dataSummary: Hello experts, we have a report for recruiting requisitions, but when trying to search in the values we get no data.. the list of values: SELECT DISTINCT IRB.RE…
-
Need Join Condition column for tablesSummary: Hi team, I have two tables to join hrc_dl_message_lines hdml and HR_ALL_POSITIONS, where i need position code from HR_ALL_POSITIONS table by joining with below …
-
How to create BI report for checklist task type "Report" which accepts the parameter as AllocatedCheSummary We have requirement that one of the Task performer (which is last task in checklist) wants to review the report with all other task performers input to DFFs and …
-
table name to fetch 'Write to person profile on completion' In learningSummary: Which table stores information about the Field 'Write to person profile on completion' In learning Navigation :- Course ->Skills and qualification -> manage -> …