Reports
Discussion List
-
When does the STATE column in table HRC_TXN_DATA changes to 'INITIAL'Summary: An approval transaction is always showing as DRAFT status in the table HRC_TXN_DATA with STATE column having value 'INITIAL'. This transaction is not visible th…Anoop K N 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
How to remove null values in OTBI? If I change choice list to SQL, the Limit Values disappears.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
document recordSummary: If I upload documents to document records, I want a report to show me the details of the document as entered into Oracle, the ability to filter by document type…Asha Barnes 22 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Language translation in oracle standard notificationsHi, I want to edit the rtf template according to the language of the standard notifications that I want to edit in Oracle. For example, where can I edit the Turkish RTF …Cansel Karasoy 42 views 9 comments 0 points Most recent by Oriana L. Reporting and Analytics for HCM -
Fetching employee using BIP query if employee have Job changes and TerminationSummary: Fetch the details of employee who have job changes and termination details of employee Content (required): Hi, I am working on BIP query to fetch the details of…Kamini Kaushik-Oracle 492 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
OTBI external identifier not appearing when Department is selectedHello I am trying to get a specific external id type through OTBI. I've managed to do this using MAX (there are multiple types), but when I add the Department, position … -
OTBI Training Tutorials on YouTubeSummary OTBI Training Tutorials posted on YouTubeContent 26 OTBI, BIP & SmartView tutorials are now available on YouTube, Oracle Learning Library and Oracle HCM Cloud R1…User720640-Oracle 399 views 8 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BIP Report: Position title change data irrespective of their current employment status.Summary: Hi experts, I am looking for a report which can return previous and current employment fields if position gets changed. Mainly looking out for these fields: Pre…
-
Is it possible to create a pivot table "view" in Excel BI Publisher?Summary: Is it possible to create a pivot table "view" and one with a report in a regular table? Content (please ensure you mask any confidential information): I'm tryin… -
Exempt from State Income Tax Withholding Report QuerySummary: Exempt from State Income Tax Withholding Report Query Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there an existing re…Parag Hiremath 2 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
How to Join ZX_LINES and XLA_AE_LINES to Get Tax Details (Rate, Amounts etc.)Good Day Experts, How can I join ZX_LINES and XLA_AE_LINES? I have a custom tax report where subledger debit/credit amount (Item Expense or Revenue) is displayed then th…
-
I am trying to add Division to an analysisSummary: I am trying to create a "Master Employee Data" report that includes payroll information so I'm using the Compensation Details - Salary Details Real Time subject…Jenna Savage - Hunter Douglas 52 views 12 comments 0 points Most recent by Jenna Savage - Hunter Douglas Reporting and Analytics for HCM
-
Query to fetch DFF's used across modules in a PODSummary Query to fetch DFF's used across modules in a PODContent Hi Team, Please help with this: Please share query which shares all DFF's used across modules in a POD l…C.R.Balaji 442 views 2 comments 1 point Most recent by Silpa Sathyan Poyyara Reporting and Analytics for HCM -
Need to report on Work schedule with attached work pattern and attached holidaySummary: Hi Every one, I need help to develop one absence report where we can see work schedule and attached exceptions and workday/non workday. Below is sample output:-…Krishna Manmohan 12 views 1 comment 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM -
SQL code to fetch Overtime, bonus, commissions, merit increases, and locality pay for employeesSummary: Hi Experts, Please provide the SQL code to fetch overtime, bonus, commissions, merit increases, and locality pay for employees. Thanks. Content (please ensure y…Arti_Priya 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need to skip HTML tags while displaying in the outputContent Hi All, We are facing an issue in Performance Management in Fusion Cloud. In the back end database table in one of the column (HRA_EVAL_RATINGS -- COMMENTS) whic…
-
Need table names or SQL for Approved OTL timecard details in BIPSummary: Hi Team, I Need table names or SQL for Approved OTL timecard details in BIP. We need particular person entries and along with approver comments. Navigator->my c…Janardhan ACS-Oracle 258 views 5 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
XMLP Server - Security & User AccessSummary Testing security and user access of XMLP ServerContent Hi All, We are looking to restructure our Reporting Catalogue for our HR users where they will use a dashb…User_2025-02-05-05-51-12-049 30 views 10 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Is it possible to include Null values in BIP Report Parameter?I'd like to pull null values within my report. Is it possible to run the report with 'null value' parameter? -
Report on User Actions in Oracle HCMSummary: Good evening, I need to extract a report with all the actions performed in the system by users (e.g., hiring an employee, entering Performance Goals, etc.). Is …Guido Masciello 12 views 2 comments 0 points Most recent by Guido Masciello Reporting and Analytics for HCM -
Length of service calculationSummary: How to calculate Length of service from latest hire date of employee? Content (required): I am using Workforce Trend Real Time Subject Area, I need to show the …Raghavendra M 744 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI report returning Lookup codes, how to fetch meaning instead of codesSummary Few Talent profile attributes in OTBI report returning lookup codes.Content Hi, In the Person profile>License and certifications section few fields are lookup ty…Challa Vidyasagar 280 views 3 comments 0 points Most recent by ShivaBildikarMGS Reporting and Analytics for HCM -
Progression Ladder for a bi_query_reportSummary: how to join rates to per_grade_ladder_f and per_grade_steps_f for a bi_query_report to show Progression Ladder > Grades that belong to Ladder > Steps in Grade >…
-
While creating Value set on oracle fusion getting error.The value column is not valid. (FND-2806)Summary: The value column is not valid. (FND-2806) In value set TID_Grade_Value, value column LISTAGG(distinct(prv.value), '; ') WITHIN GROUP(order by prv.value ) "UPGRA…
-
Payslip - Other Deductions Section is showing doubled amountSummary Need help in determining if the issue is just with the BI Report or if the dataset is pulling in the wrong informationContent An employee had his garnishment (In…User_2025-02-04-08-51-08-912 53 views 2 comments 0 points Most recent by Saisandeep Nutheti Reporting and Analytics for HCM
-
OTBI report update historyWe have several OTBI reports being updated that are not deployed by our support team. How is the owner updated to System Account? Is there a way to get the audit history…Angela Grace 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to show person data at the time of absence submission in OTBI?Summary: We have a requirement to show the person data at the time of submitting their absences. But the OTBI report brings the latest job name, FTE, department, busines…Ridma Karunanathan 11 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
admin is unable to see contents in user foldersSummary: In the past we have been able to see the contents in a users folder when in Admin view. Now we can no longer see the files. Has anyone else experienced this iss…
-
Questionnaire report with Question that has multiple answers - duplicating rowsSummary: Has anyone successfully been able to get a report on questionnaires that has a 'check multiple choices' question on one row for an employee who selects multiple…Rachael Puthoff 22 views 2 comments 0 points Most recent by Rachael Puthoff Reporting and Analytics for HCM
-
How to pull data from Additional Compensation in BIP ReportsHello Experts, Does anyone know how to or who has available SQL to fetch these data from Additional Compensation ThanksJoliver Caangay 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM