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
-
Is it possible to use CASE to replace 4712/12/31 with CURRENT_DATEContent (please ensure you mask any confidential information): I'm using the Compensation - Salary History Details Real Time to return the "Salary Details"."To Date" fie… -
Custom ESS Audit ReportSummary: I am trying to find instructions on how to build a report that will contain all ESS transaction history (before and after data). Could someone please assist on … -
How to restrict Data Source in BI > Data Model > Data SourceSummary: Can we restrict the List Of Values from BI > Data Model > Data Source Content (please ensure you mask any confidential information): Customer is soon going to b… -
Termination Dates and Payroll Data Query or ReportHi So looking for a query/DM or report that I can edit/update to show termination details and payroll data combined? Basically, I have been asked to create a report to b… -
How to report on worker Area of Responsibility records assigned?Currently created an analysis report in OTBI to pull Area of Responsibility records against current active employee records. Tried testing with a variety of ways with di… -
Moved: Remove assignment 'O' and 'OT'This discussion has been moved. -
All Scheduled Absences Report Not Pulling an EmployeeSummary: There is a custom BI publisher report that our HR department runs every pay period to view absences for that pay period. For some reason, in the last pay period…
-
Specializations not pulling in Enrollment typeSummary: I pulled a report for Learning Assignments (To match the Learning Assignments Screen that summarizes a Team Members Learning Assignments) The screen shows the s… -
In BI Report we have date parameters when we apply morethan one year we get time exceeds errorSummary: Hi Team, Hope all are doing great! In Onbaording BI Report we have date parameters when we apply more than one year we get time exceeds error if we apply less t… -
Seeded data models renewal /shared/Human Capital Management/Workflow NotificationsSummary: We have compared with demo environment that we have old DM and templates in /shared/Human Capital Management/Workflow Notifications. How we can get latest /shar…
-
Reporting on Seniority DatesSummary: Our OTBI reporting only has 2 Seniority Date codes when there should be 5. Content (please ensure you mask any confidential information): When I run a simple re…
-
How to rectify No Access to BI Consumer RoleSummary: Hello Experts, In an attempt to remove catalogue access for Managers I have accidentally marked the custom folder in OTBI with BI Consumer Role 'No Access'. Is … -
Location or Functional access to Absences for Higher Grade ManagersSummary: I currently have a business case to develop an absence calendar which provides managers at a certain grade access to the absences for their Location and Functio…
-
OTBI Custom Dashboard look and feelHi Team, My customer has shared a requirement to customize a OTBI dashboard and wanted to view like attached image. Is there any option to make such graphical view? Plea…
-
Brazil HR unable to access the Custom folder under OTBISummary: Has anyone had issues with their Brazil HR being unable to see the Custom folder in OTBI? If I log in from Canada as this Brazil HR person, I can see the Custom…
-
Some job codes drop from report when I add minimum from grade rate valueSummary: I have a report from Compensation - Workforce Assignment Salary Real Time. I added job code (filtered to included >0499), job name, FLSA status and it's working…
-
Is there an audit/ query that we can use to pull the list of reports that uses a particular columnSummary: Hello SMEs, We are trying to get a list of reports that are currently pointing or exporting a specific column. Content (please ensure you mask any confidential …
-
multiple phone numbers on single rowSummary: I have an employee report returning multiple rows when the employee has multiple phone types. Does anyone know how to correct so that the report only shows one …
-
Can we run a BIP report with REST API datasource in Payroll Flow pattern?Summary: Dear Folks, I'm trying to call REST API method from BIP report to trigger a method in OIC. So, I created a BIP report with REST API endpoint URL as data source.…
-
A report that contain report name and the dm connect to itSummary: Content (please ensure you mask any confidential information): Hi all, My client wants to build a report that shows the report name and the DM connect to it. I …
-
OTBI Dashboard Prompt: Year, Quarter,MonthSummary: Need help on OTBI Dashboard Prompt: Year, Quarter, Month with Variable Content (please ensure you mask any confidential information): We are working on a custom…
-
24B: BIP - What is the OTBI subject area or tables to get transaction approvers from Learning?Summary: What is the OTBI subject area or tables to get transaction approvers from Learning? Content (please ensure you mask any confidential information): Please share …
-
We developed BI reports in English but user wants based on local Language how to show data ?Summary: HI We developed BI reports in English Language but user wants based on local Language need to show data ? if user from arbic from need to show arbic and if user…
-
ORC Offers Transactions Report but need to add Requsition Number in BI it is possible ?Summary: Hi Team, ORC Offers Transactions Report but need to add Requsition ID in BI it is possible ? if how can i add this , I'm new to ORC. PFA of query. Thanks, Ajay …
-
OTBI report to fetch goal plan and its goalsHello, I'd like to create an OTBI report to fetch all the goal plans created and goals associated directly to each goal plan - even if goal plans and goals have not been… -
OTBI Column Properties Data format First Name Last NameSummary: The current format is Last Name, First Name - is there a way to switch this with below Data Format? Content (please ensure you mask any confidential information…
-
New And Old Address ReportSummary New And Old Address ReportContent Hi All, I working on building a report which will populate Address Change ( Old & New) with Assignment & Location Change detail… -
HCM Position Hierarchy standard report code file required which is running in backendHi Team, We have a requirement to develop a new report as like "HCM Position Hierarchy" standard report, so please share code file or file path and report name so that w…
-
Need a report for Global transfer records with location old and new locationHello, I have requirement for report to show global transfer records with old and new location and also active inactive all employees with their salary if anyone have pl… -
Is there a way to give Delegations for Reporting?Summary: We would like a manager to allow an employee to pull reports for her direct reports We tried Role delegation and Approval Delegations but none of them help with…