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
-
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…
-
Unable to see data in "VOIDED_BY" and "VOIDED_DATETIME" in ANC_PER_ACRL_ENTRY_DTLS tableSummary: Unable to see data in "VOIDED_BY" and "VOIDED_DATETIME" in ANC_PER_ACRL_ENTRY_DTLS table Content (please ensure you mask any confidential information): We are a…
-
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…
-
Customizing the seeded workflow notification for Talent Profile - Manager added a Talent ItemRequirement to customize the seeded workflow notification. Scenario: When Manager or HR Admin adds a new profile item then a FYI notification gets triggered to the emplo…
-
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… -
[Sharing_BIP Report]: Redwood Profile Option Code listSummary: Extract list of Redwood Profile OptionCodes with value Content (please ensure you mask any confidential information): Some customers ask if there is any report … -
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… -
Person real time and Assignment real time securityWe have an OTBI analysis for passport and visa details. It combines the Person Real Time and Assignment Real Time subject areas. One employee has a current assignment in…
-
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…
-
BIP Report is taking more time while Using Bursting, Without Bursting it completes in 10 minSummary: Custom BIP Report is running for more than an hours and it is not bursting output to FTP(secure) while using bursting query. But when we are running the same re…
-
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…
-
What is the SA to use for Goals' Published Flag ?Summary: Hello, We need to display in an OTBI report the Performance Goals along with their Shared and Published flags. We are using Workforce Goals - Goal Status Overvi…