Reports
Discussion List
-
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 521 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 73 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 33 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 69 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…
-
Why does the audit table PER_PEOPLE_EXTRA_INFO_F_ return no value?Hi all, I need to audit the PEI_INFORMATION1 field of the PER_PEOPLE_EXTRA_INFO_F_ table. I configured everything as stated in this document (https://support.oracle.com/…VincenzoCoppola 104 views 6 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
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…
-
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 271 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…
-
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 23 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
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…
-
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 -
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 …Rishita 33 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…Bala Kasineedi 326 views 11 comments 0 points Most recent by Kishoor_R-Oracle Reporting and Analytics for HCM
-
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…AjayKumar Maddipati 41 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
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…Fabiana De Arruda 15 views 2 comments 0 points Most recent by Janine Brown Reporting and Analytics for HCM