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
-
How to obtain a drill down OTBI bar chartSummary: How to obtain a drill down OTBI bar chart Content (please ensure you mask any confidential information): Hi, we created a dashboard based on a OTBI Report. The … -
Is it possible to use an EFF in a case statement in OTBI?Summary: I am working on a report trying to calculate days between LOA End Date and the Estimated RTW Date (EFF) in the system. The case statement is producing an error,…
-
Report to fetch void payment dateSummary: We are looking for a report with output similar to Payment Register Report but with an additional column to display the actual Void date. Content (please ensure…
-
Extract name field from transaction console pageTransaction table for extracting the Name field in transaction console. Please assist
-
BI Publisher Sending a report to FTP Server with SSHSummary: How do I schedule a report to be delivered to a destination configured with SSH authentication? Content (please ensure you mask any confidential information): H…
-
Issue with formatting totals in OTBI Analysis TableSummary: I have a simple analysis coming out of the Benefits - Enrollments Real Time Subject Area. I have set the Department Name as a Table Selection. I have formatted … -
Fast Formula for Matrix Manager in Compensation Plan HierarchySummary: Hi, We have the below requirement for Compensation hierarchy: If Country of the Employee is Poland, the hierarchy should be the other manager type (Comp manager…
-
Time card details query in Fusion OTLSummary: Hi All, We are creating one report to get the Time card details. we are looking for 'Time type' and 'Override dept costing' fields. We couldn't able to find the…
-
Drill Down in the OTBI does not work correctlySummary: Drill Down in the OTBI does not work correctly Content (please ensure you mask any confidential information): Hi, we created an OTBI report. The extracted data …
-
Benefits Override Eligibility reportSummary: Is there a way to report on the employees and benefits that have been Overridden using the Override Eligibility in Benefits please. Content (please ensure you m…
-
OTBI skills proficiency levelHi all, We need to take the gap between the Proficency Rating and the Required Proficency Level for the employees. We are looking for this fields in the OTBI: We are usi…
-
How to get the assignment name for an OTBI analysis?Summary: I need to know which subject area and fields I need to use, to get the employee assignment name for an OTBI analysis. Content (required): Assignment name Versio…
-
AAP Promotions ReportSummary: We have a requirement to report on employee promotions. This report should export on one line what their previous job/position was, and what their new/current p…
-
Making All value selectable in date parameter definitionI have an absence start date parameter in the report and its definition is as seen in the screenshot below. It works like this: First, the registry number is selected, a… -
Learning Management replaced by the Learning Record subject areaSummary: Can't find mappings for the new Subject Area Content (required): Goodmorning, in reference to "APRIL MAINTENANCE PACK FOR 21A" document which states: "Be aware … -
How to Encrypt and Send BIP report output from oracle HCM cloudSummary: There is a need to Encrypt a BIP report output to 3rd party through SFTP. Please let us know the possibility and how to accomplish it ? Does BIP provide any def…
-
People Leaders Workbench DocumentationSummary: Hello, A team member was at Oracle Cloud World and asked me to research how to get more information related to the People Leaders Workbench (see screenshot). I'… -
How can I get the Home Address from the Person Management\Person area on a ReportSummary: I have the mailing address, but need the home address. Content (please ensure you mask any confidential information): Version (include the version you are using… -
SQL query will not return an expected row in larger reportSummary: I have a report that returns employees who were referred and by whom, connected to their application and based on the referral to a specific job. There is an od…
-
What table holds the future incumbents details?I am trying to pull the person number of a future incumbents but i'm not sure what table holds that info. Does anyone know? TIA. 😊
-
HCM Experience Design Studio ReportSummary HCM Experience Design Studio ReportContent Does anyone know if there is a Subject Area or Table that contains the Rules created in the HCM Experience Design Stud… -
How to put image as a background and create a birthday report?Summary: How to create a birthday card which need to put image as a background and make it staff name and birth date appear on top of the image?
-
Are there agreed standards used by the community when reporting dates?We have adopted the US format for all reporting with users then setting preferences at an account level. Are there any standards which are adopted by customers as best p… -
Is there a table which stores Absence balance for future date of and incremental planSummary: We are looking for a table or sql query which gives Absence balance as on future date. Absence plan is incremental, and accrual process will run for every bi we…
-
BI Impersonator roleSummary: We are trying to connect OTBI through OAC. To implement this, we need to know what privileges should 'BI Impersonator' have. As of now BI Impersonator role not …
-
Report on Benefits GroupSummary BEN_BENFTS_GRPContent Hello. I am trying to link the table BEN_BENFTS_GRP (name field) back to the employees (person_id or person_number). I have tried linking i…
-
Learning items with learning outcomes assigned are not displayedLearning items with learning outcomes assigned are not displayed. In the front we can see data according to this but not in OTBI. Using the "Workforce Learning - Learnin…
-
I am not finding the Observation Checklist in Add Content MenuSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Subject Areas for Employee dataSummary: I am trying to create a report of the employees in Fusion (we don't use HCM), but I can't get the data out of the system. I can see the worker's name and primar…
-
Job description report to add inactive and active job codesSummary: We are trying to add inactive and draft job codes in the job description report through SQL, we added the flags Active, Inactive and Draft in the SQL, still we …