Get Started with Redwood for Oracle Cloud HCM Begin Now
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
-
Can't get Scheduled Hours of employee that shows on OTL Time Card into OTBI ReportSummary I need to get field Scheduled Hours per week that shows on employee time cardContent Hello , I assigned a work schedule to worker and I need to get value of Sche… -
OTBI - Store Analysis or static Briefing booksSummary: Can we use OTBI to store month-end snapshots of static data to refer back to without exporting offline? Content (please ensure you mask any confidential informa… -
Query to get Employee Bank Account Details not tagged to personal payment method in Oracle HCM CloudSummary: Query to get Employee Bank Account Details not tagged to personal payment method in Oracle HCM Cloud Content (required): Hi All, We got the requirement to extra…
-
-
most recent hire dateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Human Capital Management - Approval Notification Archive Real Time - Transaction ID missingSummary: Hi, I am trying to create a report using Human Capital Management - Approval Notification Archive Real Time subject area. I am unable to fetch transaction ID wh…
-
Moved: Can we restrict managers doing calibration outside of Performance distribution?This discussion has been moved. -
How to Restrict groupings with 0 from display in HR dashboard chartsSummary: Restrict groupings with 0 from display in HR dashboard charts Condition used in column Level: CASE WHEN "Workforce Trend"."Termination Headcount"
-
Fetch Employees not a part of Talent Profile SectionSummary: We have created a Custom Section using the Skill Template under the Talent Profile Page. As followed fields HPI.ATTRIBUTE1 AS TRAINING_NAME, HPI.ATTRIBUTE2 AS B… -
OTBI Payroll Reporting - How to Generate Employee Data as of Payroll Period & not Current DateWe currently have an OTBI report using the Payroll - Payroll Balance Real Time subject area. Currently, if we run this report it pulls in the employee Business Unit as o… -
Query showing the values on the current Tax Calculation CardsSummary: I need BI publisher reports that show the values on the current Tax Calculation Cards for all active employees including their hire date. The values of greatest…
-
Community of a learning course - OTBIDear all, We would like to report the community in which a COURSE has been integrated to. In my following example : for my COURSE "English language training", I would li…
-
Learning Completion date of a course under specializationHi All, I am not able to get courses under a specialization to get its completion date. Any help is appreciated? Thanks-Praveen
-
Due Date dashboard prompt in OTBI gives precision_scale errorSummary: OTBI Learning Dashboard prompt for Due Date set to between gives a precision_scale error across all analytics Content (please ensure you mask any confidential i…
-
Override the Online Delivery Option for the PayslipSummary: I need help on set ups for overriding an employee's Payslip online delivery preference when they are terminated in Oracle Fusion Cloud. We are currently on 24A.
-
Sequence NumberSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
HcmTopModelAnalyticsGlobalAM.PositionAM.PositionPVO dSummary: HcmTopModelAnalyticsGlobalAM.PositionAM.PositionPVO extract giving duplicate records Content (please ensure you mask any confidential information): HcmTopModelA…
-
How many ways do I restrict the BIP reports and OTBI reports?Summary: How many ways do I restrict the BIP reports and OTBI reports? Content (please ensure you mask any confidential information): Hi Experts, Please tell me how many…
-
can we perform any arithmetic operation like sysdate - 20 in alert templateSummary: 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 capture the selected LOV values.Hi, Need help in achieving to print multiple LOV values selected. Its throwing the missing parenthesis select (:LE) from dual.
-
Merge Lead Creation Date & Opportunity Creation DateSummary: We are having a scenario to populate total no of Leads & Opportunity created on Monthly basis. For FY2024, On monthly basis Jan'24, Feb'24 , Mar'24 etc . . It s…
-
Annual Leave Encashment Final DisbursementSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Combining two rows of data into a single columnSummary: Combining two rows of data into a single column IF an employee has two degrees the expectation is to print it into a single row of data. For example Employee 12…
-
Not able edit the OTBI reports for developed by others usersSummary: Not able edit the OTBI reports for developed by others users. Can you please suggest Content (please ensure you mask any confidential information): Throwing an …
-
Inherited Role Audit detailsSummary: Hi Team, Need a Role report that gives you the details for scenario: Role A is inherited by Role B(Employee Role) and assigned to Person A. Need to know below: …
-
Passing real time binding parameter to OTBI as presentation variableContent I have a requirement to add OTBI report in Termination Page UI which will capture three Real-time Binding Parameters (Person ID, Termination Date & Termination N…
-
OTBI how to include manager department hierarchy in an analysisI have a need to include the Managers department hierarchy in an analysis. The managers department hierarchy does not appear to be a set of standard fields in any of the…
-
Need help finding field in OTBI reportSummary: Hi Team, We have requirement to create a report to pull Progression Grade Ladder’s details. We created OTBI report using Workforce Management - Grade Rate Real …
-
How to export HCM Audit Reports in OTBI?We couldn't find where to export seeded Audit Reports. Does anyone one how can we access? -
Someone Deleted the Custom folder from my Username. Is there any way to find the IP address or HOSTSummary: Someone used my credentials to login into UAT POD and Deleted the whole custom Folder. Is there any way to find the IP or Host of the user so that I can find wh…