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
-
Does anyone have a BI report query available that extracts data in the 834 ANSI HIPAA format?With template it would be nice to have. -
span of controlSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Why are some column headers clickable links in my OTBI report? What is the functionality of these liContent Hi, I would like to know why some of the column headers in my OTBI report are clickable links and others are not. I would also like to know the purpose of these …
-
How to fetch the contract end date of a future contract extension using OTBI?Summary: Hi All, We have a requirement to fetch the Contract End Dates of contract extensions that have a start date in the future. OTBI only seems to fetch the Contract… -
Issue in Dynamic URL in StructureSummary: We are trying to use dynamic url in structure tab in instance (https://ehzq-dev14.fa.ocs.oraclecloud.com/) to navigate to the report folder but the web applicat…
-
Disability status of My Contacts (People to Cover)Summary: Hi Experts, We have requirment to send email notification to employees when Employee added Contact Relationship (Me→Benefits→Before you enroll→My Contacts) with… -
Payroll administrator is unable to see records updated by Fusion HCMWe have an analysis created using subject area Payroll - Personal Payment Details Real Time. I can see all records having been updated by any user but our Payroll Admini… -
Is there usage and adoption reports for HCM?Summary: Is there usage and adoption reports for HCM? I see the adoption reports for CRM, but none for HCM. We need some info for a business case we are presenting to pu… -
What is the exact query to get all values of transaction consoleSummary: What is the Backend Query to get the transaction details of a particular transaction as it is appearing in the transaction console. Content (please ensure you m…
-
SQL Query to get HRBP assigned to an employee (when AOR uses organization hierarchy)Summary: We need a query to find HRBP assigned to an employee when Organization hierarchy has been used to assign the AOR(area of responsibility). It doesn't include any… -
How to identify hires as Internal or ExternalSummary: Using OTBI, I would appreciate recommendations on how to identify hires as either an Internal or an External hire. Thanks! Content (please ensure you mask any c…
-
SQL query to get the manager of a particular department in bip report in fusionI need to get a BIP report that should contains person information and department , Department hierarchy till level 3 including top department and the manager's name of …
-
Filter OTBI prompts to only certain criteriaI created a Dashboard for our Learning team, which includes a Course tab, as well as a Specialization tab. The analyses used in each tab filter for the appropriate Learn…
-
Deeplink for line mamager to see direct reportee performance document.Summary: Hi Team, @Naga M -Oracle , I see below deep link will redirect to particular document in redwood version for line manager only when he is a document manager. 'h… -
HR Analyst/Specialist - OTBI Report w EarningsSummary: HR Analyst/Specialist - OTBI Report w Earnings Content (please ensure you mask any confidential information): We have HR Analyst/Specialists that need the abili… -
In the BI Report Need to remove the schedule, jobs and jobs history from the setting option.In the BI Report Need to remove the schedule, jobs and jobs history from the setting option.
-
User Preferences in OTBISummary: Is there a subject area to report on user preferences under "My Account" in OTBI? Would this area report the same data as the user's "Correspondence Language" u…
-
Absence Record Not showing after Global Transfer Or TerminationSummary: Hi Guys, I’m unable to view the absence records after an employee is terminated or globally transferred. Could anyone please help me understand what might be ca…
-
How to identify Specific Column used Reports in BIPSummary: Hello Everyone, Is there any query we to fetch all BIP reports which are using specific column? Eg: Person_Number (Per_all_people_f) Can we pull all BIP Reports… -
If Position or Department attributes getting changes how to extract all the employees assignedSummary: If Position or Department attributes getting changes how to extract all the employees assigned to that position/department in fusion hcm Content (please ensure …
-
Which table stores Career sites details in Recruiting?Summary: Which table stores Career sites details in Recruiting? Content (please ensure you mask any confidential information): Version (include the version you are using…
-
BI/OTBI Report to identify list of all users who have access to a specific employeeSummary: We have a requirement to fetch all users who have access to view/modify employment data for a given user. We explored options and we can see such information is…
-
List of users using HCM Mobile app reportSummary: We need a list of users who are using HCM Mobile app as a report with BI or OTBI . where this information is stored in SaaS? Content (please ensure you mask any…
-
From which tables can I get the Workflow details of transactions archived in transaction console.Summary: Tables to get the Workflow task details of transactions archived in the transaction console. Content (please ensure you mask any confidential information): Vers…
-
How to get shift name start time, end time for certain date, from the work schedule caledarSummary: In oracle Fusion, We need a query to identify the shift name , shift start time and shift end time as the following parameters shall be passed Emp number Date C… -
OTBI ResourcesContent Resources to help you get the most from OTBI. Training Oracle Applications Analytics Cloud Service Videos (Oracle Learning Library) - many are no longer availabl… -
How to get shift name start time, end time for certain date after manually change the workSummary: I need to retrieve the shift name, start time, and end time for a specific date after manually updating the work schedule calendar. How can I get these updated …
-
How to report on previous person name in OTBI?Summary: I want to create a report in OTBI, that will show changes of person name - current name and previous name. Content (required): I tried Person Names/Person Names…
-
Issue with Retrieving "Workforce Scheduling - Workforce Schedule Real Time" subject area in OTBIHi , We have a client requirement to identify the scheduled number of working days using OTBI. For this purpose, we are utilizing the subject area: Workforce Scheduling …
-
Accurate Headcount Reporting in OTBI even after department changeMy goal is to accurately reflect the headcount by department, ensuring that the count includes only active employees, even if they have changed departments. Currently, w…