OTBI
Discussion List
-
OTBI Report for Department ChangeSummary: Hi Team I want to create the department report ,where employee's department changed from any department to a specific set of department. Report to pull both the…R Hemavathy 94 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI - Pull up Job before Effective DateSummary: Making an OTBI report where I need to pull up historical data Content (required): I'm working on a retirement report using OTBI, (which I am completely new to).…SeanWesche 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Join subject areas Human Capital Management and RecruitingSummary: How can I join the two subject areas below? Human Capital Management - Transaction Administration Real Time AND Recruiting - Recruiting Real-time Content (requi…
-
OTBI: Hidden Scheduling AgentSummary: I can't seem to find some currently running scheduling agents Content (required): Hello, In OTBI, I get 2 running agents I don't see. Others I see, but not thes…User_2025-07-18-02-04-51-132 22 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
How to get values entered in termination transaction details?Summary: How to get values entered in termination transaction details? Content (required): Hi Team, Greetings! Termination transaction initiated by the manager or HR Sup…Parag Hiremath 257 views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
What filtering should be used to show Active for a specified assignment category AND show terms...Summary: Using Subject Area WFM - Worker Assignment Real Time, I have a report that is required to show details of Active Limbo employees AND show terminations within th…
-
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 …JHaden3 23 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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…Cansel Karasoy 24 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
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 "# …
-
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…Ayesha Iroshani 63 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…User720640-Oracle 2.2K views 33 comments 30 points Most recent by Rishita Reporting and Analytics for HCM -
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…Utkarsh M 24 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…Aditya Jena 113 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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…VijayaBaskar Ranganathan 609 views 8 comments 0 points Most recent by Neena S Reporting and Analytics for HCM -
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 Reporting and Analytics for HCM
-
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?…Isabela Radivoi 74 views 5 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM -
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 …
-
Can OTBI pull payment Method details e.g concatenated bank account No and Sort code ?Summary: I want to add to my audit bank details Report the payment methods details such as concatenated bank account and sort code. Content (required): Not sure if possi…Isabela Radivoi 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reporting the termination screenHi, When I terminate the employee from the My Client Groups>>Termination>> screen, I want to report the part that opens in the screenshot below. I need a sql query for t…Cansel Karasoy 22 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Report to pull out the date since a position is vacantI have a business requirement to pull out the date since when a position is vacant. Is there a way to pull this out or does someone have a report that i can plug and pla…Girish Bhatia 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Parameter's label in two different languages.We have a requirement to display the parameter's label as per the language who logs in. The actual requirement is to display the label as per the users who logs in . If …
-
How to get the position level of a position from the top using OTBISummary: We have a requirement to get the position level of a position from the top. eg: CEO is the top position and should be at level 1, 2 directors reporting to CEO s… -
OTBI - Talent Review - Holding AreaSummary: Not everyone are placed in a box assignment, some are in the holding area. Content (required): Subject area doesn't seem to have a Holding Area field. I need to…Ratha Sun 32 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM
-
Talent Profile: How can I make CLOB fields visible in a report?Summary: Talent Profile: How to make Job responsibility, - description and - qualifications visible in an analysis? Content (required): Dear all I need to create a repor…Matthias Essrich 71 views 4 comments 0 points Most recent by David Pham-Oracle Reporting and Analytics for HCM -
Entity Relationship Diagram between ALL PVOs in Fusion HCM ModulesSummary: Entity Relationship Diagram between ALL PVOs in Fusion HCM Modules Content (required): Dear all - can we get ERDs for All PVOs from different HCM Modules from O…Nilanjan Biswas-Oracle 802 views 2 comments 4 points Most recent by Nilanjan Biswas-Oracle Reporting and Analytics for HCM -
Display Employee information as per attached imageHi All, I have developed an OTBI analysis to get employee emergency information. The requirement is to display the data pulled from the Emergency info OTBI report simila…Aditya Jadhav 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM