Reports
Discussion List
-
Report to show OTBI filters/parametersSummary Report to show OTBI filters/parametersContent Is there a report available, or a way, to pull report filters/parameters out of OTBI analyses to view? I have a lar…User_2025-02-08-04-25-10-086 55 views 4 comments 0 points Most recent by Caroline.E.B. Reporting and Analytics for HCM -
How to calculate the number of active assignments for a personSummary: Question from a beginner: How can I calculate the number of active assignments for a person to isolate profiles with potential duplicate assignments? Content (r… -
Seeded/Custom report indicating time spent in previous jobs before moving to current jobSummary: Please share any seeded/custom report that indicates the total time spent by employees in their previous jobs before moving to current Job Content (required): R… -
How to add a prompts of From and To date and allow the data to filter by this in OTBI?Summary: How to filter the data to be FROM and TO date on the salary change date. I need a prompt to be used to filter the data for these dates. Thank you. Content (requ…Max W 212 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
AOR Query Performance IssueSummary: Hi Everyone, Currently, I'm working on a report. The purpose of this report is to retrieve pending records. The main query works fine. I'm facing an issue with …
-
Tables to find leave approval detailsSummary: Tables to find leave approval details Content (required): Hi All, We got a report requirement to show leave details with who approved the leave. From which tabl…
-
Checkbox value not getting fetched in backendSummary: Content (required): A checkbox dff has been created in such a way that if it is checked then Yes value from the value set will be picked and if not checked then…Pranjal Mohla 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI Report unable to generate employment information prior to 2020Summary: We have an employee department dashboard which majority of our users run on a daily basis. This dashboard has prompts to support the kind of data that the user …
-
Cost Center Data not pulling in Workforce ManagementSummary: Content (required): Our reporting team have been trying to add Cost Center to numerous reports and as yet have had no luck. This current report attached, is loo… -
when we run the RTF template report we getting below errorSummary: HI Team, we have RTF developed template but now we have enchement on statement of text so we changed the matter but we getting below error. please assitance on …AjayKumar Maddipati 31 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
when we schedule the report we getting below error messageSummary: Hi Team, when we schedule the report we getting below error message. Thanks, Ajay Content (required): Version (include the version you are using, if applicable)…AjayKumar Maddipati 101 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Seeded list of action and action reasons for HCMSummary Need a seeded list of action and action reasons in HCMContent Hello Everyone, Hope you all are safe and healthy. I need a list of seeded action and action reason…Akanksha Jain 267 views 3 comments 0 points Most recent by Stefan v. Glabbeek Reporting and Analytics for HCM
-
We have onboarding 30days questionarie BI report, issue is not showing status in reportSummary: Hi Team, We have onboarding 30days questionarie BI report, issue is not showing status in report some of employess empty coming. I observed that employess statu…AjayKumar Maddipati 31 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Getting the value of Enable Position Synchronization field from Legal employer setupSummary: Getting the value of Enable Position Synchronization field from Legal employer setup Content (required): Hi Team, Greetings! Is there a report or diagnostic or …Parag Hiremath 21 views 10 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
What audit reports are available for HCM configuration?Summary: We would like to know the types of audit reports available for HCM modules (ORC, Core HR, Compensation, and Talent) that are configuration and not employee leve…
-
Agent - Promoted ParameterContent Hello all, As you help me a lot before, I would appreciate your advice. We build a DB. Combine few report: New Hires & Terminated employees. The BU is prompted. …
-
Oracle table name containing employment category informationHi, I need a list of cost center information defined in the system, can you share the table containing this information with me? I find the cost center information assig…Cansel Karasoy 580 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Need suggestions / opinions for sending termed records for xx days in reports and extracts.Summary: Hi Experts, we have a requirement to send all active records and termed records that were termed in the last 10 days. please note this is problem encountered pr…Jithin Mathews 21 views 4 comments 0 points Most recent by Jithin Mathews Reporting and Analytics for HCM
-
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…
-
Sending fails when encrypted PDF is being sentHello, I've to send a PDF file format with pgp encryption to SFTP server. I already uploaded the pgp key in BIP. When testing the file's sending, I am getting an error m…
-
Facing the issue in below BI report query error is single row subquery returns more than one rowSummary: HI Team, We have report I'm facing the issue when i run the report or scheduled the report i'm getting below error but I'm unable to find the issue ? ERROR : OR…AjayKumar Maddipati 41 views 7 comments 0 points Most recent by ROOPESH MADAN-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
-
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
-
Filter that will capture future date assignmentsSummary I created a report that is capturing Action Type: Terminate Work Relationship.I need to filter the report to only show scheduled terminations for a specific mont…User_2025-01-25-00-37-41-739 68 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
People review meeting How to identify the Metting submitted by HR or manager, Whic table we can see?Summary: i have created one people review meeting. i have added 2 employees' population and 2 reviewers' manager. i have logged in as 1 manager and submitted the meeting…challa praveen 21 views 0 comments 0 points Started by challa praveen Reporting and Analytics for HCM
-
Capture the Course and Offering StatusSummary: I need to capture course status and offering status. I have a requirement where I need to capture course status and offering status of the relevant course. Cont…Sanduni Pathirathne 11 views 1 comment 0 points Most recent by Sayali Pawar-Oracle 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…
-
Still we implemented Query level RTF templates, how can we implement in RTF level changesSummary: HI Team, Still we implemented Query level RTF templates, how can we implement in RTF level changes as per requirements . Any on help me on to learn RTF level . …AjayKumar Maddipati 31 views 3 comments 0 points Most recent by ROOPESH MADAN-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…