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
-
How to identify when a Job Code was last assignedSummary: We are working on cleaning up job codes. There are many active job codes and we don't want to inactivate them until we know when the last time the job was assig… -
RTF Template with Excel Template AlignmentWhat would be the best way to get the good alignment when using RTF and output is Excel. We have more number of columns ...Example see the date of birth. The same way it…
-
How to add AVG formula to PivotSummary: Using Subject Area Payroll - Payroll Balances Real Time to pull worked hours by date paid. The requirement is to display both Total YTD Hours and Average Hours …
-
HCM Embedded BIP ReportsContent Hi, I'm trying to embed a BIP report as an iFrame on Employee Self Service Page. The Binding Parameter which is available on the screen is PersonId. Below is the… -
Correct sorting of report in sql queryHi, I want to sort the numbered numbers in the sql query I wrote. but when I want it to be sorted as 1,2,3.., it is sorted like 1,10,11. I'm having trouble with two-digi… -
Embed BIP report in the Application UI pagesSummary Embed BIP report in the Application UI pagesContent Hi, OTBI Report can be embedded in the UI using page composer. But can we achieve the same for BIP report? I … -
Knowledge Management Article ViewsContent Hi, I was trying to run an OTBI analysis using the Knowledge Management - Article Summary Historical Subject Area to retrieve data on "# of Article Views and "# …
-
Master data historySummary: Looking for an Audit query, which shows old and new values of master data. Content Hi I am looking for a query to track changes in Master data (Position, Locati…
-
Convert Numbers to words in OTBI Report.Summary: Hi Everyone! I am trying to build a OTBI report for employees salary. Subject area used: Compensation - Salary Details Real Time. I want a column where it displ…
-
Rehire employee informationSummary: I need to create an OTBI analysis to get information about rehire employees. Content (required): Which subject area do I need to use to get the Action/ Action r…
-
R12 HCM OTBI subject area database table mapping spreadsheetSummary R12 HCM OTBI subject areas to database tables mapping spreadsheetContent These spreadsheets are published by Oracle OTBI Development. The spreadsheets document F… -
Is there a way to report on changes made an employee makes to their address or number?Summary: Is there a way to report on changes an employee made makes to their address or number? Content (required): Is there a way to report on changes an employee makes…
-
BI - CASE statementContent Wondering how we can use the CASE statement in the WHERE clause. I keep getting error 'Missing Keyword' and I dont see anything wrong with my CASE statement. It …
-
Query to get Transactional dataSummary: Hi Everyone, Currently, I'm working on a report, the requirement of this report is to pull the employee's current and proposed data. like the employee transferr…
-
Full-Time equivalent is not working within USING clause of a FILTER operator in OTBII have created an OTBI report using Subject area - Workforce Management - Employee Assignment real time and Full-Time equivalent i am fetching from the "Worker Assignmen…
-
Workforce Management - Worker Assignment Real Time - position Management Business UnitSummary: Which fusion table can provide value for OTBI field "Workforce Management - Worker Assignment Real Time - position Management Business Unit" ? Need to create a …
-
How to use "Replace" function in BIP Report Excel TemplateSummary How to use "Replace" function in BIP Report Excel TemplateContent Hi Experts, How to use "Replace" function in BIP Report Excel Template. Could you please sugges…
-
Embed BIP report on Employment Info Responsive UISummary: Embed BIP report on Employment Info Responsive UI Content (required): Developed a BIP report and used Assignment_id as parameter. We have placed it as Hyperlink…
-
How to restrict All subject area Access from Line manager roleSummary: We wanted remove all subject area analysis from line manager role. We are able to remove some subject are by deleting the transaction analysis privileges . Rest… -
I'm new to E-text template, how can I learn and How can we develop in Bi reportsSummary: Hi Team, I'm new to E-text template,how can I learn and How can we develop in Bi reports. Any suggestions . Thanks, Ajay Content (required): Version (include th… -
NULL value creating duplicates in UNION queryAfter adding NULL value to some columns , it is showing Duplicates in UNION query. Like: AUTHORIZATIONCODE, JOBDESCRIPTIONDATE, JOBEVALUATIONDATE.
-
Create Report from Tags and Experience sections in ConnectionsSummary: Content (required): Hello Experts, Is it possible to create a custom report for the fields in the Connections, more specifically for Tags, Experiences, Interest… -
Time Card Approver DetailsSummary Time Card Approver DetailsContent Hi Experts, Which table holds the information of who approved the time card. #1.HWM_TM_REC is having time card details. Whether… -
Line Manager access to personal data in subject area WFM - Person Real TimeSummary: Line managers don't have visibility on personal data in report based on WFM - Person real time subject area. Content (required): We have a custom line manager r…User_2025-07-18-02-04-51-132 15 views 4 comments 0 points Most recent by User_2025-07-18-02-04-51-132
-
OTL Approval workflow data - Current manager for approval, Submitted by, SubmissionSummary: Does anyone have an SQL for OTL Approval workflow data - Current manager for approval, Submitted by, Submission? Content (required): I am looking to develop a B…
-
Need to attached FF:Summary: Hi Team, We have a requirement in Oracle cloud recruitment where we need to attach FF for only US and Polad country. could someone help me to get this FF. Will …
-
Which subject area gives the payslip earnings?Summary: Report pullings details from Pyalip Content (required): Does anyone know which subject area I can use to get the payslip details as per the screenshot attached?… -
How to call a BI report when email id is created?Summary: How to call a BI report when email id is created? Content (required): Hi All, We got a requirement to send notifications to new joiners when their work email is…
-
How to find the Report path with the report nameSummary: I have the report received to one of the recipient. The recipient request to add another person name to the report scheduling. I do not have the information whe…
-
Create an analysis report to see the workflow for a specific Job RequisitionSummary: Create an analysis report to see all job requisition workflow Content (required): Does anyone know how to create an analysis to see all workflow for a specific …