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
-
OTBI field results cut offSummary: When I run the attached XML in OTBI, the field results in the vendor name are being cut off. https://us.v-cdn.net/6034893/uploads/MND2YD7J3DWH/element-entries-w… -
Viewing reports history submitted by the userSummary: Our target is to see the reports history submitted by all the users in the fusion HCM. Please advise accordingly how can I retrieve this information. Content (p…
-
Seeded Deferred Compensation Overlimit Balance Exception report has incorrect formula valueSummary: Balance Exception Report for Deferred Compensation Overlimit with exception name 401k Over the Limit has incorrect formula value Content (please ensure you mask… -
Cannot open OTBI Report Workforce Compensation subject areaSummary: Content (please ensure you mask any confidential information): Hello experts, when opening the attached OTBI report the system doesn't return any value. However… -
ELIGIBLE WORKERS FOR COMPENSATIONSummary: How can I extract the list of workers that concur to determine the number of eligible in the fields ELIG_COUNT_DIRECT of CMP_CWB_SUMMARY table?
-
Facing issue to fetch proposed value of Pending TransactionsWe are trying to fetch proposed valued of pending transactions. Transaction is on Assignment change, I have written the following code but getting ORA19011: "Character s…
-
Reading offering, functional area and setup task using querySummary: For an integration, looking for a way to map Offerings/Functional Areas and available Setup tasks. Using OTBI, is it possible to write a report/query to get the…
-
Extract future task assignment in transaction approval flowHello experts, I know that we have the ability to query current and past approvers for an approval transaction (hrc_txn_data / fa_fusion_soainfra.WFTASK), but is there a…
-
Job Offer Letter - RTF template If Condition for hire dateSummary: Hi Everyone, Does anyone has experience to write the condition rule under the RTF Template for Job Offer Letter (BI Pulisher), I would like to get some advise o…
-
Dynamic file name generation for data model reportsSummary: I have requirement for dynamic file name generation which will be like the file name with year or period and date extension .I have included the sql code at the…
-
How to capture a field with blank spaces at the end?Summary: We are trying to create an audit report that will identify email addresses that have extra spaces in them. Any idea how to capture those outliers in a report? C…
-
OTBI report for Offboarding Journey also pulling rehires along with termsWe are trying to create a simple response and count report for Offboarding journey (for voluntary terms only) . We have added Workforce management - Checklist Real Time …
-
BI Report to get the previous and present records of job, salary amount, department and grade.Hi Team, I need a working sql query to get the previous and present records of job, salary amount, department and grade in BI Reports. Parameters: - Action Code, from da…
-
How can I populate longitude and Latitude in OTBI report?Summary: Hello, I am here to inquire about 25B new feature by the name: New Address Attributes Added to Worker and Location Dimensions. I am trying to create an OTBI rep…
-
Report on Deleted Interview Feedback - RecruitingSummary: We have a requirement to track the Delete Feedback action on Candidate Job Applications. Has anyone created a report to do this? Content (please ensure you mask… -
Fusion Quarterly Upgrade to export in ExcelPlease use the below URL to chose and send to customer in excel format. https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/readiness/app/index.html?view=040…
-
Goals Created or Not Created by Country CodeSummary: When I use the union report suggested by Oracle/the community forum the no of workers without goals is not returning enough workers Content (please ensure you m… -
Report on candidate log-ins for experience siteSummary: We have a requirement to identify the last time a candidate logged into their candidate profile through the external career site. Is there a reportable field in…
-
How to report on comments for Checklist QuestionnaireSummary: In OTBI, Workforce Management - Checklist Real Time, I am trying to find the column that shows what comments were made in the "Comments" field in the questionna…
-
Prompt values to be displayed on Direct and Indirect Reportees of manager selected.Summary: We have report which contains prompt Manager Direct Reportees Manager Indirect Reportees Job Name When i logged as a manager Prompt 1 will display all the direc…
-
RTF template: hide empty column in pivotGood day, I created a custom RTF template that displays a pivot table. The field "BASE_ELEMENT_NAME" lists different elements but it's empty for some employees and, as a…
-
Report for specified pay period that shows time card hours paid and costsSummary: I need a report that can be run by department to show hours reported and the associated pay costs thru payroll. I am attempting in OTBI with Payroll Run Real ti… -
Payroll DD/Taxes Report SQL HelpWe have a New Hire Direct Deposit/Tax report that captures employees who have not completed DD and/or Taxes. How would I update the query to pull all new hires/rehires (…
-
User is unable to access job profileSummary: When the user is trying to access "Job profile & OPS dashboard", they are unable to access the Job profiles dashboard. The role is restricting the users to not …
-
Need fetch past date absence plan balanceSummary: Need to fetch past absence balance Content (please ensure you mask any confidential information): My requirement is to perform inbound integration via OIC from …
-
Is it possible to report on element config? (e.g. is it taxable, pensionable etc)Summary: I'm looking to create an analysis which shows me the configuration of each element in terms of which have been set as taxable, pensionable, which payrolls they …
-
Query to fetch all the eligibily profiles linked to Benefit PlanSummary: Hello, CC! I am in need to biuld a query that given certain Benefit Plan I need to get all the Eligibility Profiles that is attached to it. Ex: I have a paramet… -
Is the Release Statement to Workers flag available in OTBI and BI Tables?Summary: Content (please ensure you mask any confidential information): Hello experts, is the attached field available in Oracle HCM Reporting subject areas or BI Tables…
-
BIP Report timing out for select Associates in-consistentlySummary: This report is run by about 165 associates. Almost 80% of runs are successful where others are getting “Time out error” for rest. It’s not consistent, though. C…
-
BI Report for Job Requisition Approval FlowSummary: BI Report for Job Requisition Approval Flow containing full approval flow related data. Content (please ensure you mask any confidential information): Hi expert…