OTBI
Discussion List
-
OTBI Subject Area/SQL to fetch HCM Approval Delegation detailsContent Hi, Does anyone know the OTBI subject area/Table names which can fetch the details of HCM Approval delegation in Person's Account Management page. Best Regards D… -
Goal Task detailsHi, Which Table or subject area contains goal task details? Regards, NivyaNivya Mathire 32 views 5 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Data issue- OTBI AnalysisSummary: We have an OTBI analysis to capture benefit details and I noticed that it's providing information for one legal entity although are three legal entities added i…Ayesha Iroshani 41 views 13 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Creating a Report in OTBI for New Hires, Name changes, LOAs, and TerminationsSummary: Hello, I need to create a report in OTBI for New Hires, Name changes, LOAs, and Terminations but I am unsure if this can all be on one report or if I would need…Latia 82 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there any standard report for GRN return ordersSummary: We need a report with GRN return orders with debit and credit records. Content (required): We need a report with GRN return orders with debit and credit records…
-
Rehired Employee gets the same due date from her first enrollmentSummary: Content (required): Hi there, We have a few cases in which people who used to be with the company and are rehired, get the same due date of old enrollments from… -
Reporting on Withdrawal Reason if excluded from transcriptSummary: If a person is withdrawn from learning, and the exclude learning from transcript is selected, I understand that the assignment status is changed to 'Deleted'. I…
-
Evaluation Report is not shown Answer Text and Comments attached to AnswersSummary: I created an Evaluation Report with following details like Question Text, Answer Text, Response List ShortText, Response Status using Learning Managment Real Ti…
-
Ethnicity causing Workforce Trend SA to produce inaccurate headcountWhen adding ethnicity to the Workforce Trend SA it causes the Period Start and End headcount to double/triple for those that have selected two or more races. I have atta…Andrew Mc 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Schedule Agent to run report last day of each monthSummary cannot select report to be sent on last day of each month.Mike Borghoff 31 views 7 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM
-
How to show Other compensation in the Job offer through OTBISummary: Unable to show Other compensation (Individual Compensation) present in the Job offer in OTBI. Content (required): We are unable to show Other compensation (Indi…Sujay Bhowmick 31 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
We need department and cost center details with effective state date in BI or OTBISummary: Hi Team, we need department and cost center details with effective state date. i tried in worker assignemnet real time but no effective start date. only two clo…AjayKumar Maddipati 31 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
"Number of Job Application changed to..." Code NeededDoes anyone know the code behind the following columns? For example, when viewing the numbers, the highlighted "Number of Job Application changed to Job Offer Phase" fie…
-
Need a query which show all pending transactionSummary: Hi Everyone, I need a query in which we can show all pending, stuck transactions along with the person's name and approvers' information. Like, the document pro…
-
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 91 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 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need report for Applied Receipts & Un-applied ReceiptsSummary: Hi Experts Can any one advise how to get the below 2 reports in AR Applied Receipt Register Un-Applied Receipt Register Content (required): Version (include the…Satya Mothe 33 views 4 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Receivables & Collections
-
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 23 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 299 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 22 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 31 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Enable Audit Log/System PerformanceHello All, We are interested to enable the Audit log files in Production and we want to know that what is the impact on system performance audit log is enabled once. We…Linga Murthy 41 views 1 comment 0 points Most recent by Madhu Chalamalasetty Reporting and Analytics for ERP
-
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 61 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM