Category 81
Discussion List
-
Compensation Details (Top of Stack) when End DatedSummary: Hi - We are looking to create a report where we are able to audit active employees where their salary was incorrectly end dated. The problem is that when the sa…Kyle Norris 71 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need help on arrears balance ReportSummary: Content (required): Hello, We are trying build a custom arrears balance for both active and terminated employees. We do not have anything available for terminat…Ganesh G 204 views 3 comments 0 points Most recent by Catherine Chan Reporting and Analytics for HCM -
table to pull the error details from transaction console.Summary: Hi All, I'm trying to build a report and looking to pull the error details from transaction console. I tried searching tables but I'm not getting the info, can …vamshi krishna-283622 385 views 8 comments 0 points Most recent by Arun Menon Reporting and Analytics for HCM
-
How can I get an interaction to filter on 2 columns at once?Summary: I have created a graph to show male/female by Grade level. I created an interaction to drill down to a report, however the interaction is only filtering on eith…Dannielle Dellucci 42 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM
-
Report to get the list of employees with multiple active relationshipsSummary: Report to get the list of employees with multiple active relationships Content (required): Hi Team, Greetings! With Global Transfer- there are some cases observ…Parag Hiremath 273 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Is there a way to encrypt the scheduled reports?Summary: Is there a way to encrypt the scheduled reports Content (required): We are looking into scheduling reports but we need to make sure there is an encryption in pl…Balazs Grajczar 76 views 6 comments 0 points Most recent by teresa.marciano Reporting and Analytics for HCM -
SQL query to fetch element status processing rule of a element.Summary: We need a SQL query to fetch the element status processing rule of an element. Version (include the version you are using, if applicable): 23APiyush Pokharkar-Oracle 1.3K views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Payroll Element and Related Elements InformationSummary: Payroll Element and Related Elements Information Content (required): In the Payroll Element screen we have Related Elements. We need to know in which table/subj…
-
OTBI report run for some users onlyDear , we have custom otbi report which is showing absences and working fine for all users but suddenly it is works for some users and not working for some users can any…Mirza_Adeel 53 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Bursting Query table from the reportsSummary: Bursting Query table from the reports Content (required): Hi Team, Greetings! Is there any table(s) which holds the queries included in the bursting query in th…Parag Hiremath 334 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Best practice for reporting on incomplete allocated checklists?Summary: Hi All, Does anyone have any "best practices" for reporting on incomplete allocated checklists? We have a business case to report on number of incomplete checkl…William_Johnson 62 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Extract information about the Job Board eQuest in ORCSummary: Content (required): Hello everyone, We are having problems extracting information regarding the publication of a job requisition. In particular, in addition to …Gerardo Peluso 14 views 0 comments 0 points Started by Gerardo Peluso Reporting and Analytics for HCM
-
Report on Training Hours for each learnerSummary: Hi all, We are trying to report on each learner's hours during one year - has anybody been successful in building this in OTBI? Thank you in advance for your re…Cora_Stanciu 31 views 3 comments 0 points Most recent by Emily Robinson Reporting and Analytics for HCM
-
CAGR(Compound Annual Growth Rate) Calculation in OTBISummary: Creating an OTBI analysis to calculate CAGR of the joiners in my org in last 3 years. Content (required): I am trying to calculate CAGR of the joiners in my org…Dinky Dudeja 52 views 2 comments 0 points Most recent by Dinky Dudeja Reporting and Analytics for HCM
-
ORA-01722 Invalid NumberSummary: Content (required): A report that used to work is now giving us an error ORA-01722: invalid number. Version (include the version you are using, if applicable): …Ratha Sun 342 views 7 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
-
BI Tables for compensation planSummary: Content (required): Hello experts, do you know which BI tables allows me to extract workforce compensation plan data? Thanks in advance for your time! Kind Rega…Valerio Curzi 52 views 6 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Is it possible to retrieve compensation component amounts entered in closed compensation campaigns?Summary: Content (required): Hello experts, our customer wants to add in compensation plan some columns retrieving compensation amounts entered in past campaigns. Is it …Valerio Curzi 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to generate employee listing report in Oracle fusion?Summary: Content (required): Employee Listing report Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications 23A (11.13.23.01.0) Cod…Radha, Rangu 543 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Function to convert accented characters to their plain ascii equivalents in BI reportSummary: Function to convert accented characters to their plain ascii equivalents in BI report Content (required): Function to convert accented characters to their plain…
-
OTBI->Cloud Benefits Sample for 401k, 403B, etc. Enrollments by Gender, Ethnicity, Participant CostsSummary: This is part of a series of sample reports created by Oracle BI and HCM Product Management. You can copy the setup for this report and add it to your Oracle HCM…Adam Gates-Oracle 34 views 0 comments 0 points Started by Adam Gates-Oracle Reporting and Analytics for HCM -
Can the parameter affect both the row and the column in the Matrix report prepared from the analysisI have a matrix report that I use on the Dashboard screen, and the column information consists of job name information. The row information is also from the locations. a…Cansel Karasoy 23 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Error Code U9KP7Q94Summary: Path not found - Check input path entered Error Codes: U9KP7Q94 Content (required): Hi All, Has anyone run into this problem before? We archived and unarchived …William_Johnson 235 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Best practices for Journeys reporting in Workforce Management - Checklist Real Time subject area?Summary: Subject Area: Workforce Management - Checklist Real Time Need: Leverage best reporting practices to drive adoption rates and system monitoring for allocated jou…William_Johnson 105 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Subject Area for Override LocationSummary: We have a requirement to query 4 different types of address for employees. HOME, US Resident Tax, Work Location and Override Location addresses. I am able to qu… -
OTBI Analysis - No results using subject area "Workforce Management - Worker Assignment Real Time"Summary: No results when creating simple analysis in OTBI using the subject area "Workforce Management - Worker Assignment Real Time" Content (required): Hello, I tried …Hazel De Castro 1.3K views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
can we create report on the missing candidates (unconfirmed candidates).There are some candidates who were not able to submit there job applications because of issues with being able to access the assessment. I need to check if we can create…Chetana Pawar 62 views 3 comments 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics for HCM
-
Analysis error - Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PSummary: Analysis of 3 Subject areas, if no prompts are selected, produce report, when selecting a prompt, analysis result in error Content (required): Analysis of 3 sub…
-
Reading SQL Error CodesSummary: Hi All, Does anyone have any documentation/point me in the direction of resources that would help us read standard SQL error codes when working in OTBI? Include…William_Johnson 33 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Does anyone know in which table 'Domicile state other than the District of Columbia' field is storedSummary: I am not able to find in which table the State card component 'Domicile state other than the District of Columbia' field from calculation card (Tax withholding …SowmyaSk 41 views 1 comment 0 points Most recent by Raju Sandepogu-Oracle Reporting and Analytics for HCM
-
How do I show all completions for same Course Title in OTBI report?Summary: OTBI report to show completions only shows first completion if title is the same. Need to get OTBI report to show the same data as the View Transcript (which ca…Aaron Reynolds 71 views 6 comments 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM