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
-
Logic on Audit bit map field in per_all_Assignments_m_ tableSummary: We are working on an audit requirement to track the insert, update and delete assignment records over a given period of time. We have enabled the audit for prod… -
Workforce Goals Goals Status Overview Real Time and Workforce Goals - Goal Plan Assignments RTSummary: Hello, I'm trying to create an OTBI report that requires two subject areas (Workforce Goals Goals Status Overview Real Time and Workforce Goals - Goal Plan Assi…
-
Excel document that shows OTBI subject area, BI duty role name and BI job role for access purposeSummary: Need an excel document that shows HCM OTBI subject area, BI duty role name and BI job role for access purposes similar to attached output that was available in …
-
How cHi, I want to write a query that re -
Any function is available that can be used in OTBI reports for calculating annual leave balance.Summary: Any function is available that can be used in OTBI reports for calculating Annual leave balance. It should work same as 'balance calculation' in oracle fusion h…
-
Line Manager information in OTBI reportSummary: If any employee is Line Manager for other employee record then we need to display 'X' value. Content (required): Ex: Output: In the above scenario 66789 and 123…
-
Primary or Null Address TypeSummary: Hi - I am working on creating a report of all active employees and contingent workers in our system along with information from Worker Assignment Real Time and …
-
Human Capital Management Transactions Real TimeSummary: Looking for the Human Capital Management Transactions Real Time tables. Content (required): I am looking to build a data model that captures HCM transactions in… -
How to remove certain part of a column after parenthesis in BI reportSummary: Hi All, I want to remove the part of Tax Reporting Unit column from where the parenthesis is starting. Please suggest the function to use this in sql. Example: …
-
Need a join field for Recruiting and Global HR other than Person_IDSummary: We are working on a new hire report where candidates flowed from ORC to HCM. Currently we are using Person_ID and Start Date in HCM and ORC as key fields. But f…
-
How do you bring back the last calendar date of the next two monthsSummary: Hi I've been asked to create a report where I list leavers in the next two months and I managed to find a report that shows leavers in the previous month to twe…
-
In Xsl template we are getting error like:sun.util.calendar.ZoneInfo cannot be cast to java.util.SimSummary: Hi Team, Hope everyone is doing good! We have an requirement, where we have to use Current date condition in xsl template as mentioned below, but we are getting…
-
Calculation using a UnionSummary: Is a calculation from two results using a Union possible? Content (required): I have a report which I'm looking to show the % of active employees who have a wor…
-
How to restrict Effective Date parameter in schedule process, not to generate on specific DatesSummary: We have an ADP Payroll Extract. During the scheduling process, where in Effective Date Parameter should not pass Saturdays,Sundays and should consider every alt…
-
how to find the SMTP server of the burst mailsSummary: Hi team, we created a custom scheudled report that sends email to employees and managers. The users are however not getting the emails for customer's security c… -
Creating Reports and Extracts: How to map/link application front end fields to back end database tabSummary Looking for a simple way to map application pages/fields to cloud database tablesContent Good morning, I have been digging through the schema documentation while… -
OTBI Anaylsis to retrieve Security roles by usersHello, How can I create an OTBI Analysis to pull users along with their Security Roles or by able search the Role to see all the users using that role? Any help is appre… -
Just like for each that populate several rows in Excel Template, can we do the same for columns?Summary: Hello, For the Recruiting module, our client wants to have a report that dynamically populates the Questions found in Questionnaires of Job Requisitions based o…
-
Alert Composer| Resource Alert| Time Stamp FormatSummary: Hi all, I have developed a resource alert where the requirement is to have only time in the format of HH:mm. By default the syntax is date along with timestamp.…
-
OTBI Color coding on rowsSummary: Hi Team, Can anyone please help us on achieving the below requirement in OTBI. We have the percentages on each of the Job row as shown. These percentages are th…
-
Pass Dashboard prompt and analysis filters to drill down analysisI have a summary analysis of employee count by home state in a dashboard using a dashboard date prompt to pull as of a certain effective date. I have other filter criter… -
Oracle BI Publiser for fusion . Applying parameters for excel dataset on element by expression.Summary: Content (required): Hi Gurus, I'm using an excel dataset with 'Element by expression' as explained on the image image . The question is: is it possible filterni… -
Need a report that shows assignment numbers that DO NOT have a tax card associationSummary: I'm looking for help on developing a query that will fetch Employee Name, Person Number, Assignment Number, and Assignment Effective Start Date for any assignme…
-
How to hide Mark as read and Mark as unread links based on condition in workflow notificationSummary: How to hide Mark as read and Mark as unread links based on condition in workflow notification(Checklist task) Content (required): Hi All, We got a requirement t…
-
how to call fast formula from SQLSummary: how to call fast formula from SQL Content (required): Hi All, Is it possible to call Fast formula from SQL to verify the FF results? Thanks, Venkatesan R Versio…
-
I am unable to fetch payroll details with worker and bank details in OTBI .Summary: When i take only payroll columns like payroll_id, payroll_name then i got output but when i select payroll columns with bank details or worker columns getting n…
-
How do I edit/access a bursing SQL?Hello, We need to review/edit a bursting SQL in one of our integrations. I can see the Bursting SQL icon in the DM Properties but I don't see an opportunity to change or…
-
HCM Extract Delivery Options - WebCenter ContentSummary HCM Extract Delivery Options - WebCenter ContentContent Hello Experts, I am working on HCM Extract delivery options - WebCenter Content! Does anyone aware of the… -
How can I get the absence entries for the next month to my query?I am preparing a report that will be sent to employee in the form of notification for the absence in the status of Saved for the next month. So how should I restrict my …
-
I need an example of a sql query that returns person names and roles.I need to prepare a report that will list certain roles. So how can I write the query about the names of the people and what roles they have?